| |
== SQL to Set All Running Workflows to a Status == |
|
== SQL to Set All Running Workflows to a Status == |
| |
<pre> UPDATE WORKFLOW_CASE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> |
|
<pre> UPDATE WORKFLOW_CASE SET STATUS = 'XX' WHERE STATUS = 'YY';</pre> |
| |
|
+ |
== SQL to Set Workflows With Certain BuildLife ID ==
|
| |
|
+ |
Replace '''ZZ''' with the ID of your Build Life.
|
| |
|
+ |
<pre> UPDATE WORKFLOW_CASE SET STATUS = 'XX' WHERE BUILD_LIFE_ID = ZZ;</pre>
|
| - |
==== Set a specific build life id to "aborted" status ====
|
|
|
| - |
''substitute 50 for your BL ID''
|
|
|
| - |
<pre> UPDATE WORKFLOW_CASE SET STATUS = 'Aborted' WHERE BUILD_LIFE_ID = 50;</pre>
|
|
|
| |
==== Delete all locks present (could require server restart) ==== |
|
==== Delete all locks present (could require server restart) ==== |
| |
= Appendix A: Status Switch = |
|
= Appendix A: Status Switch = |
| - |
Valid choices for '''STATUS''' (noted by ''XX'' in the examples above) can be:
|
+ |
Valid choices for '''STATUS''' (noted by ''XX'' or ''YY'' in the examples above) can be:
|
