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 503

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

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Query range-properties not working in ax 2012

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

  • NDingankar22 Profile Picture
    NDingankar22 503 on at
    RE: Query range-properties not working in ax 2012

    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

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Query range-properties not working in ax 2012

    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,754 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans