查询扩展属性 - 业务服务

接口名称：queryExtensionAttribute
SELECT A.ID, A.ORG_CODE, A.NAME, A.OPERATION_TYPE, A.UI_NAME, A.TABLE_NAME, A.REMARK,
A.SORTID, A.CREATE_USER, A.UPDATE_USER, A.CREATE_DATE, A.UPDATE_DATE, A.IS_DELETE,
A.UPDATEKEY, A.PLAT_ID,B.NAME AS TABLE_NAME_SHOW,C.NAME AS CATALOG_NAME,
CASE A.OPERATION_TYPE WHEN 0 THEN '复选框' WHEN 1 THEN '文本框' WHEN 3 THEN '日期控件' else '下拉框' end OPERATION_NAME
FROM BASEDATA.BAS_ORG_EXPAND_DICT A
LEFT JOIN BASEDATA.BAS_DICT_DETAIL B ON B.CATALOG_CODE='ExpandDictTable' AND B.CODE=A.TABLE_NAME AND B.ORG_CODE=A.ORG_CODE
LEFT JOIN BASEDATA.BAS_DICT_CATALOG C ON C.ORG_CODE=A.ORG_CODE AND C.CODE=A.REMARK AND A.OPERATION_TYPE='2'
order by A.TABLE_NAME,A.SORTID;

https://www.processon.com/f/681c7d9dd8819d2298696507#查询扩展属性

请求参数

Header 参数

Token

string

可选

默认值:

7d7bc205-a05f-40a0-a79b-addea1ded679

示例值:

7d7bc205-a05f-40a0-a79b-addea1ded679

appId

string

可选

默认值:

trasen

Body 参数application/json

orgCode

string

机构代码

必需

数据库字段：ORG_CODE

<= 50 字符

hospCode

string | null

院区编码

必需

数据库字段：HOSP_CODE

tableNameList

array[string]

表名集合

可选

对应后台表结构字段TABLE_NAME

extensionIdList

array[string]

扩展属性ID集合

可选

isDelete

string

删除标志

可选

N 未删除；Y 已删除

示例

{
    "orgCode": "string",
    "hospCode": "string",
    "tableNameList": [
        "string"
    ],
    "extensionIdList": [
        "string"
    ],
    "isDelete": "string"
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

Code

string

返回码

必需

200段正常返回 400段业务逻辑错误 500段系统级代码级错误

Message

string

消息

可选

exception

string

详细异常

可选

apiCode

string

接口编码

可选

data

object

必需

list

array[object (MD扩展属性表) {17}]

必需

示例

{
    "Code": "string",
    "Message": "string",
    "exception": "string",
    "apiCode": "string",
    "data": {
        "list": [
            {
                "id": "string",
                "orgCode": "string",
                "createDate": "2019-08-24",
                "createUserId": "string",
                "updateDate": "2019-08-24",
                "updateUserId": "string",
                "isDelete": "N",
                "updatekey": "BASEDATA.ISEQ$$_104905.nextval",
                "controlName": "string",
                "controlType": 0,
                "uiName": "string",
                "tableName": "string",
                "bindDataCode": "string",
                "sortNo": 0,
                "platId": "string",
                "controlTypeName": "string",
                "bindDataName": "string"
            }
        ]
    }
}