Hello All,
I absolutely love this plug in! However, I need some help.
I created a custom report with a filter “User field filter” of “id” to look up student by ID. I added the filter to the SQL “%%FILTER_USERS:u.id%%”
It works great, however when I select the ID 371, for example, from the drop down I am not just getting 371 but 2371 and 1371. The filter is obviously using LIKE in the query. Is there any way to use simply the ID while using a filter? Is there a work around for this?
Any help in this manner would be appreciated.
Version 2.3.9