dane.woodhead
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by dane.woodhead
-
-
hi community i seem to be getting stuck putting an if else statement within a paramter with sql, i really need some help on this thank you if you can help.
i am getting the error expecting anything but ''n''; got it anyway
with this piece of code
$P{FLT_VALUE}.equals("ASOR")? " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_main_asor = %$P!{ASOR}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln ": $P{FLT_VALUE}.equals("PUKPRN")? " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_pukprn = %$P!{PUKPRN}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln ": $P{FLT_VALUE}.equals("SSAT1")? " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_ssa_t1_title = %$P!{SSAT1}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln ": " Select observe.obs_pfm_10004823.obs_lnr_uln, observe.obs_pfm_10004823.obs_del_lrn, observe.obs_pfm_10004823.obs_lnr_last, observe.obs_pfm_10004823.obs_lnr_first, observe.obs_pfm_10004823.obs_del_lsd, observe.obs_pfm_10004823.obs_del_ped, observe.obs_pfm_10004823.obs_del_hed, observe.obs_pfm_10004823.obs_del_state, observe.obs_pfm_10004823.obs_del_led from observe.obs_pfm_10004823WHERE observe.obs_pfm_10004823.obs_del_main_asor = %$P!{ASOR}% and ( observe.obs_pfm_10004823.obs_del_pued = %$P!{PUED}% or observe.obs_pfm_10004823.obs_del_pted = %$P!{PTED}% or observe.obs_pfm_10004823.obs_del_pped = %$P!{PPED}%) and observe.obs_pfm_10004823.obs_del_ped between %$P!{PED_S}% and %$P!{PED_E}%order by observe.obs_pfm_10004823.obs_lnr_uln "
using a case statement in sql for jasperserver report
in Products
Posted
hi community,
i am trying to use a case statement in sql for my report and i keep getting when null ='PUKPRN' syntax error