Re: QUESTION: MENU - NOT LIKE

[Guillermo Alfredo Torres Barron]

** I use this qualification   $GROUPS$ LIKE “%Administrator%”   Work good ;)   A question, somebady I said me that if I can use LIKE in a Run if quealification I do a FULL SCAN over database, It is true? Thanks in advance   De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] En nombre de Reiser, John J Enviado el: Viernes, 27 de Octubre de 2006 10:21 a.m. Para: arslist@ARSLIST.ORG Asunto: 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: arslist@ARSLIST.ORG Subject: Re: QUESTION: MENU - NOT LIKE ** I think it is something 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: ** 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___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ ........................................................................................... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ........................................................................................... __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___