Hi, You are not supposed to filter ther returned collection. The Vendor Form should be able to limit the collection returned as dictated by your qualification.
The Vendor Form relies of ARDBC custom code hooked into the plugin server. To program an ARDBC-solution, you can choose for yourself how much, if any, support for qualification criteria you want to build into it. If your ARDBC-solution does not support the qualification criteria you send it, your only option may be to pull the content of the Vendor Form into a temporary regular form, and then have your table field connect to your temp form instead. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > 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" > > -- > This message was scanned by ESVA and is believed to be clean. > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"