name based individual column filtering
name based individual column filtering
Hi Allan,
Could fnFilter do name based filtering instead of index based?
If a table has many columns, individual filtering is more effective, especially for a server-side-database-drive table. imagining searching a keyword using columnA=keyword or columnB=keyword or ... in a huge database table, it will take lots of server resources and long time to finish the job.
By using individual filtering, I figured out that fnFilter uses index of column for individual filtering. in this way, server side needs keep a same columns array and needs to convert the index number to table field name. it's somehow very inconvenient. especially when client side has hidden columns.
Also, it makes hidden columns unsearchable for individual filtering. Sometimes, we want to search using by table primary key but do not want to show the key on a web page. we use http request to passing search field and search value. but because fnFilter uses index of web page table columns. it makes this type of search impossible.
Could fnFilter do name based filtering instead of index based?
If a table has many columns, individual filtering is more effective, especially for a server-side-database-drive table. imagining searching a keyword using columnA=keyword or columnB=keyword or ... in a huge database table, it will take lots of server resources and long time to finish the job.
By using individual filtering, I figured out that fnFilter uses index of column for individual filtering. in this way, server side needs keep a same columns array and needs to convert the index number to table field name. it's somehow very inconvenient. especially when client side has hidden columns.
Also, it makes hidden columns unsearchable for individual filtering. Sometimes, we want to search using by table primary key but do not want to show the key on a web page. we use http request to passing search field and search value. but because fnFilter uses index of web page table columns. it makes this type of search impossible.
This discussion has been closed.