web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to filter data wit...
Finance | Project Operations, Human Resources, ...
Answered

How to filter data with OData ?

(1) ShareShare
ReportReport
Posted on by Ken Manhattan 558
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)
  • Suggested answer
    GirishS Profile Picture
    GirishS 27,843 Moderator on at
    Hi Ken,
     
    You can use eq and ne operator for the above scenario. It should look something like below.
    For more information you can refer to the below Microsoft documentation.
     
    Thanks,
    Girish S.
  • Ken Manhattan Profile Picture
    Ken Manhattan 558 on at
    Hi Girish,
     
    Thanks,
    If I want to filter a virtual field, is there a way ? or simply cannot ?
  • GirishS Profile Picture
    GirishS 27,843 Moderator on at
    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.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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
  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,573 Moderator on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 663

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 439 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 337 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans