|
(→Build Requests)
|
(→Workflow Cases)
|
| Line 22: | |||
| == Workflow Cases == | == Workflow Cases == | ||
| Workflow cases may not update properly if the WorkflowEndEvent does not fire. In that case, the SQL below will update the WorkflowCase. | Workflow cases may not update properly if the WorkflowEndEvent does not fire. In that case, the SQL below will update the WorkflowCase. | ||
| - | === SQL to Set All Running Workflows to a Status === | ||
| - | <pre>UPDATE WORKFLOW_CASE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | + | <table border=2 cellspacing=2 cellpadding=2 align=center> |
| - | === SQL to Set Workflows With Certain BuildLife ID === | + | <tr> |
| - | Replace '''ZZ''' with the ID of your Build Life. | + | <th bgcolor=#000000><font color=white>Type</font></th> |
| - | <pre>UPDATE WORKFLOW_CASE SET STATUS = 'XX' WHERE BUILD_LIFE_ID = ZZ;</pre> | + | <th bgcolor=#000000><font color=white>SQL</font></th> |
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>set all running workflows to a status</font></td> | ||
| + | <td><font face=monospace>UPDATE WORKFLOW_CASE SET STATUS = 'XX' WHERE STATUS = 'YY'</font></td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>set workflows with a certain BuildLife ID</font></td> | ||
| + | <td><font face=monospace>UPDATE WORKFLOW_CASE SET STATUS = 'XX' WHERE BUILD_LIFE_ID = ZZ</font></td> | ||
| + | </tr> | ||
| + | </table> | ||
| == Job Traces == | == Job Traces == | ||
| Much like Workflow Cases, Job Traces can fail to update if an event to end the job does not fire. | Much like Workflow Cases, Job Traces can fail to update if an event to end the job does not fire. | ||
