RESOLVED: QUESTION: MENU - NOT LIKE

[Tyrone Dee]

Title: RE: ARERR 405 exporting Display Only form to .def file

** Thanks to everyone for their help - here it is:   NOT(('Group List' LIKE "1;%") OR ('Group List' LIKE "%;1;%") OR ('Group List' LIKE "% 1;%"))     From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: October 27, 2006 11:49 PM To: arslist@ARSLIST.ORG Subject: Re: QUESTION: MENU - NOT LIKE ** Hi All,   When a user is defined "the user" belongs to one or more groups. Usually this functionality is implemented using a normalized representation. Remedy's adds to the user's definition every group ID. The result of this operation is a string. For example ";1;2;3;4;".   Finding what users belongs to a group it is a string operation not an SQL operation.   In an older version of the ARS, the developer had to be very careful. There was an extra space.   Daniel From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: 27 October 2006 18:20 To: arslist@ARSLIST.ORG Subject: Re: QUESTION: MENU - NOT LIKE ** Try this qualification:   NOT ('Group List' LIKE "1;%" OR 'Group List' LIKE "% 1;%" OR 'Group List' LIKE "%;1;%")   --Thomas   ----- Original Message ----- From: Tyrone Dee Newsgroups: gmane.comp.crm.arsystem.general Sent: Friday, October 27, 2006 08:16 Subject: QUESTION: MENU - NOT LIKE ** 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! __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___ __20060125_______________________This posting was submitted with HTML in it___