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

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Invalid range value in AOT Query

(0) ShareShare
ReportReport
Posted on by 2,032

Hi ,

I have a weird issue using AOT query range. 

 

Below query lists the sales orders which are not cancelled. If you see the range value below, it is misspelled as ''Cancelled' instead of 'Canceled' .

pastedimage1676567246031v1.png

The query is fetching cancelled sales orders as well in dev and UAT environments , but not in Prod .

On debugging in Dev, it is assigning 255 for the above range value (as the value cancelled doesn`t exist in the system) and it proceeds to fetch the cancelled sales orders.

Why is the behavior different in prod ?

pastedimage1676567180776v3.png

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    302,779 Super User 2026 Season 1 on at

    Hi Anitha,

    I'm not able to answer why something would be different in your production environment. Is the code base exactly the same? As this seem to be related to a customization, I can't verify this in a standard environment.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 280 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 213 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans