SQL IN operator

  

Hi All,


The below query returns an error. 

Can you let know what is going wrong here.?


Best Regards- Gurpreet 

Hi Gurpreet Bhui,

There can be several reasons, maybe you can provide more context?

For example, knowing what values hold the input parameter (@selection), might help give further tips.

Regards,

Gurpreet Bhui wrote:

Hi All,


The below query returns an error. 

Can you let know what is going wrong here.?


Best Regards- Gurpreet 

Hi Gurpreet,  

You have to make sure that the Expand Line in the input is "Yes".

The string should be passed in this format: "'xyz, zkz, xkx'";


Kind regards,

Miguel Sousa



Hi Gurpreet,


What is the data type of input parameter.


Thanks!

Working fine for me..can u plz share oml file 

Hi Gurpreet,

Instead of using an advanced sql you can use an aggregate with this filter Index({pcp}.Id, Var1) <> -1

Regards,

Marcelo