修正線上進行中的舊表單Js程式

1.      用[程式片段]定位線上進行中所有的表單版號

DECLARE @CODE NVARCHAR(4000) = '[要尋找的程式片段]';   
 
SELECT   
    DISTINCT FormDefinition.id,   
    FormDefinition.version,   
    FormDefinition.formDefinitionName,   
    CAST(FormDefinition.script AS NVARCHAR(MAX)) AS script,   
    '進行中' AS status   
FROM   
    ProcessInstance   
    INNER JOIN LocalRelevantData ON LocalRelevantData.containerOID = ProcessInstance.contextOID   
    INNER JOIN FormInstance ON FormInstance.OID = LocalRelevantData.valueOID   
    INNER JOIN FormDefinition ON FormDefinition.OID = FormInstance.definitionOID   
WHERE   
    ProcessInstance.currentState IN (0, 1, 2)   
    AND FormDefinition.script LIKE '%' + @CODE + '%'   
UNION   
SELECT   
    id,   
    version,   
    formDefinitionName,   
    CAST(FormDefinition.script AS NVARCHAR(MAX)) AS script,   
    '最新版' AS status   
FROM   
    FormDefinition   
WHERE   
    publicationStatus = 'RELEASED'   
    AND FormDefinition.script LIKE '%' + @CODE + '%';

2.     
在表單設計師→右鍵[檢視表單發行歷程]→找到對應版號→右鍵[取出此版本]→修正Js程式→按[更新腳本]即可。

easyflow gp, sql — 2019年5月28日