How to get Smart Dropdown to Pull values from a MultiSelect with more than one option chosen.

[Curtis Freudigmann]

The confluence community has a few questions out there pertaining to this but I haven't been able to find any definitive answers.

A break down of what I have and what I'm trying to achieve:

I have two forms. One form allows a user to select a team from a dropdown and then a text field to tie a change to that team.

The second form has a multiselect field which displays all of the teams from the original drop down, then a smart drop down to display all changes that match that team.

I have the forms working correctly, without displaying duplicate names for teams. My issue is that when I select more than one team in the multiselect none of the changes display. So it works when one team is selected but not when 2 or more are selected. I would like it to show all changes for all teams selected.

Is this a functionality that is possible?

Thanks

-Curtis

[Alex Medved _ConfiForms_ · Accepted solution]

As I understand you want to create a view and the question is how to setup correctly the filter to match the multi select field values, right?

And you want to have a view within another view and generate the filter for the inner view dynamically, is that right?

Or the question is about applying the filter on the "a smart drop down to display all changes that match that team"?

So, the dropdown will show changes that are only related to selected teams?

Have a look at "join" function - https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

(use it to construct dynamically your filter)

[Curtis Freudigmann]

For anyone else looking at this, the correct information was displayed by using a Rules macro to apply a filter on a field. The filter uses the join virtual function and looks like:

myField1:[entry.myField2.transform(label).join( OR myField1:)]

 Thanks again Alex for your assistance.