Like operator with parameters

0
Hello everyone I am using oql execute query with parameters. Unfortunately, the like operator doesn't retrieve any information when I use it with a parameter. Here is my query:  doc.Name LIKE '%$text%', I think the like takes the $text as string and not as a parameter, does anyone know what the correct syntax could be?   Thanks in advanced Mohammad Altahan
asked
2 answers
0

Hello Mohammad,

 

In case you’re building a string in a microflow, it should look something like this:

 

"doc.Name LIKE '%" + $text + "%'"

 

answered
0

Mohammad,

 

Your query: '... doc.Name LIKE $text'

Your 'Add string parameter' action:

- Name: text

- Value: '%' + $yourvalue + '%'

answered