Filtering Table According Selected Dropdown Options

[halil]

hi people,

i have a query to bring some data. i added 3 dropdown to filter the table. i used Search term to filter but i can not combine 3 filter together. for instance 1st filter is category filter, 2nd filter is seller, 3rd filter is booking number.

i used && operator to use 3 filter together, but it did not work too

[MiguelOrtiz]

HI there @halil,

Have you considered using the default filters functionality? A post here that it is helpful How to use setFilterStack to filter values in an array - #2 by mckenna

Best,
Miguel

[halil]

Hi Miguel,

many thanks. Let me check.

best regards.

[halil]

hi again,

i used normal filter, and nested filter but when i run 3rd filter, i am getting following error.

and i want to see only related dropdown options. for example i have 100 booking in different categories. when i select adventure, i want to see only adventure category's booking in dropdown menu, not all booking. in order to do that i am using table.data as data source for dropdowns.

[MiguelOrtiz]

Hi there @halil,

I see what you're doing there.

Firstly, you can use the default filters section within your table set up and reference your select values there.

Within your select2 data source, you can add a filter.

{{ select1.value ? yourdatasource.data.filter(x => x.category === select1.value) : yourdatasource.data }}

The terniary will take in account situations when nothing is selected in your category dropdown

Here are some useful posts:

Helpful tip on using intersect on default filters on new table (Filtering arrays)

Before sharing what I learned The example So I'm building a custom filter component for it to be more user-friendly and more granular and it works in tandem with the default filter section of the new table component. Although I hit a big wall with matching arrays with other arrays, to be more specific, when we are dealing with numbers. It's a table that it's connected to two other tables, so a little bit complicated. [image] [image] I had to make use of a lot of custom columns in order to …

How to use setFilterStack to filter values in an array - #4 by mckenna (in case you are using multitags)

[halil]

hi Miguel,

many thanks for your help, i really appreciate that. instead tag, i used string, it works.

i also want to share the way, in case someone needs.

1st, with sql query i get the data, and convert the tag into strings.
2nd, i need to filter the data based on 3 different column variables, so i added 3 select/dropdown menu

• As data source in selects, i used following block of code. because i need to see related values, based on each filter

{{ select5.value ? table4.data.filter(x => x.kategorieName === select5.value) :table4.data }}

• for the last filter, following one is used.

{{ (select4.value ? table4.data.filter(x => x.schedulerLoggerBookingFixedReason === select4.value) :table4.data) && (select5.value ? table4.data.filter(x => x.kategorieName === select5.value) :table4.data) }} 

3rd, those selects are added as Default filters.