Dynamic query

[fender989100]

Hi

I have input id param in my report.

If id == null then I need to use a query like this:

SELECT id, name

FROM company

 

But if id == 1 (or another number)

I need to use that query:

SELECT id, name

FROM company WHERE id = 1

I've tried ti create one param that depends from another param, for example:

$P{id} == null ? "WHERE true" : (" WHERE id = " + $P{id})

but it's not working, the resuls is always "WHERE true"

 

Is that possible to do?

[kkriplani]

Yes, it is very much possible to do so using conditional parameters (see the last answer in this link ) represented as $!P{}

Try approaching like this;

$P{Id} == null ? "where 0=0" : "where id=" +$P{Id};

Regards,
KKriplani

[fender989100]

Thanks

I know about that technic, but It's not working.

$P{Id} == null ? "where 0=0" : "where id=" +$P{Id};

$P{Id} always will be null in current expresion, no matter param  was fiels or not

 

[kkriplani]

Hi,
Then I guess the issue is not with the conditional parameter. There may be an issue with passing the parameter value. 
Tell me more about how are you getting the value for $P{Id} ?
Is it in a dataset? Are u using it in a table? Or its just a parameter retrieved from an Input control?

Regards,
KKriplani

[fender989100]

Thank you KKriplani

It works

Jasper Soft Studio has some troubles with Preview mode

When I've uploaded report to the Server everythings start to work