Currently when including the column as field type variable its throwing error when the value in the filter drop down is selected ,else working fine.table ,column name are all same as in the table,query format is as given below
select * from table
where columnname = {{columnname}}
even tried
select * from table
where {{columnname}}