I do not think that this can be done out of the box. Do you talk about external dependencies set in a workflow?Regards,Juergen
1. Polling from successor system
2. Trigger from predecessor system
Did I overlook anything? Thanks in advance for additional feedback and suggestions.
There are several solutions to the parallel jobs run.1. Modify the Alias and add the RunID to the Alias in the pre processing 2. When triggering the job, add the RunID as Key and the job name as value to a VARA. The status checker checks the VARA and deletes the entry when the job is finishedWe are using both (regarding to the usage) successfully since years.Regards
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_PreCntExtFROM OH LEFT JOIN JPP ON OH_IDnr = JPP_OH_IDNRWHERE OH_CLIENT = 100AND OH_DeleteFlag = 0AND ( 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
Here are a couple more SQL queries.Populate the Check expected status pick list
SELECT ZUTYP_STATUSFROM UC_ZUTYPWHERE ZUTYP_ISALIVE = 0ORDER BY ZUTYP_STATUS ASC
Fetch the list of status codes for a given ZUTYP_STATUS
SELECT ZUTYP_STATUSRANGEFROM UC_ZUTYPWHERE ZUTYP_STATUS = ?
The JOBI that expands this into a full comma-delimited list has already been posted to another thread.More to come.