Hello,
I am creating a dashboard where I am pulling my data from Redshift. I am trying to create the query event to filter data in the table based on key words used in this search field. My query is below:
select * from pricing_log where supplier like {{ ‘%’ + name_input.value + ‘%’ }} order by created_at desc
I am getting a syntax error near from order. It looks like the error is located in LIKE condition, but I am not sure about it.
Please let me know your comments