Mark, Maybe I am missing something... but how about using a Join form instead of an ugly table scanning search?
"groups a user is assigned" <-- (via group) --> "Ticket form" Then search by "user" in the "groups a user is assigned" table side of the join. You may need to add workflow on table drill down to open the Ticket form directly, but that seems like a small price to pay for better searches on the DB. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Jul 21, 2009 at 1:10 PM, Brittain, Mark<[email protected]> wrote: > ** > HI All, > > I want to do a table search based on the groups a user is assigned but can’t > get it to work. > > First I have a form called Assignees where each person is listed with one > record per group assigned. > On a display only form I have a table that lists the results from the > Assignees form where ‘User’ = $USER$ > Then I run a Active Link Guide that finds the users records in the Assignees > form an populates the result into a character field called ‘Groups’ like > this ;Group One;Group Two;Group Three; > > Now I want to search my HelpDesk form were records are assigned to those > groups. I have tried ‘Assigned Group’ LIKE “% + $Groups$ + “%” > > Any ideas would be greatly appreciated. > > Mark > ____________________________________________ > Mark Brittain > Remedy Developer > NaviSite > [email protected] > (315) 453-2912 x5418 (Phone) > (315) 317.2897 (Cell) > > Reduce Cost of IT with Managed Hosting and Application Services from > NaviSite. > Visit www.NaviSite.com Today. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
