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
0 Answers:
No answers yet
solved!
array$P!{dayofweek}