Full text search in datatable

jobybazty

Hi,
I am Joby Joseph working in Oracle ADF. I am using datatable to display my list. I hane a small problem. In my list, search is applied only for the items that is currently present. If the number of rows is 10, search will do only from that 10 rows.

$(document).ready( function () {
$('table.x2f').append('Group order by(usually hidden)Call Pending NameMobile Res TelWork Tel-Ext NationalityCall Status ');
$('table.x2f').dataTable({ "bLengthChange": false, "bPaginate": false , "bSearchable": true})
.rowGrouping({ bExpandableGrouping: true,
iGroupingOrderByColumnIndex: 0,
iGroupingColumnIndex: 1});
});

This is the code that i am using to get datatable.
Can you plz look into this and tell me a suggestion to get the search woring in all my list.

Regards,

Joby Joseph

allan

Can you run your table through the debugger ( http://debug.datatables.net ) so I can see the configuration of the full table. I'd also suggest trying to disable the rowGrouping plug-in to see if that is the cause.

Allan

jobybazty

Hi Allan,
I have added the code to debugger. Please check the code. Now the datatable displays full rows without any pagination.

allan

Erm - what's the debug code that the debugger gave you when it finished uploading to the server? :-)

Allan

jobybazty

Hi Allan
http://debug.datatables.net/ekufiz
this is the debug code.

allan

As far as I can tell from the debugging information it should due doing filtering on all 478 rows. So if you search for "MISCELLANEOUS" what happens? I suspect I'd need to see the table to offer much more help.

Allan

jobybazty

Hi Allan,
If we introduced pagination in the datatable, we are not suppose to search from next set of data in the table. the search will display only from the current avilabe rows only. So our client told us to display all the rows in one page and avoid pagination. So we displayed like this.

allan

Oh I see - you want the filtering to occur on only the currently displayed page? I'm afraid that is not a feature of DataTables at this time. I'll add it to the wish-list, bit its the first time I've encountered this particular requirement, so unless there is a bit more interest in it, I'm not sure when/if it will be implemented into the core by myself.

Allan

jobybazty

Thank you Mr. Allan.
One more question. If I want to add any additional codes to get the filtering on all pages, if pagination is on?