SAP MDK - Search option in Object table control failing on using online service

[former_member649951]

Greetings,

We have an Object table and using online service to fetch the data into it. Once the data is fetched, tried to use search but its not working. On investigating, the control is making a service call on search with adding "and " at the end of query options and service is failing.

[bill_froelich · Accepted solution]

Can you please provide more details regrading what you mean by failing?

By default the client will attempt to add on filter criteria to any existing query options based on the mapped properties in the object cell through the use of the substringof function.

In the event that your backend does not support filtering on certain properties you can also use the DataQuery builder to construct your own updated query options when a search value is entered.

--Bill

[former_member649951 · Accepted solution]

Thank you for the quick reply Bill. Sorry for the vague description, by failing i meant its not returning any records. My understating was search filters already existing records but it is modifying the queryOptions. I will try utilizing DataQueryBuilder to achieve my requirement.

Thank you

[bill_froelich · Accepted solution]

Because the MDK automatically pages data into the table, we are not guaranteed to have all the data to perform an in memory search. As a result we make a call to re-filter the data using the search criteria in conjunction with any query option.