Home

Report on How many CO’s Submitted and released

Hi,

Can you let me know is there any report or search where i can find total CO’s Submitted or released in a given period of time

Agile Talent Asked on June 3, 2015 in Agile PLM (v9),   Product Collaboration.
Add Comment
Cancel
4 Answer(s)

You have some options in search criteria:

  • search by “Date Release” and chose the period for the search

RE: Report on How many CO's Submitted and released

  • search by “Status”… 

RE: Report on How many CO's Submitted and released

Cancel
Agile Angel Answered on June 3, 2015.

Divakar

Hi, 

I need Total Co’s Submitted or Released in a given period time.  For submitted this search criteria will not work if the CO is in Review workflow status.
Can i know any other ways we can extract this

on June 3, 2015.
Cancel
Add Comment
Cancel

Hi, 

and is this query holds good to extract the Total Co’s Submitted and Released from DB,  in a given period of time.

select * from change where Submit_date between ’01-Apr-2015′ and ’30-Apr-2015′ and delete_flag is null;

select * from change where release_date between ’01-Apr-2015′ and ’30-Apr-2015′ and delete_flag is null;

Cancel
Agile Talent Answered on June 3, 2015.
Add Comment
Cancel

Hi, 

Is the Change Metrics Report is the answer for my question?

Standard Report • Counts the changes that were moved to a specified status during a time period

Thanks
Divakar

Cancel
Agile Talent Answered on June 3, 2015.
Add Comment
Cancel

Yes.  If you are just looking for a count of the changes  –  the Change Metrics Report will give you what you are looking for.  

You would just need to run the report  once for Status Type: Submit and then again for Status Type: Release.

Cancel
Agile Angel Answered on June 5, 2015.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.