I see that I misunderstood the original post. What is the source of the vendor form? LDAP? You could write another ardbc plugin. Alternatively, you could write an api that uses the ARGetEntryStatistics call to return a result set that uses a grouping. The results of this operation could be written to the db or a single field, depending on what you are planning to do with it.
Axton Grams On Dec 7, 2007 1:56 PM, J.T. Shyman <[EMAIL PROTECTED]> wrote: > ** > > > > Rick, thanks for the input. > > > > Use an escalation to go through all of the records in the vendor form and do > a push fields into new form only if the combination of fields doesn't > already exist. This is basically what you just said, right? The only problem > with that is the vendor form could potentially have a lot of records and > something like this may take a long time to run and cause a lot of server > load both in AR and on the remote system (active directory) we're pulling > from. > > > > Let me try that and get back to you. > > > J.T. Shyman > Column Technologies > > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook > Sent: Friday, December 07, 2007 1:53 PM > To: [email protected] > Subject: Re: Distinct Lists > > > > > > ** > > > I'm not aware of one, and there have been several threads on the list over > the past few years discussing the topic. You'll have to use a SQL command, > unfortunately. About as close as Remedy gets to that functionality is > enforcing unique indexes, which is a little extreme for what you're trying > to do. > > > > > > Just had a brainstorm on this - what if you made your own distinct form by > pushing in the first iteration of each unique value from the main form? You > could have workflow validate the uniqueness of the values rather than using > indexes. Then you could do your searches against your already filtered > form. > > > > > > Rick > > > > On 12/7/07, J.T. Shyman <[EMAIL PROTECTED]> wrote: > > Is there any way in ARS 7.0.1 besides using a search menu to generate a > distinct list entries in a field on a vendor form that cannot be queried > directly using a SQL query? > > The problem I'm having is that I've had to use menus to create two such > lists and I want to loop through both and add the combinations of "Menu > A/Menu B" to another form using a push fields. > > J.T. Shyman > Remedy Consultant > Column Technologies > [EMAIL PROTECTED] > AIM: JToddShyman > Y!IM: MCIQuincy > > __20060125_______________________This posting was submitted with HTML in > it___ > > __20060125_______________________This posting was submitted with HTML in > it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
