I guess that would complicate things a bit, especially if you rebuild your people table regularly. If you only update the modified ones, it could still work, though - just make a copy of the SHR:ARDBC Overview Console (or whatever is similar that you're using), applying your filtering workflow to populate it.
Otherwise, you would be much better served having some DB-based solution in place. Rick On 12/7/07, J.T. Shyman <[EMAIL PROTECTED]> wrote: > > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
