Jump to content
Changes to the Jaspersoft community edition download ×

variable in query


Recommended Posts

By: Paul Stanton - wanto

variable in query

2004-04-26 15:48

i would like to use a variable in my query which is based on a parameter. jasper does not seem to evaluate the variable, instead sends the variable name '$V{XX}' down to the db engine. is this standard behaviour? if so, it's a little limiting. any one come across this before or had variables work in their queries?



By: Richard Laplante - rlaplante

RE: variable in query

2004-12-02 12:44



I think a came across a similar problem and I searched a lot before finding the solution which was quite simple.


It works for parameter, it might work for Variable.


you have to use "!" after your parameter/variable marker.


example:SELECT id, name FROM table WHERE id = $P!{itemid}




SELECT id, name FROM adservingactivity WHERE id = $V!{activityid}


Hope that will work

(I don't have time now to test myself)

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...