Michael_Lowry

List workflow tasks with agent-specific conditions

Discussion created by Michael_Lowry on Jul 21, 2017
Latest reply on Aug 18, 2017 by Michael_Lowry
We identified a new ucybchng bug (PRB00136058) this morning. Starting somewhere between 11.2.3 and 11.2.5, ucybchng lost the ability to update agent names in task conditions. I am trying to gauge the scope of the problem, and as a part of this I need to find out how many workflows have tasks with this kind of agent-specific condition.

I came up with a query that will list all task conditions.
select OH_Name, JPOV_JPP_Lnr, JPOV_Location, JPOV_JPPO_Lnr,
JPOV_VName, JPOV_Value, JPOV_Type, JPOV_AltView
from OH, JPOV
where JPOV_OH_Idnr=OH_Idnr
and OH_Client = 1
and OH_DeleteFlag = 0
and JPOV_VName = 'XC_P01'
Now I just need to find out how to narrow the search to show only the conditions that are agent-specific — that is, conditions of these types:
  • CHECK ACTIVITIES
  • CHECK CONNECTION
  • CHECK FILE
  • CHECK PROCESS
Can anyone help me narrow the query? Thanks in advance.

Update: CHECK_ACTIVITIES checks for active tasks in the Automation Engine. It is not an agent-specific condition.

Outcomes