Creating filter on Table control

raj chaudhary

September 19, 2017 at 9:41 am #4561

Hi,

We have a table to show Person information (list). We want to create filter on City column (similar to excel) to show unique cities. Customer can then select multiple cities and filter data. Screenshot attached.

Could you please suggest if there are spark controls/api we can use for this.

Thanks

Raj

SPARK Support

September 19, 2017 at 1:33 pm #4565

Hi Raj,

The Table’s search() method does provide the option to pass a function to be used as the comparator:

http://support.salientprocess.com/docs/enterprise/Table.html#search

You could build a custom function that compares the value with a list of values, such as if the value exists in a Map to return true or false.

Regards,

Stephen P.