Searchable drill down rows
Searchable drill down rows
Hey all! Heres what I am trying to achieve.
A table with drilldown rows that are searchable from the same box.
As per Allans blog post on drill down rows, I have setup my table and pulling my data through great.
I am just trying to work someone to make these rows part of the search box. I understand at the moment that each of the drilldown rows are dynamically created and thus unsearchable by the box. I have also thought of doing the drill down rows as hidden rows in the table but sorting would then also stuff all of this up.
I need someone for the search box to include the drill down data but then the data still dynamically paired to the row.
Thanks for your help!
A table with drilldown rows that are searchable from the same box.
As per Allans blog post on drill down rows, I have setup my table and pulling my data through great.
I am just trying to work someone to make these rows part of the search box. I understand at the moment that each of the drilldown rows are dynamically created and thus unsearchable by the box. I have also thought of doing the drill down rows as hidden rows in the table but sorting would then also stuff all of this up.
I need someone for the search box to include the drill down data but then the data still dynamically paired to the row.
Thanks for your help!
This discussion has been closed.
Replies
1) to have your "drill down" data actually also sit in a column in your regular rows (but have it set hidden). This way, it will be searched by the global search.
Depending on what you are putting into the drill down rows, this might require a lot more processing or data over the wire.
2) if you're using server side processing, modify the server script to also search the table(s) that have the data you would place into the drill down rows.
In regards to point 1, that is the way I had thought I would have to do it but was looking for a slightly neater way... if possible?
Can you elaborate on point 2? I dont quite understand what you mean.
I did notice you can write a custom search function http://www.datatables.net/examples/plug-ins/range_filtering.html do you think it would be possible to have the drill down data sitting on the page and this function return the row numbers to display?
if you WERE going to have the data on the page (or without server side processing), then I can't think of any reason why you wouldn't have it in an inner column (since it would be easily searchable with no extra code).