Dear Community Members,
In this week's Learn PPM with Rego, we'll explore five CA PPM questions and answers.
1. What are the commands I need for Jaspersoft issues?
2. How can you find summary task flags? Task - summary="true" :::: Question
3. Is there a workaround for Auto Suggest on Custom Query Lookups?
4. What kind of Heat Map can Jaspersoft do?
5. How do we allow users to execute / run reports in Jaspersoft and not create new ones?
Please feel free to comment on any alternative answers you've found.
We love your input (always).
admin update jasperParameters
admin jaspersoft syncPPMContext -userName superuser -password superuser
admin content-jaspersoft csk restoreDomains -userName superuser -password superuser
Prtask.pristask = 0 if summary, 1 if detail
3. Is there a workaround for Auto Suggest on custom query lookups? I’ve noticed that this functionality is sketchy. Sometimes it works, and sometimes it just doesn’t. I have a query setup with the following code:
select @select:trim(cv_clarity_finance):budget_code@ ,@select:i.name:project_name@ ,@select:i.code:project_id@from odf_ca_project pjoin inv_investments ion i.id = p.idwhere trim(cv_clarity_finance) is not nulland @filter@group by trim(cv_clarity_finance) ,i.name ,i.code
I have the auto suggest tab setup like this:
After trying every combination of the three fields as search keys, the lookup has never returned results in an auto-suggest drop down while typing. I’ve tried xogging the object and the lookup. I’ve tried clearing caches. I’ve tried deleting both the field and the lookup and recreating, but it doesn’t seem to help. Is there a trick to getting this to work or is it just broken? Binoculars always return results. Auto-suggest never has.
select @select:q.budget_code:budget_code@ ,@select:q.project_name:project_name@ ,@select:q.project_id:project_id@from ( select trim(p.cv_clarity_finance) budget_code ,i.name project_name ,i.code project_id from odf_ca_project p join inv_investments i on i.id = p.id where trim(cv_clarity_finance) is not null group by trim(cv_clarity_finance) ,i.name ,i.code) qwhere @filter@
AnswerThis is the most I’ve done with a heatmap in Studio. It took coaxing to get this to work, using a CSV as a datasource with some dummy data: I haven’t been able to dive deeper into the heatmap functionality, but the requirement you show above may be beyond what Studio can currently handle.
If you give the users the ability to just navigate instead of adhoc create, this will let them see some reports. From there make sure the role “role_user” has the access to read only on the reports they want ran. Remember to make sure they have access to read only on all the folders, to access that report. The users have to have access to the reports and the folders leading up to it.
A special thanks to David Zywiec, Darren Greer, Chris Shaffer, Jenn Rinella, and the Rego Team for this great material