Hello all,
I would like to use queryEntity to add a filter which uses LISTAGG function in the database view.
I'm trying to add DECISION filter something like below:
select * from DB_VIEW where RECEIVED_DATE > to_date('6/1/2021', 'mm/dd/yyyy') and (DECISION like ('%Disapproved%') or DECISION like ('%Approved%'));
Now the issue is, we do not have 'like' value for 'operator' in a!queryFilter. How can I add 'like' operator to get the filtered result on a view in the Appian Report?
Discussion posts and replies are publicly visible