Hello Vahagn I'm not sure if I've entirely understood what the problem is, but what I
think you're saying is: - you have a table with an EXTERNAL qualification - in the field referred to in the external qualification you have something like ["Item No" LIKE "%some_phrase%"] - you are not getting any error messages - you not getting any data returned in your table. Some things to check - "Item No" should not be in double-quotes. Check that it exactly matches the database name in the vendor form and has SINGLE quotes around it, e.g. 'Item No' LIKE "%some_phrase%" - are you setting the qualification using workflow? If so you need to remember to double up the double quotes. To start with, you could make the field read/write and just type in the qualification and refresh the table field until you're sure it works. Once you have something like this that you know is definitely working: 'Item No' LIKE "%some_phrase%" THEN you can set it using workflow, where "%some_phrase%" is the value of a field (lets call it zTmpChar) So you would set the external field to: "'Item No' LIKE ""%"+$sTmpChar$+"%"" in order to get the same result. Hope that helps Isabel -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of rg25 Sent: 22 August 2008 08:08 To: [email protected] Subject: Re: filtering of collection in table object Hi thanks for quick reply. There is no error message. There is the same collection independent of phrase in the "LIKE" condition. Best Regards, Vahagn Carey Matthew Black wrote: > > Dear rg25, > > You said: "But in this approach I can not filter collection." but you > did not explain what is failing. Is there an error message that you > are getting? > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. > > > On Thu, Aug 21, 2008 at 7:46 AM, rg25 <[EMAIL PROTECTED]> wrote: >> Hi all, >> >> I am using ARS 7.1 and have a problem regarding filtering of collection >> in >> table object. >> Table object using Vendor Form as supporting form. >> I want to filter a result from a Vendor Form by one column (e.g "Item >> No"). >> To do it I have use ["Item No" LIKE "%some_phrase%"] in external >> qualification to find all items which content the phrase. >> But in this approach I can not filter collection. >> >> Can you please help me to solve this problem. > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- View this message in context: http://www.nabble.com/filtering-of-collection-in-table-object-tp19087073 p19102469.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ***Disclaimer**** This e-mail and any attachments are for the intended addressee(s) only and may contain confidential and/or privileged material. If you are not a named addressee, do not use, retain or disclose such information. This email is not guaranteed to be free from viruses and does not bind Access in any contract or obligation. SERVICE GLASGOW LLP trading as ACCESS Registered in Scotland. No: SO301705 Registered Office: 191 West George Street, Glasgow , G2 2LD _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
