How to use the where clause in Jasper using parameters in this query?

[polubothusatish]

 

SELECT

p.INTERNAL_NAME "Provider Name",

G.DESCRIPTION "Geo Name",

GT.DESCRIPTION "Geo Type",

GZ.ZIP_KEY "Associated Zip Code",

PA.AMOUNT "Adjustment Amount",

PA.WEIGHT "Adjustment Weight",

PAT.DESCRIPTION "Adjustment Type", 

p.IS_ADULT "Adult Flag",

p.CODE "Provider Code"

FROM UNU.PROVIDER P

JOIN UNU.PROVIDER_ADJUSTMENTS PA on P.KEY=PA.PROVIDER_KEY

JOIN UNU.ADJUSTMENT_TYPE PAT on PA.ADJUSTMENT_TYPE_KEY=PAT.KEY

JOIN UNU.GEO G on PA.GEO_KEY=G.KEY

JOIN UNU.GEO_TYPE GT on G.GEO_TYPE_KEY=GT.KEY

JOIN UNU.GEO_ZIPS GZ on G.KEY=GZ.GEO_KEY

WHERE P.INTERNAL_NAME='&PROVIDERNAME' or P.CODE='&ProviderCODE'

GO

[astrid.guenther]

Hi,

if you have configured the Parameters you can use them like this:

 

WHERE P.INTERNAL_NAME=$P{PROVIDERNAME}or P.CODE=$P{ProviderCODE}

 

You can find this here:

http://community.jaspersoft.com/documentation/ireport-ultimate-guide

[polubothusatish]

Thank You, it worked!

[astrid.guenther]

My pleasure!

[polubothusatish]

Can you explain to me if I had to add it to the respiratory in JasperServer:

would I write it like: $X(IN, p.INTERNAL_NAME, PROVIDERNAME) OR $X(IN, p.CODE, ProviderCODE)

[astrid.guenther]

I do not think that you have to change something concerning the Parameters, if you deploy your report on JapserServer.

Did it work for you in iReport? What error message did you get on JasperServer?