[泛微]字段查流程 表名查流程

根据字段查流程
select c.id,c.workflowname,b.indexdesc,a.fieldname from workflow_billfield a, HtmlLabelIndex b ,workflow_base c
where b.id = a.fieldlabel and a.billid = c.formid and b.indexdesc like ‘%订单号%’

表名查流程
–表名查流程
select a.workflowname,a.formid from workflow_base a, workflow_bill b where a.formid = b.id
and b.tablename=’formtable_main_333′

发表评论