Formatting filter of post-rendered data works, but is ugly...

oliverater

Hi there,

I have a table where data from column(1) is appended onto column(0), and then column(1) is hidden. The table includes a dropdown selector to filter the data of column(0), however it does not include the appended column(1) data. As per this discussion, line 78 in the fiddle includes the option to format the selector data once the table has been rendered. Switching this for line 77 now includes all the data in column(0) + column(1), but will now show "Argentina", "Argentina; XXXX", "Argentina; "XXXXX", and so on.

Is there a way to format the selector data so it appears like the original column(0) data e.g. single country names and no "country1; country2", but will include results from column(1) e.g. so selecting Argentina shows 23 results, as opposed to 4.

Test case: https://jsfiddle.net/Lj3gqfvz/ (column(1) is visible for clarity)

Many thanks!!

kthorngren

I think this is what you want:
https://jsfiddle.net/3xagfz5q/

Use Orthogonal data combine the column data for the display operation. Otherwise for sorting and searching leave it as is.

Kevin

oliverater

Ah, so simple. I had managed to completely overlook that feature. Thank you!