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
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
Added here one parameter, as we know here is still not possible to add string , so I chose long and put between quotes.
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?
Have you ever tried like this
P.Name LIKE '$Name'
Configure your string parameter
- Name: Name
- Value: '%' + $yourvalue + '%'