1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
| SELECT
wb.ID AS "流程ID",
wb.workflowname AS "流程名称",
wb.workflowtype AS "流程类型ID",
bid.ID AS "字段ID",
bid.DSPORDER AS "字段排序",
'field' || bid.ID AS "页面字段ID",
hl.indexdesc AS "字段名称",
bid.fieldname AS "字段代码",
bid.FIELDDBTYPE AS "字段数据类型",
DECODE(
bid.Fieldhtmltype,
1,
'单行文本框',
2,
'多行文本框',
3,
'浏览按钮',
4,
'check框',
5,
'选择框',
6,
'附件上传',
7,
'特殊字段',
'未知'
) AS 字段显示形式,
DECODE( wb.isvalid, 0, '失效', 1, '有效', 2, '测试', 3, '待上线', '未知' ) AS "流程状态",
bi.TABLENAME AS "主表名称",
bid.detailtable AS "明细表名称",
DECODE( bid.Viewtype, 0, '主表字段', 1, '明细字段', '未知' ) AS "字段类型",
(
SELECT
listagg ( '[' || ws.SELECTVALUE || '|' || ws.SELECTNAME || ']', ',' ) WITHIN GROUP ( ORDER BY ws.SELECTVALUE ) names
FROM
workflow_selectitem ws
WHERE
ws.FIELDID = bid.ID
) AS 下拉框
FROM
workflow_bill bi
INNER JOIN workflow_billfield bid ON bi.ID = bid.BILLID
INNER JOIN WORKFLOW_BASE wb ON wb.formid = bid.billid
INNER JOIN htmllabelindex hl ON hl.id = bid.FIELDLABEL
WHERE
wb.id = 1006241
ORDER BY
bid.Viewtype,
bid.detailtable,
bid.DSPORDER;
|
