OQL with String parameters

0
Hi,   Is there a way to add String parameters in OQL in the dataset. now you can only add object, boolean, datetime, integer, enumeration and decimal but not String.   we fix it now by adding quotes to our string parameters: Person.Name LIKE ‘$name’     Kind regards, Steven Keersmaekers
asked
3 answers
1

hii Steven Keersmaekers,

you can not use any type of parameter in Dataset even you can not use system variables also,

 use Execute OQL activity in MF in MF you can add parameters in OQL 

Now you can add String parameter also.

 

Thanks 

Sanjay

answered
0

Hi Steven, thx for the info. However for me still not clear how to hack the dataSet, like you described.

Let me show my path:

 

Provision._Name_1 is string

 

image.png

 

 

Added here one parameter, as we know here is still not possible to add string , so I chose long and put between quotes.

image.png

Added here a string parameter with $MXID name and a static string value to test the idea.

There is no error, but the result is empty due my value is not parsed during retrieve and P.MXID LIKE '$MXID' run against DB.

 

Can you please tell me what parameter are U using @ Dataset and how to pass it to?

answered
0

Have you ever tried like this

P.Name LIKE '$Name'

 

Configure your string parameter

- Name: Name

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

answered