Mark, Are you attempting to do something like show all tickets that are assigned to the group that this user is a part of?
Are these groups that you have created application groups (groups created specific to your application that do not have an entry in the Group form)? Or are they ARS Groups that have an entry in the Group form? Joe ________________________________ From: "Brittain, Mark" <mbritt...@navisite.com> To: arslist@ARSLIST.ORG Sent: Tuesday, July 21, 2009 1:10:26 PM Subject: Table Search ** 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 mbritt...@navisite.com (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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"