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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Query range-properties...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Query range-properties not working in ax 2012

(0) ShareShare
ReportReport
Posted on by NDingankar22 515

Hi, 

Greetings 

I have a list page in Ax 2012. The list page is based on the query 

The query has two datasources-Header and Line

One header can have multiple lines.

On the header level we have status field as In-Progress, Open, Closed.

I want the list page to just show the Inprogress status of header

So in the query object-ON the header table, i have put range on the status as Inprogress

However when i compile the form,refresh the query and aeverything, the status filed still shows all the status.

How can i ensure it shows only the "In progress" status

I have the same question (0)
  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,429 on at

    Hi NDingankar22,

    You have to use the literal value of the enum element you are setting the range on. In case it is "In progress" you should use that as the range value. You can check the query "SalesTableListPageOpen" as an example. The range is on the field "SalesType" and the range value us set to "Sales order".

    pastedimage1614886422938v1.png

  • NDingankar22 Profile Picture
    NDingankar22 515 on at

    HI,

    Thank you for the reply

    I did use the Literal value of the enum. But still the list page is not filtering.

    Any idea

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,429 on at

    Could you please share a screenshot of your AOT query and the enum?

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 699

#2
André Arnaud de Calavon Profile Picture

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

#3
Subra Profile Picture

Subra 493

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans