Re: QUESTION: MENU - NOT LIKE

[CONDREA, Daniel]

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

** 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___

-- 

*****DISCLAIMER*****

The information contained in this communication is confidential and may be 
legally privileged. It is intended solely for the use of the individual or 
entity to whom it is addressed and others authorized to receive it. If you are 
not the intended recipient you are hereby notified that any disclosure, 
copying, distribution or taking action in reliance of the contents of this 
information is strictly prohibited and may be unlawful. Orange Romania S.A. is 
neither liable for the proper, complete transmission of the information 
contained in this communication nor any delay in its receipt.

*****END OF DISCLAIMER*****

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"