John, Like you, I am not 100% sure,, but I think the AR System now considers beginning and end of the string, if a % is padded to both sides of the string. Again like you I am old school and would consider all 3 cases, but I’m pretty sure I have learnt through an experience not too long ago, that it is not necessary anymore..
Joe From: John Sundberg Sent: Monday, March 12, 2012 10:26 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Using $GROUPS$ like not showing data in search menus.....can some guide me in right direction ** Just wondering - what if your group is at the beginning? Or - at the end…. $GROUPS$ like "%;1000000140;%" I think the above query assumes your group is in the middle of a group list? So - you would have to do something like: $GROUPS$ like "%;1000000140;%" OR $GROUPS$ like "1000000140;%" OR $GROUPS$ like "%;1000000140" I am not positive -- just mentioning… I did do something similar to this recently - and I did have to consider the case I mentioned. -John On Mon, Mar 12, 2012 at 8:10 PM, gok's <gmedise...@yahoo.com> wrote: I have fixed this now all the values are showing up. What i did was like this i have give as Jose said $GROUPS$ like "%;1000000140;%" and also gave the $GROUPS$ like "%;1000000140;%" in menus. it is working showing all the values. gok's wrote: > > Environment ARServer 7.5 patch 4 > DB:2005 SQL > > I have created a simple active link for certain group like "XYZ" changes a > search menu values to read/write only > A.l > Display > Qualification:$GROUPS$ like "XYZ" > IfAction:Change Field > Read/Write mode > > it is working for the group but in the search menu there are no values are > showing up . The user's who are in this group are not "Adminstrators" > they are having Infra Change Manager,Task Manager,....application level > permissions like that . > > can any one guide me am I missing any thing. > > Thanks > > -- View this message in context: http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-menus.....can-some-guide-me-in-right-direction-tp33476035p33491582.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" -- John Sundberg Kinetic Data, Inc. "Your Business. Your Process." Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"