Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 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,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 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,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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans