摘要:
SELECT wb.workflowname AS 流程名称, wb.FORMID AS 表单或单据id, wb.ISBILL AS 单据还是表单, wn.nodename AS 节点名称, wbf.fieldlabel AS 字段中文名称的id, hf.LABELNAME AS 字段中文名, wb 阅读全文
摘要:
当workflow_billfield表中的fieldhtmltype = 3,type=7时,浏览框为客户 SELECT * FROM workflow_billfield WHERE ID = 7884 -- 查询系统内置浏览框的类型 SELECT * FROM WORKFLOW_BROWSER 阅读全文
摘要:
问题描述: 有年假余额,但在提交请年假流程时报错“可用假期余额为0” 原因排查 员工假期余额被冻结,假期余额还剩下32个小时,但被冻结了40个小时。 SELECT * FROM KQ_ATT_VACATION WHERE resourceid='人员ID' AND newleavetype IN ( 阅读全文