|
(→Command Traces)
|
(→Build Requests)
|
| Line 5: | |||
| == Build Requests == | == Build Requests == | ||
| Build requests may not update properly if the BuildRequestEndEvent does not fire. In that case, the SQL below will update the BuildRequest. | Build requests may not update properly if the BuildRequestEndEvent does not fire. In that case, the SQL below will update the BuildRequest. | ||
| - | === SQL to Set All Running Build Requests to a Status === | ||
| - | <pre>UPDATE BUILD_REQUEST SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> | ||
| - | === SQL to Set Build Requests With Certain BuildRequest ID === | ||
| - | Replace '''ZZ''' with the ID of your Build Request. | ||
| - | <pre>UPDATE BUILD_REQUEST SET STATUS = 'XX' WHERE ID = ZZ;</pre> | ||
| + | <table border=2 cellspacing=2 cellpadding=2 align=center> | ||
| + | <tr> | ||
| + | <th>Type</th> | ||
| + | <th>SQL</th> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>set all running build requests to a status</font></td> | ||
| + | <td><font face=monospace>UPDATE BUILD_REQUEST SET STATUS = 'XX' WHERE STATUS = 'YY'</font></td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td align=center bgcolor=#808080><font color=white>set build requests with certain BuildRequest ID</font></td> | ||
| + | <td><font face=monospace>UPDATE BUILD_REQUEST SET STATUS = 'XX' WHERE ID = ZZ</font></td> | ||
| + | </tr> | ||
| + | </table> | ||
| == 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. | ||
