How to solve this query's for where clause errors?

 

The errors that occur are:

                          a.) Parameter not found: GEOKEY ---net.sf.jasperreports.engine.design.JRDesignExpression@538a7e36

                          b.) Query parameter not found : GEOKEY ---net.sf.jasperreports.engine.design.JRDesignQuery@d4e9bd5

 

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

WHERE PA.GEO_KEY= $P{GEOKEY}

Order by P.INTERNAL_NAME,WEIGHT

 

 

 

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 9 years 3 weeks 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 3 weeks ago
Feedback