I will try this out and respond back .
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 13, 2011 3:12 PM To: [email protected] Subject: Re: Correct way to use LIKE operator and wildcards in table qual ** Then it cant be that bug.. It probably is escaping the double quotes as Greg Donaldson pointed out if you are using set fields to set the field that is used in the external qualification.. Joe From: Chowdhury, Tauf <mailto:[email protected]> Sent: Tuesday, September 13, 2011 3:09 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Correct way to use LIKE operator and wildcards in table qual ** Sorry, I’m on 7.6.04. I’m doing too many things at once… forgetting the basics of the list! From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 13, 2011 2:56 PM To: [email protected] Subject: Re: Correct way to use LIKE operator and wildcards in table qual ** Versions?? Earlier versions of 7.5 had problems with conditions on things like Search Menus, Join form qualifications, and I think table fields too, when one of the fields referenced in the qualification was not from the current table.. There is a workaround for that if what you are on is that earlier version.. I had that problem with Search menus and I figured out a workaround to get around it.. For the purpose of being able to save, choose a field on form a within that LIKE operator parameters, save,, export to XML def file, edit the XML def file, and then change the form name and field id to be form b and that field from form b.. Import it.. Joe From: Chowdhury, Tauf <mailto:[email protected]> Sent: Tuesday, September 13, 2011 2:46 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Correct way to use LIKE operator and wildcards in table qual ** All, I’m trying to either build an external qualification or just directly in the table qual itself, a string that will look something like this. ‘Field1onFormA' LIKE "%$Field1onFormB$%" OR ‘Field2onFormA’ LIKE "%$Field2onFormB $%" I received an error so I tried something like this below but still received an error: ‘Field1onFormA' LIKE "%” + $Field1onFormB$ + “%" OR ‘Field2onFormA’ LIKE "%” + $Field2onFormB $ + “%" Can someone guide me in the right direction? ________________________________ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ________________________________ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
