I have a Matters dropdown and a Sub Matters dropdown that get their options from related tables. I want to make the choices in the Sub Matters dropdown dependent on the the selection in the Matters table. I know there needs to be a Query in the following expression section somewhere, however I am still trying to learn Appian and was hoping someone help me with the query and where to insert it..
Discussion posts and replies are publicly visible
In the local!SubMatterType, filter all the records having PSLM miscMatterSubType.miscMatterTypeId equal to local!selectedMatterType.
FYI,what you are trying to do at line 36 is not the correct way to save a value in a variable inside saveInto, instead use a!save(ri!variable, local!variable)
displayValue() should do the magic if you already have all the sub matters. If not, you can select the Matter, pass that as a filter in subMatter's query and then use the output of the query to populate the choiceLabels and Values of subMatter dropdown!