Jump to content
Changes to the Jaspersoft community edition download ×

Parameters as Column Name on query


2004 IR Help

Recommended Posts

By: Bruno R. Lima - iceboyy

Parameters as Column Name on query

2004-03-10 13:13

Is it possible to create a parameter with the column names you whant to retrieve, and put it into the query ?

Like:

Param: PARAM_COLS

Query: Select $P{PARAM_COLS} from table

 

 

Is it possible to do it ?

I tryied to do, and put the parameter as String, but it creates Varchar values on my query.

 

Thaks

Bruno

 

 

 

 

By: Giulio Toffoli - gt78

RE: Parameters as Column Name on query

2004-03-10 14:37

 

Yes, you must use a different syntax:

 

instead $P{MyParameter} use

$P!{MyParameter}

 

Please note the ! character.

 

Giulio

Link to comment
Share on other sites

  • 4 years later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

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