Symptoms
I have a Choice control using a list (via SmartObject) as the data source. I'm using "filter data according to another control's value" which is working great. However I'd like to filter that resulting data again by a "status" column. Can this be done?
Diagnoses
This can be done by editing the rules for the Populate the Choice Control.
Resolution
You can filter a control based on two different values by editing the rules that Populate the Choice Control.
#1. Navigate to the Rule Designer. There should be a rule for When a Event ID Dropdown is Changed and in this rule should be a Populate the Choice Control rule. Configure this rule.
#2. Once we are editing this rule, we will need to go to the Filter tab. There should already be one filter, for the drop down. We will want to add a filter for Status = Active.
