Clarity PPM

Expand all | Collapse all

CA PPM: How to pull the projects created using the template

  • 1.  CA PPM: How to pull the projects created using the template

    Posted 02-25-2019 04:52 PM

    Hello Everyone, 

     

    Is there a way that I can pull all the projects created using the particular template? I am on On Demand Environment and I dont have database access.



  • 2.  Re: CA PPM: How to pull the projects created using the template

    Posted 02-25-2019 07:20 PM

    You could use the Power Filter on the Project List to filter by Project Template.  Never personally filtered by this attribute, but hopefully it will give you required results.

     

    In relation to your comment 'On Demand and not having database access', you do have database access.  This is available by JasperSoft Studio, which includes JDBC Drivers.



  • 3.  Re: CA PPM: How to pull the projects created using the template

    Posted 02-25-2019 07:36 PM

    You can add the field Originating Template to the project list screen (or to the filter), to see the name of the template from which the project was created.

    As roland.parrotte said above, you can use Jaspersoft Studio to query the database. You can also use SQL Squirrel: regoXchange :: CA PPM SaaS JDBC Connecting - Oracle SaaS