Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Query range-properties not working in ax 2012

Posted on by 487

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,417 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 487 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,417 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans