查询泛微OA的流程引擎下面的所有有效流程表单信息:
SELECT
a.id,
b.id as workflowid ,
(
SELECT
indexdesc
from
HtmlLabelIndex
WHERE
id = a.namelabel) as formname,
a.tablename,
wb.tablename dtltablename,
c.typename,
b.workflowname,
b.isvalid
from
workflow_bill a
inner join workflow_billdetailtable wb on
a.id = wb.billid
inner join workflow_base b on
a.id = b.formid
left join workflow_type c on
b.workflowtype = c.id
WHERE
b.isvalid = 1