how to use LIKE in query

Alon Grod
Tera Expert

Hi, 

I have this query and instead of using LIKE and sysid i need to use LIKE and the var product.

What is the right way to replacing the sys ID with the variable product?

u_allowed_duplication is of a type list and its a reference to a table, so i need to filter using contains which is LIKE.

bs.addEncodedQuery('name=' + user + ^u_allowed_duplication_swLIKEda1d2ffc1b3db05073542f02604bcbcb')