Ok, maybe I should mention the source is Active Directory J.T. Shyman Column Technologies
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, December 07, 2007 2:00 PM To: [email protected] Subject: Re: Distinct Lists "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. " That's a really expensive way to achieve the goal. You are adding inserts, updates, and deletes to an operation that otherwise doesn't require it. Create a db view that gives the data set you want from the existing data, then put a view form on top of it. Axton Grams On Dec 7, 2007 1:52 PM, Rick Cook <[EMAIL PROTECTED]> wrote: > ** > 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___ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
