Add filter/range to a query in D365FO in Visual Studio

(2) Share

Report

Posted on by CU09091357-0

600

This query is standard and is used in a report, I created an extension of it.

It uses the BankLGGuarantee table, all I want to do is add a filter (or a range), in order to not retrieve the records that have a Status value of 37 (Status is an enum).

Can someone help do this one without a code, or if the code is a must, how to do it?

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

Waed Ayyad 9,149 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @CU09091357-0

Add !Enum symbol value that you want on the range instead of !37.

Check SalesTableListPage query:

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Verified answer

CU09091357-0 600 on at

Like (1)

Report
Copy link

Link copied!

Waed Ayyad, thanks.

- Create an extension of the query

- Add the value of the range

- Duplicate the report

- Restore the dataset

- Create extension of the menu item and change the report property to open the duplicated one

- Build and deploy the report

The above steps resolved the issue in my case

Was this reply helpful? Yes No