polubothusatish Posted September 27, 2013 Share Posted September 27, 2013 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 PAJOIN UNU.PROVIDER P on PA.PROVIDER_KEY=P.KEYJOIN UNU.ADJUSTMENT_TYPE PAT on PA.ADJUSTMENT_TYPE_KEY=PAT.KEYJOIN UNU.GEO G on PA.GEO_KEY=G.KEYJOIN UNU.GEO_TYPE GT on G.GEO_TYPE_KEY=GT.KEY--JOIN UNU.GEO_ZIPS GZ on G.KEY=GZ.GEO_KEYWHERE PA.GEO_KEY='&GEOKEY'Order by P.INTERNAL_NAME,WEIGHT Link to comment Share on other sites More sharing options...
polubothusatish Posted September 30, 2013 Author Share Posted September 30, 2013 The answer is: WHERE PA.GEO_KEY= $P{GEOKEY} Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now