Values are not populating from advanced filter into dialog form control.

(0) Share

Report

Posted on by R Shetty

121

I have a Create Dialog form in which I’ve added a Query Filter button that opens an Advanced Filter dialog, as shown in the screenshot below. In the Advanced Filter, when I select multiple vendor accounts in the Criteria section and click OK, I expect the selected vendor accounts to appear in the dialog form’s Vendor Account control. However, this is not happening.
The data source for the dialog form is VendTable.
Could you please share insights on how to retrieve the selected vendor accounts from the Advanced Filter and populate them into the Vendor Account control on my dialog form?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 298,734 Super User 2025 Season 2 on at

Like (0)

Report

Values are not populating from advanced filter into dialog form control.

Hi R Shetty,

What exactly do you mean by the Vendor account control? Is that the highlighted area on your screenshot? If so, it is already in that control, however, the control is pretty small and reading what got selected is hard.

Was this reply helpful? Yes No
Sohaib Cheema 48,518 User Group Leader on at

Like (0)

Report

Values are not populating from advanced filter into dialog form control.

Hi,

Your provided example (create payment proposal) is using RunBaseBatch.

As soon as you click button named create payment proposal, it goes to a class named CustVendCreatePaymJournal_Vend (which extends from another class named CustVendCreatePaymJournal)

Further the class named CustVendCreatePaymJournal extends RunBaseBatch

Create Payment Proposal >> CustVendCreatePaymJournal_Vend[class] >> CustVendCreatePaymJournal_Vend[Class] >>RunBaseBatch

RunBaseBatch do not behave like Forms.

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

Like (0)

Report

Values are not populating from advanced filter into dialog form control.

You said you expected the value automatically appear in your form control, but your expectation is wrong. There is no such a logic.

The example you showed is something else. It shows query range values added automatically by SysOperation (or RunBase) framework. Normal dialog fields are in the Parameters group; not below Records to include.

If you want this logic, are you sure you want to create your own form instead of getting it generated by SysOperation framework. It's even possible to use a custom form as a SysOperation dialog (and getting these controls generated there), but it's a more advanced scenario and not needed very often.

It'll be the best if start by explaining your business scenario. Then tell us why you decided you had resort to a custom form.

Was this reply helpful? Yes No
R Shetty 121 on at

Like (0)

Report

Values are not populating from advanced filter into dialog form control.

Hi @Sohaib Cheema,

For reference, as shown in below SS, in vendor payment proposal dialog, we have a filter option, where we can select multiple vend accounts and it appears in the dialog forms control. I understand it is not a form object here.

Can we bring in the similar way to retrieve the selected vendor accounts from the Advanced Filter and populate them into the Vendor Account control on my dialog form?

Was this reply helpful? Yes No
Sohaib Cheema 48,518 User Group Leader on at

Like (0)

Report

Values are not populating from advanced filter into dialog form control.

You are talking about forms, not about SysOperations framework or RunBase Framework. Forms are display objects.

Forms do not display the current ranges in the UI. The only way to view the current ranges on a form is by using the Advanced Filter icon.

Imagine I have a form, like the one shown in the picture below, which follows the Dialog pattern. The UI shown in the yellow circle is not a result of the query ranges, it appears because I explicitly designed it on the form.

If you want to see the current ranges you can go back to filters:

When you close this Advance filters, the ranges are still there on the backend. Selected Ranges are not going to change the UI of your form.

In short you have to collect the selected ranges and display them as you may want or do whatever you want with those ranges.

Was this reply helpful? Yes No