Using the inline search, is it possible to show the search results based on the values in a hidden column?
I was thinking there might be something similar to $col["sortname"] for the search?
You can use dbname to different field which you need to search on, you can use any field with any sql expression.
$col["dbname"] = "date_format(invdate,'%b %d, %Y')";
With this, when you search on that column, it will make sql like WHERE date_format(invdate,'%b %d, %Y') = '<your-input>';
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?