DefaultDimension filters in Dialog "Records to include" section

(1) Share

Report

Posted on by EI-17060651-0

Hello,

I was wondering how I could add dynamic filters in my dialog to allow users to add Dimension value filters ? I need to be able to add custom dimension values and based on their combination I could build DefaultDImension.

I need this to be able to filter out certain records based on what dimensions they have.

How could I achieve this ?

Thanks.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Subra 1,288 on at

Like (0)

Report
Copy link

Link copied!

Hi @EI-17060651-0

Could you please give us an additional information to provide a suggestion on this. Kindly let us know what you are trying to achieve based on that we can give a solution. Dynamics filters can be added by query in D365FO.

Thanks,
Subra

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,730 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I'm assuming you have a table in Records to include section of a RunBase/SysOperation dialog that has a field with default dimensions and you want to filter by individual dimensions.

Usually, you don't need to do anything, because the necessary filter fields are added automatically.

For example, here is a query with CustTable only.

Query query = new Query(); query.addDataSource(tableNum(CustTable)); new QueryRun(query).prompt();

But when you run the code, you'll see that the query dialog includes fields like Dimension.CostCentre:

Was this reply helpful? Yes No