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"