showing custom object in a project using portlet

[Roei Shmoalevich]

hey,
i have a custom object (a table) i imported with XOG and I'm trying to show a specific line from this custom object in a project.
I'm trying to create a portlet with query that will show the line with the same project id I'm at, is it possible?

[Jeevan.S]

Yes. It is possible to do this.

Step 1: Create a Custom NSQL Query which provides the context of the Project that the query is running from. Documentation is at https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/16-3-1/reference/clarity-ppm-studio-development/clarity-ppm-studio-nsql-queries.html . An example of such a usage can be found at Administration > Studio > Queries. Filter for Query ID as 'cop.invTimeReview'

Step 2: Create a Grid Portlet and use the query created above

Step 3: Create a new Tab in the Portlet Page being used to display Projects. Administration > Studio > Portlet Pages. Display 'Page Layout' attribute at Home > Projects to determine the Portlet Page in use

Step 4: Display the Portlet from Step 2 in this new Tab.

[Roei Shmoalevich]

thanks but i cant understand what is the part that says: WHERE projectId = currentProjectId , at the 'cop.invTimeReview' query.