21.04.2017, 19:12 | #1 |
Участник
|
goshoom: Filter for enum fields in OData service
Источник: http://dev.goshoom.net/en/2017/04/fi...odata-service/
============== It took me a while to figure out how to filter AX (Operations) enum fields in the URL for OData service (I was using Get records in Flow). For example, let’s say I wanted to get sales orders with status = open order. After a few failed attempts, I actually used classes generated by OData Client Code Generator, constructed a LINQ query and ran it. context.SalesOrderHeaders.Where(h => h.SalesOrderStatus == SalesStatus.Backorder).ToArray(); Then I intercepted the URL in an event handler for SendingRequest2 and finally got the answer. The filter must be set in this way: SalesOrderStatus eq Microsoft.Dynamics.DataEntities.SalesStatus'Backorder' No wonder I didn’t guess it. Источник: http://dev.goshoom.net/en/2017/04/fi...odata-service/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
Теги |
d365o, data entity, odata |
|
|