web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
CU21091228-0 230 on at

Like (1)

Report

Data type is string only.

I used ('') range and i have added query to view but it's not working.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 451 Most Valuable Professional

#2

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

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans