You should break the group list out into an OR qualification. Reason being that goups can be substrings of other groups. So take the following
Group;Group1;Group2; The like comparison will give mixed results, assuming the user is in "Group". If you format the group list as follows: 'AssignedGroup' = "Group" Then you can be assured you get the desired results (versus 'AssignedGroup' LIKE "%"+$Groups$+"%"). It is also easier on your database (lot less parsing involved). You should be able to generate the qual in a single set field action. 0. Drop the first char of the group list: ; 1. Tack on the beginning of the qual: 'FID' = " 2. Replace the delimitter with the middle qual: " OR 'FID' = " 3. Chop the last X characters (length of chars from step 2) and terminate the qual: " Then use an external qual in your table field. Axton Grams On Tue, Jul 21, 2009 at 12: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]* <[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. > > > > * ________________________________ * > This e-mail is the property of NaviSite, Inc. It is intended only for the > person or entity to which it is addressed and may contain information that > is privileged, confidential, or otherwise protected from disclosure. > Distribution or copying of this e-mail, or the information contained herein, > to anyone other than the intended recipient is prohibited. > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
