Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
John_Urquijo Frequent Contributor.
Frequent Contributor.
473 views

Creation Date cycles and releases

Jump to solution
Hi,
I need your help, I need to know the creation date and the user who created a cycle in HP ALM.
I have consulted the table "RELEASE_CYCLES" but it does not present the required information. 
Nor is it registered in the table AU_LOG Thanks for your valuable help. John U.

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Creation Date cycles and releases

Jump to solution

Yes, seems like this is not been saved anywhere by default. You can change that by customizing. Add user defined fields for author and data_created to the cycle entity and create a workflow script for event cycle_new to fill the fields with current date / time and current user (author). 

3 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Creation Date cycles and releases

Jump to solution

Yes, seems like this is not been saved anywhere by default. You can change that by customizing. Add user defined fields for author and data_created to the cycle entity and create a workflow script for event cycle_new to fill the fields with current date / time and current user (author). 

Honored Contributor.. kamakshi Honored Contributor..
Honored Contributor..

Re: Creation Date cycles and releases

Jump to solution

Hi John,

Changes to Description, Start Date and End Date fields in Releases and Cycles are captured in Audit_LOG and Audit_Properties tables if history is enabled. As Start Date and End date fields are mandatory while creating Release/Cycle, user is forced to enter these dates which will be captured in Audit tables.

So, you have to enable history for the above mentioned fields in Project entities(Release , Cycle) of customization module .

With these changes in place, after creating Release/Cycle, entry will be added in Audit tables . You can get the dates for each release/cycle using SQL queries.

Note: Data for already existing Releases/Cycles cannot be retrieved. Entities created after enabling customization changes can only be retrieved.

John_Urquijo Frequent Contributor.
Frequent Contributor.

Re: Creation Date cycles and releases

Jump to solution

Thanks Thomas :-)

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.