how to pass a list of integers to birt parameter value?

Clement Liu (1.5k●5●43●49) | asked Aug 16 '10, 3:23 p.m.

How do I pass three integers - 1111,2222,3333 to the value of WS_FACTID?

http://4.bp.blogspot.com/_2YQMPJPq75s/TGmLk-EpwVI/AAAAAAAAAK8/5HwJjYoDPkw/s1600/birt.png

I tried {1111,2222,3333} but didn't work... :(

Comments

Karol W commented Oct 23 '12, 8:27 a.m.

I have similar issue, I'd like to pass multiple values as parameter to FACT_ID column. Were you able to solve the problem?

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0	permanent link sam detweiler (12.5k●6●195●201) \| answered Oct 23 '12, 9:41 a.m. well, there are two issues here 1. passing multiple parameters 2. the report USING multiple parameters.. do we know if the report SUPPORTS using multiple numbers concurrently?

permanent link

Karol W (55●1●8●11) | answered Dec 06 '12, 4:06 p.m.
edited Dec 06 '12, 4:06 p.m.

My problem was that I had a set of FACT_ID fetched in one data set, and then I had to fetch value of PREV_FACT_ID of each FACT_ID in set.

I was able to solve this by setting Data Set's query programatically in beforeOpen script.

In Clement's case (pass three integers - 1111,2222,3333 to the value of WS_FACTID) the queryText would be:

this.queryText = 'WS_FACTID IN (1111,2222,3333)';

permanent link

Melissa Hanke (6●1●1) | answered Jul 09 '14, 10:42 a.m.

I have got the very same problem, i need to pass a list of item ids into the parameter, but not via own parameters... the proposed solution does not work in my case, is there anyone who knows how i could solve this issue? :( thank you!

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

It's all about the answers!

Related questions

how to pass a list of integers to birt parameter value?

3 answers

Your answer