OQL use paramters in execute statement

0
Hi, I'm trying to make an OQL query, through an execute statement, but I don't know how I can include parameters in the WHERE part.
asked
3 answers
3

Hi,

for parameters in OQL statements use the helper methods from the module. e.g. AddDateTimeParameter allows you to define the value of a datetime parameter by giving the name and value of that parameter.

Then you can use them as $parameter in the OQL query. (e.g. like in Chris answer)

regards, Fabian

answered
0

Use something like this

 

from System.User U
where U/Name = $UserParameter
select U/Name as Name

 

answered
0

Hi Raúl Cuerdas,

You need to append your parameter similar to this when you construct your OQL query in a microflow :

 

‘’’+$variable+’’’

 

answered