How to pass any parameter to this query? or add parameter in this query?

0

i am using one table called sales by this query I want to show all entire table but I am not getting how to use parameter in this 

SELECT a.City, b . * FROM sales a LEFT JOIN sales b ON a.City = b.City

or

SELECT * FROM sales WHERE City = ANY(
SELECT DISTINCT City FROM sales);

tejaswini.patil2000's picture
Joined: Jul 8 2021 - 2:59am
Last seen: 2 months 2 weeks ago

2 Answers:

1

just look in the documentation.there is a lot of examples on how to fo that

yassinswag50's picture
Joined: Jul 20 2019 - 1:52am
Last seen: 2 months 2 weeks ago
1

If you want to know the basic way to use parameters in Studio's SQL, the following wiki may help you understand.
https://community.jaspersoft.com/wiki/using-report-parameters-jaspersoft...

 

You will need to see the manual for more detailed information.
https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-u...

 

I hope this is helpful.

 

 

yama818's picture
242
Joined: Aug 17 2018 - 3:48pm
Last seen: 7 hours 20 min ago
Feedback
randomness