Gurdeep Sembi asked 7 years ago
Hi Abu,
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?
Thanks
1 Answers
Abu Ghufran answered 7 years ago
You can use dbname to different field which you need to search on, you can use any field with any sql expression.
e.g.
$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>';
Your Answer
