Hi,
XLink must have been built using ARDBC. ARDBC is the only way to create a
Vendor Form.
I would ask NTuision about the limitations of the product.
Does it support qualifications, and to what extent?
Best Regards - Misi, RRR AB, http://rrr.se
> 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: 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"
>>
>>
>
> --
> 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"
>
> --
> 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"
