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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
