How to apply filtering to an Editable List View on Multiple drop-down List Changes 

  • 24 February 2022
  • 0 replies
  • 105 views

Userlevel 4
Badge +13
 

How to apply filtering to an Editable List View on Multiple drop-down List Changes 

KBS100109

PRODUCT
K2 blackpearl 4.7
BASED ON
K2 blackpearl 4.7
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Objective

Where you have 3 drop-down list controls and you click on these drop-down list values to filter only the selected values and display them in an editable list view.

Before You Begin

Using an unbound rule you can filter the data in the editable list based on all the selections made in all three of the drop-down lists. The unbound rule can then be called on each of the drop-down list change events, this will result in the view being filtered based on the first selection made in the first drop-down and then when the second drop-down is changed, the filter will execute again but without losing the filtering selected in the first drop-down. Instead the view will then filter based on the selections made in both the first and the second drop-down lists (the same applies to drop-down three as well). This will allow multiple filtering to take place on different controls.

How-to Steps

1. Create a SmartObject and add three different Properties to it. In this scenario the following was used:

  • Name (Text)
  • Surname (Text)
  • Age (Number)

 

SmartObject.png

 

2. Create an Editable List View from the SmartObject and ensure that this SmartObject is the Editable List Data Source.

EditableListDataSource.png

 

3. Edit the Editable List and add three drop-down list controls.

4.Navigate to the Rule Breadcrumb tab and add a new rule (Do not provide the rule with an Event, instead just rename the rule), this will create an unbound rule which can be recalled eused in other rules.

Configure the Unbound rule further to resemble the images below:

RenameRule.pngUnboundRule.png

 

5. On each of the drop-down lists "Change Events" you would need to call the unbound rule. To do this locate the rule called "Execute another Rule" which can be found at the bottom of the Actions tab.

CallingUnboundRule.png

 

6. Save, Finish and Run the view.

*The behaviour will be noted as per the below tested scenario screenshot. Filters has been applied based on the selections made in each of the drop-down lists without losing any of the filtering made in the previous drop-down selections.

Result.png

 


0 replies

Be the first to reply!

Reply