Not sure how to use WHERE CLAUSE for this query?

How to write the where clause for this query in Jasper Studio: 

 

SELECT 

G.DESCRIPTION "Geo Name",

GT.DESCRIPTION "Geo Type",

PA.AMOUNT "Adjustment Amount",

PA.WEIGHT "Adjustment Weight",

PAT.DESCRIPTION "Adjustment Type", 

p.INTERNAL_NAME "Provider Name",

p.IS_ADULT "Adult Flag",

p.CODE "Provider Code"

FROM UNU.PROVIDER_ADJUSTMENTS PA

JOIN UNU.PROVIDER P on PA.PROVIDER_KEY=P.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 PA.GEO_KEY='\&GEOKEY'

Order by P.INTERNAL_NAME,WEIGHT

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 9 years 7 months ago

1 Answer:

The answer is: 

WHERE PA.GEO_KEY= $P{GEOKEY}

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 9 years 7 months ago
Feedback