AnsweredAssumed Answered

PI System Explorer - IN/LIKE Clause

Question asked by MassimoSporchia on Mar 1, 2016
Latest reply on Mar 2, 2016 by kduffy

Hello,

 

I'm using PI System Explorer (2.6.2.6558) and I'm having trouble trying to get a data lookup aggregate based on a list of components.

What I'm trying to achieve is something as simple as an attrbute defined as a table lookup:

 

select 'pippo' from dual

union all select 'pluto' from dual

union all select 'caio' from dual

 

and an attribute (@Attribute1) of type String that I'd like to store 2 values: pippo and pluto

 

The table lookup would then have a where clause on the first column value that has to be IN the list defined in @Attribute1.

 

I've tried to define @Attribute1 in numerous ways but the only time it works is when it's of type String and has only a single value from the table lookup (so, either pippo, pluto or caio).

 

Is there a way to achieve what I'm trying to achieve with PI System Explorer?

 

Thanks in advance.

Outcomes