查询泛微OA的流程引擎下面的所有有效流程表单信息:
SELECTa.id,b.id as workflowid ,(SELECTindexdescfromHtmlLabelIndexWHEREid = a.namelabel) as formname,a.tablename,wb.tablename dtltablename,c.typename,b.workflowname,b.isvalidfromworkflow_bill ainner join workflow_billdetailtable wb ona.id = wb.billidinner join workflow_base b ona.id = b.formidleft join workflow_type c onb.workflowtype = c.idWHEREb.isvalid = 1