Promoted EnterpriseOne (E1) Projects
So, to continue with the SQL theme from our E1 Development Manager, here is one that retrieves info about the projects that have been promoted since a given date. It gives the Project Name, Project Description, Object Name, Object Description, Object Type and the person’s userid that is on the object in PY.
SELECT PMOMWPRJID PROJ_NAME, PMOMWDESC PROJ_DESC, POOMWOBJID OBJECT_NAME,IFNULL(C.SIMD,VRJD) OBJECT_DESC, POOMWOT OBJECT_TYPE, (SELECT E.SIUSER FROM OL811/F9861 E WHERE E.SIOBNM = C.SIOBNM AND E.SIPATHCD = 'PY811') DEVELOPER FROM SY811/F98220, ((SY811/F98222 LEFT OUTER JOIN OL811/F9860 C ON POOMWOBJID = C.SIOBNM) LEFT OUTER JOIN COPD811/F983051 ON POOMWOBJID = CONCAT(CONCAT(RTRIM(VRPID),'|'),VRVERS) ) WHERE PMOMWPS in ('38') AND PMOMWPRJID = POOMWPRJID AND POOMWOT NOT IN ('UO', 'SE_TASK', 'SE_REL') AND PMUPMJ > 107250 ORDER BY PMOMWPRJID, POOMWOBJID
Author
Stewart Schatz
More Stories
Quick Tip: Hold All JDE Job Queues
The following SQL statement will put all JDE Job Queues on hold: UPDATE SY920.F986130 SET QCQUSTS='02' This statement is very...
How To Disable Client Package Deployment
If you have a development client that has been neglected and JDE wants you to install 15 update packages but...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so...
Quick Tip: Where Is An Application On The Menu?
The following SQL will give you a good idea if an application or UBE is on the menu and where...
Quick Tip: Decline All Update Packages Using SQL
A quick way to decline all packages that have been marked for deployment on a development client is use SQL:...
Quick Tip: Change A Scheduled Job’s Time Zone Using SQL
If you work with multiple time zones, especially if one uses Daylight Saving Time and the other does not, it...
Average Rating