Flexible Search Query

[former_member737102]

how to add underscore in flexible search query as underscore does not work in oracle like clause and if it is oracle query we can add something like below but how can we do that in flexible search query

<code>SELECT * FROM TABLE1 WHERE NAME LIKE 'test\_1%' escape '\'

[former_member737102]

i have found a solution to fix this in flexible query as well like below

select * from table where {attribute} like '%\_test%' escape '\'