Hi Isabel, Many thanks for detailed explanation. You have understood me exactly, with the exclusion of one point. Instead of "- you not getting any data returned in your table." I have data collection in a table. And I am using a "Vendor Form" for the table object. The main problem is that I can not filter collection which I getting from the "Vendor Form".
I have followed your suggestion. I have opened hidden qualification field and have tried single and double quotes manually (not via work flow). I mean type in the qualification and refresh the table manually. I have error message with single quotes. I have no error message with double quotes. It didn't help. Best Regards, Vahagn Ross, Isabel (Access LLP) wrote: > > 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: arslist@ARSLIST.ORG > 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" > > -- View this message in context: http://www.nabble.com/filtering-of-collection-in-table-object-tp19087073p19139209.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"