Hi, I am not using ARDBC-solution. I am using XLink tool of NTuision to retreive data via web service.
Best Regards, Vahagn Misi Mladoniczky wrote: > > 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: [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" >>> >>> >> >> -- >> 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" > > -- View this message in context: http://www.nabble.com/filtering-of-collection-in-table-object-tp19087073p19142365.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"
