Hi,
It is completely up to you how you implement this.
Doing a select '*' seems odd, as you are not sure which column comes where.
For the GetListEntry call, you can implemented the LIKE operator for a single
column, for example 'login', and then you do something like:
SELECT id,name FROM table WHERE login LIKE '%xxx%'
You then return id and name and any other optional column. You will also
populate the AREntryIdList structure with the id (nnn) converted to a string.
If you use this in something other than a Table-field, you must also implement
the GetEntry-call where you use the number returned in the above call:
SELECT id,name FORM table WHERE id = nnn
The nnn above is passed to the function as a character inside the
AREntryIdList structure.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Thanks for your explanation
> Still need some clarifications.
> My assumption is that RequestId equals to an identity column on a remote
> table.
>
> If the user searches for the login "username", and the "username" is the
> record with Request ID e.g. 100
> the qualification evolves to a query :
> select * from table where login = 'username'
> or
> select * from table where login like '%username%'
> (depends how the search is performed)
>
> but the getEntry function still gets 1 as an entryId.
>
> So my question is how can I control what is being passed to the function as
> an entryId.
>
>
>
> 2013/11/5 Jarl Grøneng <jarl.gron...@gmail.com>
>
>> **
>> Hi
>>
>> From the C API documentation:
>>
>> Unique identifier for the entry to retrieve. It must correspond to a value
>> in the external data source and must be unique, non-NULL, and either
>> character or numeric data. For an external data source, the entry ID can
>> have more than 15 characters. Therefore, the entry ID can consist of one or
>> more values of type AREntryIdType and is represented by the AREntryIdList
>> structure.
>>
>> --
>> J
>>
>>
>> 2013/11/4 Misi Mladoniczky <m...@rrr.se>
>>
>>> Hi,
>>>
>>> Field ID 1 has special meaning to Remedy. It is a max 15 character string.
>>> This is the key between the list of entries returned to you, and
>>> individual
>>> records retrieved with GetList. You must support field id 1 and the
>>> 15-character key in order to get this to work.
>>>
>>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>>
>>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
>>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
>>> Find these products, and many free tools and utilities, at http://rrr.se.
>>>
>>> > Hi listers,
>>> >
>>> > I'm trying to implement a custom ARDBCPlugin on the bassis of
>>> ARDBCSample
>>> > code.
>>> > So far I'm able to perform a seach on the entire table.
>>> > The problem is with a paramtrized query.
>>> > I got implemented support for a simle qualification criteria ( LIKE, =)
>>> > Even though the query is constructed properly (eg. SELECT * FROM
>>> tablename
>>> > WHERE login ='username') I have only first record returned (with
>>> Request ID
>>> > = 1) regardless of the value of the login field.
>>> >
>>> > Upon further investigation I found that the getEntry function:
>>> > getEntry(ARPluginContext context, String tableName, List<ARVendorField>
>>> > fields, long transid, String entryId, int[] fieldIds)
>>> > always gets 1 as a value of entryID parameter.
>>> >
>>> > My questions are:
>>> > Where the value comes from and do I need to implement something to
>>> handle
>>> > correctly returned value of entryId?
>>> > How to get through this problem?
>>> >
>>> > Any help will be greatly appreciated.
>>> >
>>> > Marek
>>> >
>>> >
>>> _______________________________________________________________________________
>>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> > "Where the Answers Are, and have been for 20 years"
>>> >
>>>
>>>
>>> _______________________________________________________________________________
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> "Where the Answers Are, and have been for 20 years"
>>>
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
