Hi,
When I checked this Project Stoy board report, I checked the Query and also Input control, there is no specific value mentioned as ----. I could see the input control is not even mandatory and has the query as follows.
SELECT obs.obs_unit_key AS obs_unit_key,
obs.obs_unit AS obs_unit,
obs.obs_path AS obs_display_name,
obs.hierarchy_level AS hierarchy_level
FROM dwh_lkp_obs_unit obs
WHERE obs.is_investment_obs = 1
AND obs.obs_type_key = $P{projectOBSTypeKey_1}
ORDER BY obs.hierarchy_level
This is n't much helpful. Please advise am I checking the correct query
FYI, I'm using Clarity 14.2 with Patch 7 and Jaspersoft 5.6.1
Thanks
Sreeram