Question

How to filter list view based on multiple values in another control

  • 15 November 2020
  • 4 replies
  • 78 views

Badge +1

Hi,

 

I am trying to filter a List View according to values in another control.

Filtering a list view according to a value in another control works when there is only one value in that control, but I need according to multiple values.

I tried doing this with a List box control but then saw that this is not enabled: Under section "Considerations" it states “You cannot use the delimited output from a multi-select control as a filter value in a list view or a SmartObject method”

Examle: 

List View contains all employees in my company: A to Z

In my department: A is a manager that manages B and C, D is a manager that manages E and F.

I build a control containing employees A and D and would like to see in the list view all employees of the department [Where manager column in employee list is A or D] thus: C, D, E, F.

 


4 replies

Userlevel 1
Badge +2

Hi Shmayah,

Please have a look at the links below to assist you with your question. 

http://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#Create/Views/ListViewSettings.htm

 

http://help.k2.com/onlinehelp/K2Five/UserGuide/5.3/default.htm#Create/K2Designer/Controls/Tree/TreeControl.htm%3FTocPath%3DCreate%7CSmartForms%7CForms%7CControls%7CInput%2520Controls%7C_____25

https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#How-Tos/PickerControl/WithCascadingFilter/PickerControlWithCascadingFilter.htm

Please let me know if these help you with resolving your problem.

Regards.

Userlevel 1
Badge +2

Hi Shmayah,

I’ve found another link that seems to be more related to your question that could be of help.
How to apply filtering to an Editable List View on Multiple drop-down List Changes 

https://help.k2.com/products/kbs100109

 

Regards,

Badge +1

Dear KevinZ,

Thank you for your response.

First link explains how to define filters on Views but all examples show filters on fields containing 1 value only (I would like to filter on multiple values).

Second link explains regarding tree control but does not explain on filtering.

Third link is more towards what I am looking for but still not it: The picker control is filtered according to 1 value in the Drop-Down List control (not multiple values) and in addition the outcome of the filter is shown in the picker control itself but I would like the results to show in the list view.

What I am looking for would be like: Show in my list view all results where value in column A exists in any line of column B (which could be another smart object column or a control with multiple values).

 

Thank you,

Shmayah

 

Badge +1

Dear Kevinz

Thank you again for your time.

I can not see the pictures in the page you sent me, is that only me or you as well?

This functionality is indeed useful also for me, but still does not answer my above need exactly, that is because in the dropdown fields I can only select one value each time (even when I can select 1 value for each column in the editable list per dropdown control), I would like to filter the editable list according to all values in a dropdown list.

 

Best regards,

Shmayah

Reply