EPICOR KINETIC APPLICATION STUDIO — Dependent Combo Filtering (Cause filtered by Reason)

[mohbatrai (Mohbat)]

Two dropdowns on the same form:

1. Reason combo — control: Reason.ReasonCombo, EpBinding: porView.FailedReasonCode (e.g. selecting “Damaged” sets porView.FailedReasonCode = “DM-D”)

2. Cause combo — control: UserCodes.UserCodesCombo (reusable combo) Base filter (built-in): CodeTypeID=‘?{CodeTypeParam}’

Requirement: when Reason changes, Cause should dynamically reload showing only UDCodes where CodeTypeID = the current porView.FailedReasonCode value (e.g. Reason “Damaged” → Cause shows only UDCodes with CodeTypeID = ‘DM-D’).

Filters Append is not working with the dynamic value: while WORKS (hardcoded) CodeTypeID=‘DM-D’ →

But every dynamic token variant tried in Filters Append FAILS, including: CodeTypeID=?[FailedReasonCode]
CodeTypeID=?[porView.FailedReasonCode]
CodeTypeID=?{porView.FailedReasonCode}
CodeTypeID=‘?{porView.FailedReasonCode}’
CodeTypeID=‘{porView.FailedReasonCode}’
CodeTypeID=‘{FailedReasonCode}’
CodeTypeID=‘?{FailedReasonCode}’

[tom_osborne]

I’ve never tried this dynamically, but when using the UserCodes combo, you need to set a Filter Parameter.

You can see in the “Filters” field the value has been set to:
CodeTypeID=‘?{CodeTypeParam}’

So you need to set that parameter’s value in the “Filters Params” field as follows:
CodeTypeParam=?{porView.FailedReasonCode}

It might not need the question mark, not sure.

A simple example I have used as follows:

[dcamlin (David Camlin)]

No Filters Append.

Try:

Filters: CodeTypeID='?{CodeTypeParam}' ← Curly braces, single quote

Filters Params: CodeTypeParam=?[FailedReasonCode] ← square brackets, no quotes

For this to work, both comboboxes need to be bound to the same dataview.