Finance | Project Operations, Human Resources, ...

Custom filter is not working on form

(2) Share

Report

Posted on by SA-20091232-0

I have a custom form and I want to add a custom filter on that form. I have created an enum with 2 values: ALL and SUMMARY. I followed a tutorial https://dynamics365musings.com/executequery-method-in-d3656-forms/ for that purpose.
I followed the following steps,

I created a combobox and added my created enum to its properties.

Override the selectionChange method for this combobox and call the executeQuery method of form datasource on which I want to apply filter.

On the executeQuery method of the datasource, I have written the following code:

Following is the control for a custom filter

The filter does not work. What should be done, any suggestions?

Categories:

Microsoft Dynamics AX

Dynamics 365 Finance

I have the same question (0)

All responses (9)

Answers (0)

udaY-ch 5,133 on at

Like (0)

Report

Hi

You have extended the view and added the field and i assume you added the correct enum reference to the field.

Thanks

Uday

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Did you try to trace the code? Try to add break point on selection Change method, change the Enum value and start debugging, then tell us what the result is.

Thanks,

Waed Ayyad

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

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,431 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SA-20091232-0,

Can you confirm that "Auto Declaration" property is "Yes"

Otherwise can you please share with us more details ?

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Don't look just at what the query returns - look at the query itself to see whether your code created what you intended.

Does the field uses the same data type?

By the way, removing all ranges doesn't sound like a good idea to me. A possible approach is adding a range in init() and just changing its value, or using findOrCreateRange(). An even more robust approach is removing other ranges for the given field.

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SA-20091232-0

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
Suggested answer

Saalim Ansari 666 on at

Like (1)

Report
Hi @SA-20091232-0,

Just to add to what others have already mentioned:

Make sure the Auto Declaration property on your SummaryFilter combo box is set to Yes.

In your executeQuery() method, instead of clearing all ranges with clearRanges(), consider using findOrCreateRange() — this prevents accidentally removing important ranges applied elsewhere.

Reference: SysQuery::findOrCreateRange() - A better way to create dynamic query ranges

Here's a cleaner and safer version of your executeQuery():

public void executeQuery() { QueryBuildDataSource qbds = this.query().dataSourceTable(tablenum(ProjPostTransView)); int selectedValue = SummaryFilter.selection(); if (selectedValue != -1) // -1 can be used for 'ALL' { qbds.findOrCreateRange(fieldnum(ProjPostTransView, Summary)) .value(queryValue(selectedValue)); } else { // Optional: remove range if needed qbds.clearRange(fieldnum(ProjPostTransView, Summary)); } super(); }

Also, make sure your combo box’s selectionChanged() method calls ProjPostTransView_ds.executeQuery(); so the filter is applied immediately on selection.

Hope it helps ;) and let me know if you need more help!

Saalim

Was this reply helpful? Yes No
SA-20091232-0 89 on at

Like (0)

Report

HI @Martin Dráb,

Following is what my method returns: it returns me the query that I want . If I use the init method and put my range there and try to use the update the range on modified method of filter it still does not work (for modified event).

Auto declation is also yes.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Please answer whether the field uses the same enum as your filter control. You showed that the control uses *SummaryFilterEnum, but you didn't tell us anything about the data type of your *IsSummary field.

By the way, it's a bit surprising that the value of your range is 2. You said you created an enum with two values, therefore I would expect values 0 and 1. Other numbers can be used, of course, but it may be worth checking that everything is correct there.

Was this reply helpful? Yes No
SA-20091232-0 89 on at

Like (0)

Report

Hi @Martin Dráb,

I'm using the same enum for both, the filter combobox and the field of the table, both have the same enum, it returns 0 and 2 instead of 0,1.

Following is the screenshot of the enum.

Was this reply helpful? Yes No