Finance | Project Operations, Human Resources, ...

Adding Or Condition in AOT Query Range

(2) Share

Report

Posted on by MA-07051407-0

Hi All,

Hope you are doing Well, Just a simple question, How to add AOT query range with OR condition with 2 different fields?

Any sample code or example will be helpful..

Thanks

I have the same question (0)

All responses (6)

Answers (0)

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Adding Or Condition in AOT Query Range

Hi,

I don't think I understand what you are trying to achieve. Can you please rephrase it?

Or if you could write an x++ code or sql scripts that returns your required result then maybe I can help you more

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Adding Or Condition in AOT Query Range

Hi,

you must use || when you want to OR condition in query.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Adding Or Condition in AOT Query Range

Hi,

I assume you edited the question because now it's clearer.

let's assume your AOT query has table1. And you want to filter on field1 or field2.

what you need to do, is just add a range for one of those fields only. Let's say field1, then in the range value fill it with this: ((Field1 == "123") || (Field2 == "ABC"))

each range needs to be in parenthesis, and you can add more than one field in the range value even though you only added range for field1.

Try it and it will work

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Adding Or Condition in AOT Query Range

Hi,

Is your question answered, if yes then please verify the answers that helped

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Adding Or Condition in AOT Query Range

Hi,

Please don't forget to verify the answers that helped.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Adding Or Condition in AOT Query Range

This is one of the way

http://d365ffo.com/2022/08/06/ax-d365fo-filter-by-enum-value-in-an-aot-query/

In other way, from where the AOT query is being called, there you can call addrange method and pass the ranges as values.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Adding Or Condition in AOT Query Range

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

Adding Or Condition in AOT Query Range

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