I cannot select values in a listbox in another folder in function of a listbox in the current folder

[luiz_damascena]

Situation:

I have a listbox (field = igest_ano_mes) in my folder, where three values ​​are displayed: 2018-03, 2017-12 and 2016-12. In this list box, "Always a selected value" is selected.

In another listbox (field = igest_ano_mes_remessa), the years / months considered according to the selection of the previous listbox are shown. For example, by selecting 2018-03 in the first one the information is displayed in the second one 2017-04,2017-05,2017-06,2017-07,2017-08,2017-09,2017-10,2017-11,2017- 12,2018-01,2018-02,2018-03.

I emphasize that they are displayed but not selected.

To force the selection, using the document properties, on the Triggers tab, in the Field Event section, I created an action, both when selecting and on change which selects in the field igest_ano_mes_remessa (used in the second listbox) according to the search argument '*' . With this, the second listbox gets all possible values ​​selected.

In Time: Selection Action - Selecting Possible Values ​​did not work ...

At this point, viewing through the current selections, I see that igest_ano_mes_remessa = *.

In a text box, using GetFieldSelections (igest_ano_mes_remessa), displays "*"

Using the command "= Concat (DISTINCT igest_ano_mes_remessa, ',')" in the same text box I see the values ​​2017-04,2017-05,2017-06,2017-07,2017-08,2017-09,2017-10 , 2017-11,2017-12,2018-01,2018-02,2018-03.

These are the values ​​I want to "deliver", to another folder, which is from another context and from another data model - but in the same qvw - where I have a field called ano_mes_egestao, which is used to populate a listbox.

In the current folder, through the Select action in the field, ano_mes_egestao, using the search "= Concat (DISTINCT igest_ano_mes_remessa, ',')" set on a button, I expected the values ​​selected in my current listbox (2017-04,2017- 05,2017-06,2017-07,2017-08,2017-09,2017-10,2017-11,2017-12,2018-01,2018-02,2018-03) appear checked in the listbox of the called folder.

But it does not.

When I pass a single value (= GetFieldSelections (igest_ano_mes)) through the same action "Select in field, field ano_mes_egestao, character search" = GetFieldSelections (igest_ano_mes "), it passes the value, and the listbox is displayed correctly marked in the other folder .

Why cannot I pass this multiple selection?

Any help is welcome.

Luiz Carlos

[boorgura · Accepted solution]

Instead of this as search string:

"= Concat (DISTINCT igest_ano_mes_remessa, ',')"

Please try this:

"='(' & Concat (DISTINCT igest_ano_mes_remessa, '|') & ')' "

[luiz_damascena]

It worked, Rakesh!

Thanks a lot!

I'll understand better later; for now, thank you!

[boorgura]

Simply put the search string for multiple value search should be

(2017-04|2017- 05|2017-06|2017-07|2017-08|2017-09|2017-10|2017-11|2017-12|2018-01|2018-02|2018-03)