cancel
Showing results for 
Search instead for 
Did you mean: 

MDO Query: using IN predicate as parameter?

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

swaroop_anasane
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Awesome! Thanks Swaroop. Once again u mad emy day 🙂

swaroop_anasane
Active Contributor
0 Kudos

That's great Marco!

Happy, it helped you .

Best Regards,

Swaroop

Answers (0)