Yes Mike. Using this filter User field search box and i am not getting any error, but am not able to refine my search result.
Below is the thing that i have given in the filter and searching with the last name of the user.
| ID number | Name | Summary | Edit |
|---|---|---|---|
| c1 | User field search box | lastname |
SELECT u.firstname, u.lastname
FROM prefix_user u
where 1=1
%%FILTER_SEARCH:u.lastname%%