How to create from colection array to psql

[pixar]

Hi, I have a problem insert the values of input in a SQL query.

Input: days of the week (Multi –select list of Values)

Table:

Name|value

Monday|1

Thuesday|2

….

SQl Qeury

select * from report_redlight_pr($P{FromDate}, $P{ToDate}, array[0,1,2,3,4,5,6] , $P{from_time}, $P{Czas_do});

I need create this: array[0,1,2,3,4,5,6]

Jasperserver return this: $P{dayofweek} = [0,1,2,3,4,5,6,]

 

Thank you for your advice.

Radek

[pixar]

solved!

array$P!{dayofweek}