Orthogonal Data and Select Dropdown Filters

silkspin

I am having a problem getting the select options in a dropdown filter to show a different word to the source data. I can replace the display name and get the correct results for filter and sort but the option value isn't updated.

In the test case I've done the following with San Francisco...

Display = San Fran (this is the new name in the column.. the correct result)
Filter = California (searching on California just shows San Fran.. the correct result)
Sort = California (San Fran appears before Edinburgh... the correct result)

The dropdown filter still shows San Francisco. I would like this to show California. Is this possible without breaking the cascading filter?

http://live.datatables.net/xexuqige/1/edit

kthorngren

You will need to use cell().render() to get the orthogonal values. Loop through all the cells using cells().every(). Something like this:
http://live.datatables.net/turirore/1/edit

Kevin

silkspin

@kthorngren that is brilliant! Exactly what I was looking for. Thank you very much for solving it.