Since the HelpDesk form 'Assigned Group' field is a single group you will have to reverse the like statement.
i.e. Say the 'Assigned Group' on a ticket is "Group Two". Your statement would produce an SQL of: 'Group Two' LIKE '%;Group One;Group Two;Group Three;%' which does not work. What you are looking for is an SQL of: ';Group One;Group Two;Group Three;' LIKE '%Group Two%' which would be a statement of: $Groups$ LIKE '%' + 'Assigned Group' + "%" This will be a table scan do you should add something else to the search that is indexed (usually Status or something like that). You may also want to use ($Groups$ LIKE '%;' + 'Assigned Group' + ";%") to make sure you don't get extra results. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Tuesday, July 21, 2009 12:10 PM To: arslist@ARSLIST.ORG 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
