on 04-17-2015 10:15 AM
Hi experts,
afaik, MDO queries support OPEN SQL. In Open SQL, there is the IN predicate, that is SELECT...WHERE x IN (...).
Is there a way of using this as filter for a select MDO Query?
If so, what format do I ahve to pass the "Filter" array?
I tried to pass a list to a query and refered to it as [MODEL] = [Param.2] in filter section...without success.
I have a workaround in place but still wonder if there is a more efficient way?
Thanks for your feedback!
Hi Marco,
You can remove typed parameter check and pass the string as 'val1','val2','val3'.... in the param.1.
In query condition, it would be like
[ColumnName] in ([Param.1])
This should serve the purpose.
Thanks,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.