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

Notifications

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,423 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,423 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

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
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

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