Brien, Normally the 'AssignedToGroup' fields (Field ID's 112 and/or 60000-60999) are used to restrict access to Field 1 so that users only see the records that they should see.
Is there a reason your not letting the system do this work for you? Are you trying to do something like: Login as User "X", and use a table field (in this specific case) to see what User "Y" would see? -- 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 Fri, Nov 20, 2009 at 2:14 PM, Brien Dieterle <brien.diete...@cgcmail.maricopa.edu> wrote: > Is there any easy way to write a query against a dynamic group field? > > I basically want $AssignedToGroup$ LIKE % ' $USER$ ' % (since the fields > might contain users), OR $AssignedToGroup$ LIKE 123; or LIKE 567; etc for > every group the user is a member of. > > Before I embark on building an AL Guide to chop up the groups field and > build this query on-the-fly and use that as an external() reference in my > table field... is there any easier way to do this? > > Thanks! > > Brien _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
