Searching via FetchXML Query

(0) Share

Report

Posted on by Andy Whitworth

Hi,

I am attempting to incorporate some search functionality in my application which queries the Dynamics REST API using FetchXML.

I have found that when attempting to perform search it works fine on non-lookup fields but I am able to search on lookup fields (i.e. on the incidents entity, statuscode like %case created%). It looks like in this case the like is performed against the numerical statuscode as opposed to the display string (i.e. Case Created).

How can I perform search on lookup fields?

Regards,
Andy

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Flydancer 1,332 on at

Like (1)

Report
You can't. If you want to filter by statuscode, you have to use the statuscode instead of the label.

If you need to "find" the statuscode by name you can use something like:

Was this reply helpful? Yes No