Forums Register Login

JasperReport - error with conditional parameter in SQL

+Pie Number of slices to send: Send
I'm trying to have a query that returns all rows if user_id parameter is NULL/empty. The same query should return a specific row if user_id is not NULL/empty. I did some Googling and found the following suggestion. However, when I preview the Jasper report in the iReport, I hit a Oracle missing keyword error. I checked my syntax and it seems to be okay.

Any help is appreciated!

Sunglasses. AKA Coolness prosthetic. This tiny ad doesn't need shades:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1928 times.
Similar Threads
Implementing auto increment programitcally
difficulty in login in one attempt
iReport/Jasper - How to passmutli parameters / Postgres (eg: value1,value2 or value1)
Mapping BigInteger java object into a ResultSet Data Type
Parameters passing doubt in Jasper reports
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 14:28:37.