Not sure what your screenshot is showing. Is this using RowGroup? If yes then use rowGroup startRender or rowGroup.endRender, similar to this example. If this doesn't help then please provide more details of what you are using. Maybe post your Datatables init code so we can see your config.
Ah, you want to show the number of entries (count) in the column with that value? That is not a feature of ColumnControl at this time I'm afraid, but it is one I can add to the list.
I just want to add to this feature request.
In addition to the count, I would like the option for searchList to be updated, to only show items from the filtered dataset, when filtering other columns, not the entire dataset.
Take your Basic searchList example:
If you filter out Office to Tokyo only first...
Then you still have the entire searchList entries for Position, not only those that exists for Tokyo office.
There is really no need to show the entries, that are not in the filtered set, since they don't update the table when selected anyway.
For reference, that is how Microsoft Excel works, and I find it very useful.
There is of course a pitfall here, because you don't want to update the column you are currently selecting from, in case you want to select multiple items. Only OTHER searchList columns should be updated.
SearchPanes has a cascade feature for exactly that sort of thing. Also, SearchPanes needs a bit of a rewrite. Those two points are not unrelated .
The numbers shouldn't be an issue, but a cascade option for ColumnControl is likely some time away, whlie I'm working on other aspects of DataTables. I had added it to the features "todo" list though.
Replies
Not sure what your screenshot is showing. Is this using RowGroup? If yes then use
rowGroup startRenderorrowGroup.endRender, similar to this example. If this doesn't help then please provide more details of what you are using. Maybe post your Datatables init code so we can see your config.Kevin
I don’t use rowGroup, I’m using ColumnControl - this is my configuration.
columnControl: [
'search',
'order',
[
'searchList',
{
extend: 'dropdown',
content: ['colVis'],
},
],
]
Ah, you want to show the number of entries (count) in the column with that value? That is not a feature of ColumnControl at this time I'm afraid, but it is one I can add to the list.
Allan
Yes, that’s exactly it. It will be very useful — thank you, Allan!
Hi Allan,
I just want to add to this feature request.
In addition to the count, I would like the option for searchList to be updated, to only show items from the filtered dataset, when filtering other columns, not the entire dataset.
Take your Basic searchList example:
If you filter out Office to Tokyo only first...
Then you still have the entire searchList entries for Position, not only those that exists for Tokyo office.
There is really no need to show the entries, that are not in the filtered set, since they don't update the table when selected anyway.
For reference, that is how Microsoft Excel works, and I find it very useful.
There is of course a pitfall here, because you don't want to update the column you are currently selecting from, in case you want to select multiple items. Only OTHER searchList columns should be updated.
Thank you for a great product.
Thanks for the feedback!
SearchPanes has a cascade feature for exactly that sort of thing. Also, SearchPanes needs a bit of a rewrite. Those two points are not unrelated
.
The numbers shouldn't be an issue, but a cascade option for ColumnControl is likely some time away, whlie I'm working on other aspects of DataTables. I had added it to the features "todo" list though.
Allan
Thank you for the hint about SearchPanes - I will definitely look into that.
/Michael