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

Notifications

Announcements

Season of Giving Solutions is Here!
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 add range of nu...
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to add range of null value in AOT query

(2) ShareShare
ReportReport
Posted on by CU21091228-0 230
Hi Team,
 
I have created AOT query with InventTable data source.
I have to add range on custom field ABC_OrderGroup.
 
ABC_OrderGroup field have null record's and i don't want to display null record's.
So i have to add range on ABC_OrderGroup field.
 
Please let me know what value i have to pass in query range.
 
Categories:
Microsoft Dynamics AX
I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 238,129 Most Valuable Professional on at
    null isn't a valid value of any field. You likely mean the default value, which depends on the data type of ABC_OrderGroup field. For example, the default value of the string data type is an empty string (''), not null.
     
    When defining a range value in AOT, you can use ! operator for the negation (e.g. !"").
     
    If you need more help, tell us the data type of the field.
  • CU21091228-0 Profile Picture
    CU21091228-0 230 on at
    Data type is string only.
     
    I used ('') range and i have added query to view but it's not working.
  • Martin Dráb Profile Picture
    Martin Dráb 238,129 Most Valuable Professional on at
    If you want to exclude empty values of a string field, the value to use is !"".
     
    Also, make sure that you filter the right thing. For example, if you filter an outer-joined data source, the query will still return data from the parent data source.
     
    If you're using a view, don't forget to synchronize the database. Then you can look at the actual T-SQL code in SQL Server Management Studio.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 679 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 410 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 292 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans