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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / LJ Dynamics Writings - D365 / How to apply AOT query rang...

How to apply AOT query ranges in D365FO?

Views (28)
Layan Jwei Profile Picture Layan Jwei 8,097 Super User 2025 Season 2

In this article, I'm going to show you how to apply different types of ranges to AOT queries. We'll go through simple and complex ranges.

  • Let's first create a simple query that has "CustTable" inner joined with "CustGroup"

    Create AOT Query

  • If we want the query to return values where the enum "Blocked" field value is Never, then it's either we type the value Never directly or type CustVendorBlocked::Never
    ** It's not recommended to filter on the enum integer value

    Enum range first way

    Enum range second way

  • If we want the query to return values where AccountNum value is "US-001", we can add the string value US-001 directly

    AccountNum single range

  • Now what if you want to filter on AccountNum "US-001" OR "US-002", you can do it in two ways: 
Read more »

This was originally posted here.

Comments

*This post is locked for comments