This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)

 
Craig Taylor
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a jasper report that has a query in the form of :
<code>
select blah from blechTable where
($P{value} is null) OR
(blahColumn in ( $P{value} ) )
</code>
The code runs fine when the parameter has a value of null. The code runs fine when the parameter has a value of value1.

I'm trying to get the report to work when I pass in value1,value2 as the parameter for when the blahColumn is equal to either of the 2 values.

Backing database is Postgres.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic