How to create from colection array to psql

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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
87
Joined: Feb 20 2015 - 2:19am
Last seen: 4 years 3 weeks ago

solved!

array$P!{dayofweek}

pixar - 7 years 3 weeks ago

0 Answers:

No answers yet
Feedback
randomness