I seem to have something wrong in my where statement where I reference the textinput box as a search bar. If I run with anything in the search box, it works perfectly fine. That leads me to believe the !trxtypeFilter part of the where clause is working fine. It doesn't like the % or the quotes. It seems correct to me.
FYI - I did click "enable snake skin" for sql queries when I first set this up. I also have prepared sql disabled. I am querying a table which was created via csv upload. Right now the table is the only source of the query. I will be adding other sources shortly.
Can anyone tell me what I'm doing wrong? I get the below message currently.
datasource run failed.
** * message:"syntax error at or near "%""*
SELECT
t.trx_type, t.timestamp,t.desc,t.asset as token,t.qty,t.qtyt.spot_price as histval,'usd' as feecurr,t.fees,(t.qtyt.spot_price) + t.fees as cost
FROM
t
WHERE ({{!trxtypeFilter.value}} OR trx_type ILIKE {{'%' + trxtypeFilter.value + '%'}})
ORDER BY token, timestamp DESC;