How to create from colection array to psql

0

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's picture
49
Joined: Feb 20 2015 - 2:19am
Last seen: 1 year 5 months ago

solved!

array$P!{dayofweek}

pixar - 4 years 5 months ago

0 Answers:

No answers yet
Feedback
randomness