Skip to Content (Press Enter)
2018-07-02 03-52-56
Gangadhara
316Views
3Comments
Solved
Multi selection fields list search
Question

Hi Folks,


I am unable to search multi fields. Could you please suggest.

As mentioned in screen shot, Here after selection of multiple proudct family, when click search , need to diplay only those related selected proudct family records in result. 

Could you suggest. 

0
0
10 Dec 2019
Copy Link
2024-12-02 12-15-17
Aravind EONE
Solution

Hi Gangadhara,

1) Create an action in the search List box on change.

2) you can get the currently selected values.

3) create a local text variable say "SelectedProductfamilyIds".

4) Loop the selected values, before loop assign that local variable SelectedProductfamilyIds = ", "

5) inside loop add same assign, SelectedProductfamilyIds = SelectedProductfamilyIds + ", "

now, this local variable contains for eg., ",1,2,3,"

6) Now, add this filter into your aggregate like, SelectedProductfamilyIds like "%," + entity.ProductFamilyId + ",%"

 This may help, try this.

See solution in context
0
0
10 Dec 2019
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Gangadhara,

Is this an OutSystems application? The screen shot doesn't seem to be? What are those "ProductFamily" buttons? How does the "selection of multiple product families" happen?

0
0
10 Dec 2019
Copy Link
2018-07-02 03-52-56
Gangadhara

Hi Kilian, 

Yes it is outsystems applications only. 


Those are not buttons, THoses are the fileds which selected in mutli selction box. 


Thanks

Gangadhara

0
0
10 Dec 2019
Copy Link
2024-12-02 12-15-17
Aravind EONE
Solution

Hi Gangadhara,

1) Create an action in the search List box on change.

2) you can get the currently selected values.

3) create a local text variable say "SelectedProductfamilyIds".

4) Loop the selected values, before loop assign that local variable SelectedProductfamilyIds = ", "

5) inside loop add same assign, SelectedProductfamilyIds = SelectedProductfamilyIds + ", "

now, this local variable contains for eg., ",1,2,3,"

6) Now, add this filter into your aggregate like, SelectedProductfamilyIds like "%," + entity.ProductFamilyId + ",%"

 This may help, try this.

0
0
10 Dec 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.