Clarity

We'd like to have reports / portlets showing attributes from the project object, and if the status object is available, show certain attributes  (e.g. list of selected project, and if status report is present, show the status "explaination" fields.  One thought was to create a process to copy attributes from the status report to a "redundant" field in the project objects when updates occur, but haven't found a way to copy data.  Another thought would be to create a new attribute in project, query the field in status report object.  Any recommendations would be greatly appreciated. 

Which version of Clarity are you on ?

NJ

In 13.3 / 14.2, I can see the following -

Project Status Detail (CSP)

Project Status Report List (CSP)

Project Status Summary (CSP)

NJ

You can check these as well -

http://regoxchange.com/show/93/

http://regoxchange.com/show/661/

NJ

Hosted solution version 14.2.0.237. I can report on project WITH status report.  Challenge is I'd like to report a certain set of projects, some will have status reports, some will not.  I think the portlets / queries regarding status only show if there's a status report.  Looking for something like this:

I don't believe theres anything out of the box that does this, you'd need to write a new NSQL query that LEFT OUTER JOINs on the project.id=status.id (whatever they are, don't remember off the top of my head) and create a portlet from it. The "Dashboard: Project Status Indicators Multi-line " NJ linked above should give an idea of what fields to use and how to select the most recent status report specifically, which can be annoying to figure out on your own (believe me)

Thank you - seems that it would be a standard use-case but guess not.  We'll investigate the NSQL.  Thank you.