Filters using in native query with like operator for comapny name and username

Bug reports
1

Hi,
We are using sql query in native query section and we are using like condition for filters in where clause. But its not working and showing error. We are checking it from long time.
Here we are using in like operator:
where caluse- WHERE true
[[ AND Users.firstName LIKE CONCAT(’%’,{{variable}},’%’) ]]

Thanks

2

Hi @Ankita
Please post “Diagnostic Info” from Admin > Troubleshooting.
What error are you seeing?
The {{variable}} has to be simple Text filter. It cannot be a Field Filter, when you’re using it like that.