I do not believe there are spaces, I think it should
be: (leading semicolon instead of space)
(Not $GROUP$ Like
"%;1;%" and Not $GROUP$ Like "1;%")
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J
Sent: Friday, October 27, 2006 8:21 AM
To: [email protected]
Subject: Re: QUESTION: MENU - NOT LIKE
Frank, Wouldn't it be
(Not $GROUP$ Like
"% 1;%" and Not $GROUP$ Like "1;%")The first term finds it in the middle or the end and the
second term finds it in the first position of the Group
list.
With "%1;%" it would find, and block, a group number
like 51.
HTH,
John J. Reiser
Software Development Analyst
Remedy
Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as
bright burns half as long.
Pay close attention and be illuminated by its
brilliance. - paraphrased by me
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Friday, October 27, 2006 10:11 AM
To: [email protected]
Subject: Re: QUESTION: MENU - NOT LIKE
(Not $GROUP$ Like "%1;%" and Not $GROUP$ Like "1;%" and Not $GROUP$ Like "%; 1%")
You need to catch it as the first Group, anywhere in the middle and the last group
On 10/27/06, Tyrone
Dee <[EMAIL PROTECTED]>
wrote:
**__20060125_______________________This posting was submitted with HTML in it___I have a Menu that shows all Users from the USER Form - no problem.I would like to restrict all users who are Administrators from the pull down menu. I tried:NOT 'Group List' LIKE "%" + "1" + "%"However, this is not working as there are other groups with "1" in the Group Number.Any assistance would be greatly appreciated.THANKS!
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
