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,827 Moderator on at

Like (0)

Report

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

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,827 Moderator on at

Like (0)

Report

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

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,565 Moderator on at

Like (1)

Report

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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates