That worked and it only took 3 ½ minutes to run through 6,000 records. Thats not too bad. Even for a larger organization I could run this overnight and get a good list.
Thanks! J.T. Shyman Column Technologies _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Friday, December 07, 2007 1:57 PM To: [email protected] Subject: Re: Distinct Lists 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 doesnt 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) were 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"
