How to filter data with OData ?

(1) Share

Report

Posted on by Ken Manhattan

552

Hi all,

If I understand correctly, for OData we can try to run it for checking from the URL it self. With simply like this : https://qqqq-sandbox.operations.dynamics.com/data/ReleasedProductsV2. Question is how to filter this, if lets say I want to display only ItemNumber=/ItemA1/ and Search Name is not blank.

Also if the field is Virtual field, is there a way to filter it ?

Thanks

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

How to filter data with OData ?

Hi Ken,

You can use eq and ne operator for the above scenario. It should look something like below.

https://qqqq-sandbox.operations.dynamics.com/data/ReleasedProductsV2?$filter=ItemNumber eq 'ItemA1' and ProductSearchName ne ' '

For more information you can refer to the below Microsoft documentation.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata

Thanks,

Girish S.

Was this reply helpful? Yes No
Ken Manhattan 552 on at

Like (0)

Report

How to filter data with OData ?

Hi Girish,

Thanks,

If I want to filter a virtual field, is there a way ? or simply cannot ?

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

How to filter data with OData ?

I am not sure on that - But you can try the same as you filter for normal field and see if it works.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

How to filter data with OData ?

Hi,
You can also take a brief look at this article:
microsoft dynamics - How to update entity of D365 Finance and Operations using OData? - Stack Overflow
Best Regards,
Hana

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (1)

Report

How to filter data with OData ?

Hi, Search and filtering on virtual fields are not supported.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entity-computed-columns-virtual-fields

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to filter data with OData ?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to filter data with OData ?

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates