取得線上全部流程序號名稱

SELECT   
     ProcessDefinition.id,   
     ProcessDefinition.processDefinitionName   
 FROM   
     ProcessPackage   
     INNER JOIN ProcessPackageCmItem ON ProcessPackage.containerOID = ProcessPackageCmItem.OID   
     INNER JOIN RedefinableHeader ON ProcessPackage.redefinableHeaderOID = RedefinableHeader.OID   
     INNER JOIN ProcessPackageHeader ON ProcessPackage.headerOID = ProcessPackageHeader.OID   
     INNER JOIN ProcessPackage_ProcessDef ON ProcessPackage.OID = ProcessPackage_ProcessDef.ProcessPackageOID   
     INNER JOIN ProcessDefinition ON ProcessPackage.id = ProcessDefinition.id   
     INNER JOIN ProcessDefinitionHeader ON ProcessDefinition.headerOID = ProcessDefinitionHeader.OID   
 WHERE   
     ProcessDefinition.OID = ProcessPackage_ProcessDef.ProcessDefinitionOID   
     AND ProcessPackageCmItem.lastVersion = RedefinableHeader.version   
     AND validTo >= GETDATE()   
     AND RedefinableHeader.publicationStatus = 'RELEASED'

easyflow gp, sql — 2019年7月17日