Yes, that's what I'm suggesting. It will be a significant effort to initially populate the form, but shouldn't take much to maintain. Maybe you could initially populate it over the weekend or at night or some other non-peak time.
The Categorization fields use the same validation workflow I'm talking about. Axton's idea is a more efficient one, but only if you have access to the DB, which it didn't sound like you did. Rick On 12/7/07, 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"
