Code that you found je for server-side tables and, as I can see, your table is not using server-side processing. For this kind of tables search is done on frontend, with javascript and code for this could be found in
it looks like you turned on option to use minified version of js and css file in meantime. If you want to use it you must minify jquery.dataTables.columnFilter.js with mentioned change and save it in the same folder as jquery.dataTables.columnFilter.min.js
How do I get the search to only pull up the exact terms?
If I type in 123, it should only pull up 123 and not 1234.
I tried modifying the wpdatatables/source/class.wpdatatable.php file but it had to effect on the search.
http://imgur.com/a/ENa08
http://imgur.com/a/MZbWU
Hi Gmsthailand,
Code that you found je for server-side tables and, as I can see, your table is not using server-side processing. For this kind of tables search is done on frontend, with javascript and code for this could be found in
../wp-content/plugins/wpdatatables/assets/js/jquery-datatables/jquery.dataTables.columnFilter.js
For filter type Number to search exact match try to find this code around line 129
oTable.fnFilter('^' + this.value , _fnColumnIndex(index), true, false); //Issue 37and change it to
oTable.fnFilter('^' + this.value + '$', _fnColumnIndex(index), true, false); //Issue 37I modified the file but the search still does not work as I want it to.
http://imgur.com/a/h7G0z
Hi Gmsthailand,
Please tell me what is the problem. This is code for column search for filter type Number.
I followed your instructions and made the necessary changes. The datatable does not perform an exact search as I want it to in my opening post.
http://imgur.com/a/Vq71u
http://imgur.com/a/ATJWU
In the image above, it still brings up 8920088896 when typing in 892. It should not bring up anything.
http://imgur.com/a/zww6k
Sorry if I am not clear.
Hi Gmsthailand,
It looks like you didn't reupload that file. Please take a look at the attachment
I downloaded the file directly from the FTP after uploading it there with the changes but it still doesn't work.
http://nubwo.com/wp-content/plugins/wpdatatables/assets/js/jquery-datatables/jquery.dataTables.columnFilter.js
http://imgur.com/a/OvVMd
http://imgur.com/a/cT6Vr
http://imgur.com/a/pftkC
Hi Gmsthailand,
it looks like you turned on option to use minified version of js and css file in meantime. If you want to use it you must minify jquery.dataTables.columnFilter.js with mentioned change and save it in the same folder as jquery.dataTables.columnFilter.min.jsIt's working as intended.
Ty for your time and patience. I really appreciate it. :) :D
Hi Gmsthailand,
If you like our plugin and support please rate our plugin at CodeCanyon on this link. It means a lot to us. Thanks.
1) It is no longer working after I created a new table:
http://www.nubwo.com/support/status-tracking/?wdt_column_filter[2]=sn
It is bringing up all of it that starts with sn.
2) There is also the issue of not all the columns displaying:
They only show up after decreasing the size of the page:
http://imgur.com/a/x02YK
3) Is there anyway to retain the color coding from the original spreadsheet?
I will definitely add the review and rating. I appreciate the effort you are putting into your support.
Hi Gmsthailand,
When I put this page as my input I get an error:
http://imgur.com/a/n00Sq
Hi Gmsthailand,
Is this a new issue or it's related to previous? Could you send me a link from Google spreadsheet so I can take a look?
It's a new issue.
https://docs.google.com/spreadsheets/d/13FFWFOino2RDv4pCKlVO2BnFkjrajwktTO0FNH_1Leo/edit#gid=1740915978
Hi Gmsthailand,
Our plugin uses first row of data to determinate column names. To be able to work properly please add at least one more row of data
This still pulls up 12 when I type in 1.
http://www.nubwo.com/support/status-tracking/?wdt_column_filter[2]=1
Hi Gmsthailand,
Please tell me what is the filter type in that column?
Text. I just changed it to number. That seems to have resolved the issue. Ty.
Hi Gmsthailand,
Glad to hear that it's working now