【泛微E9】查询流程表单字段是否设置了字段属性

SELECT 
    wb.workflowname AS 流程名称,
    wb.FORMID AS 表单或单据id,
    wb.ISBILL AS 单据还是表单,
    wn.nodename AS 节点名称,
    wbf.fieldlabel AS 字段中文名称的id,
    hf.LABELNAME AS 字段中文名,
    wbf.fieldname AS 字段数据库名称,
    wnf.fieldid AS 字段id,
    wnf.attrcontent AS SQL语句
FROM workflow_nodefieldattr wnf
JOIN workflow_flownode wf ON wnf.nodeid = wf.nodeid
JOIN workflow_base wb ON wf.workflowid = wb.id
JOIN workflow_nodebase wn ON wf.nodeid = wn.id
JOIN workflow_billfield wbf ON wnf.fieldid = wbf.id
JOIN htmllabelinfo hf ON wbf.fieldlabel = hf.INDEXID
WHERE wnf.attrcontent IS NOT NULL;

workflow_nodefieldattr：工作流Html字段附加属性表
isbill：0:表单 1:单据