I was trying to look into an issue where I wanted to find out when a source was last promoted to PD.
To do this; I have to enable "Show finished Projects" on the "Developers Workbench" page. Then I have to eyeball the source I am interested in and use the hover to find the date it was sent to PD.
I eventually created a query to get this information from the database. Which is much quicker. But access to the IDE database if not guaranteed on all apps.
"SELECT Obj.ObjectName, PRJ.Name AS ProjectName, PRJ.CurrentPath, PRJ.CreatedBy, PRJ.UpdatedOn
FROM <[Path]_IDE.[Tenant_app]_System>.SCM_Project_Objects OBJ LEFT JOIN <[Path]_IDE.[Tenant_app]_System>.SCM_Projects PRJ
ON OBJ.ProjectId = PRJ.ProjectId
WHERE OBJ.ObjectId = <ObjectId>
Order By UpdatedOn"
If there was an IDE page with promotion dates and filters on "ObjectName" and "ProjectName" would help this greatly.
This is a request similar to the issue raised by Cathy. Here:
viewtopic.php?t=485
IDE needs latest update dates for projects and sources
-
- Posts: 44
- Joined: May 2nd, 2022, 11:53 am
- Contact:
IDE needs latest update dates for projects and sources
word count: 169
-
- Posts: 574
- Joined: August 26th, 2021, 9:56 am
- Contact:
Re: IDE needs latest update dates for projects and sources
This post has been attached to task 10840. This post will be updated when it is completed.
word count: 17