Jump to content
Changes to the Jaspersoft community edition download ×

Can you only have parameters in queries?

2004 IR Help

Recommended Posts

By: bpdy9fg - bpdy9fg

Can you only have parameters in queries?

2005-01-07 06:05



I'm new to using jasper .. just wondering when using the sqlQuery tag .. is it only Parameters that can be used as values in the sql text? Can Variables be used?


Come to think of it can Variables be constructed using a Parameter? For instance ... if a Parameter (name=sched) is a "Schedule " object, how would I translate the value of Schedule.getStartTime() into the sql query.


Any help would be appreciated.







By: Teodor Danciu - teodord

RE: Can you only have parameters in queries?

2005-01-11 12:24




Yes, only parameters can be used in the SQL query.

If you need to perform some operations on the

parameters and supply a derived value to the SQL

query then use the <defaultValueExpression>

of a dummy report parameter that you place as

the last parameter in the list.


I hope this helps.


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...