I have developed a proof of concept for a workflow that can be used as a drop-in replacement for
external dependencies. The dependency options are specified via a prompt set. A REST job fetches the remote task status, and a second REST job fetches parent task info if necessary. Retries are accomplished via task post-conditions.
All of the checks up to and including the check for same logical date are working. The remainder are yet to be implemented, and may not be depending on how many people are actually using these options today.
And speaking of that, here's a little SQL query I wrote that lists all but the most commonly used types of external dependencies in the AE DB.
SELECT OH_Name, JPP_Object, JPP_ParentObject, JPP_Alias, JPP_ParentAlias, JPP_ExtWhen, JPP_ExtSLTType, JPP_ExtSLTWithin,
JPP_ExtElse, JPP_ExtElseAlarm, JPP_ExtTimeout, JPP_ExtTimeoutE, JPP_ExtTimeoutA, JPP_ExtExecute, JPP_PreCntExt
FROM OH LEFT JOIN JPP ON OH_IDnr = JPP_OH_IDNR
WHERE OH_CLIENT = 100
AND OH_DeleteFlag = 0
AND ( JPP_ParentObject IS NOT NULL OR
JPP_ParentAlias IS NOT NULL OR
JPP_ExtElse <> 0 OR
JPP_ExtElseAlarm <> 0 OR
JPP_TimeoutFlag <> 0 OR
JPP_ExtExecute IS NOT NULL )
ORDER BY OH_Name, JPP_ParentObject
This will help us to get an idea of how prevalent the different kinds of options are, so that we can decide which ones are worth the effort of recreating in the dependency checker tool.
Here are a couple more SQL queries.
Populate the Check expected status pick list
SELECT ZUTYP_STATUS
FROM UC_ZUTYP
WHERE ZUTYP_ISALIVE = 0
ORDER BY ZUTYP_STATUS ASC
Fetch the list of status codes for a given ZUTYP_STATUS
SELECT ZUTYP_STATUSRANGE
FROM UC_ZUTYP
WHERE ZUTYP_STATUS = ?
The JOBI that expands this into a full comma-delimited list has already been posted to another thread.
More to come.
Original Message:
/earth is 98% full. Please delete anyone you can.