Reports : How to pass variable as Array values in filtering conditions (query activitie)

Avatar

Avatar

Ben_Mahfoudh

Avatar

Ben_Mahfoudh

Ben_Mahfoudh

22-05-2018

Hello,

Can we use a variable as value in a filtering condition with "is included in" as Operator ?

In a script activity I initiate a variable as follows:

ctx.vars.operationIdList = new Array(-1432383860,-1426727378,-1411155661);

Then i am trying to filter my query using this variable as a list:

1492585_pastedImage_1.png

I get the following error:

[xtk:report Error] PGS-220000 PostgreSQL error: ERROR: invalid input syntax for integer: "-1432383860,-1426727378,-1411155661" ...

Obviously my integer field does not like to be included in a string entree. So how can I cast this string to array using query Functions or other ?

Best regards

Ben mahfoudh

View Entire Topic

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

04-04-2019