需要一个新功能 云表模板在MSSQL数据库中字段的含义对照表
场景：由于公司有多个业务系统，为实现数据共享，因此需要开放一些云表平台的数据给其他平台的业务系统 进行数据共享。
共享方式； 授权 ”自定义的数据库视图“给外部程序。
问题：
由于 云表模板对应的数据库表，在数据库中 字段全部是，“f1-f2....”等等 数字段 没有实际的意义 ，无法和模板中的数据字段关联起来，自定义视图不能实习。
需求：
希望官方给出模板和数据库字段对照表。或则别的解决方式。
在lato_template_svn2中m_templateJson中有字段对照
例子：
{
"allowManualLock": true,
"attachmentTableCaption": "附件",
"barBtnIndex": -1,
"caption": "",
"catalogCaption": "基础档案",
"catalogId": "60",
"classInfo": {
"name": "表单定义",
"version": 1
},
"classTemplateName": "表单定义",
"clientFormConfig": {
"fieldControlList": []
},
"creatorViewClassId": "",
"dataSourceName": "",
"dataTableList": [],
"enabled": false,
"formId": "339",
"formListConfig": {
"caption": "",
"isDontShowZero": false,
"isShowDetail": false,
"pageConfig": {
"defaultPageSize": 50,
"isRowCount": 200,
"isUseRowIndex": true
}
},
"formListViewClassId": "formListGridView",
"formStyle": "page",
"formViewClassId": "rangeFormView",
"functions": {
"nameSeed": 1
},
"hasBizFormula": false,
"imageIndex": 55,
"isDefault": false,
"isNonpersistent": false,
"isOnlyDeveloperVisible": false,
"isShowInCatalog": false,
"isSupportMultiDevice": false,
"isUseAttachment": false,
"latoVersion": 0,
"lockCondition": "",
"privilegeList": [],
"seq": 0,
"styleFileId": "339",
"styleFileType": "ejun",
"tableMapList": [
{
"fieldMapList": [
{
"caption": "车型",
"col": 8,
"dataSpec": null,
"defValue": "",
"editable": true,
"fieldKind": "dataField",
"formatString": "@",
"friendlyName": "",
"gridName": "sheet1",
"isMergeSameValue": false,
"isPrimaryKey": false,
"isTemp": false,
"mustFill": false,
"name": "f2",
"readOnly": false,
"row": 4,
"type": 0,
"visible": true,
"width": 75
},
{
"caption": "代号",
"col": 3,
"dataSpec": null,
"defValue": "",
"editable": true,
"fieldKind": "dataField",
"formatString": "@",
"friendlyName": "",
"gridName": "sheet1",
"isMergeSameValue": false,
"isPrimaryKey": true,
"isTemp": false,
"mustFill": false,
"name": "f3",
"readOnly": false,
"row": 4,
"type": 0,
"visible": true,
"width": 75
}
],
"fillDirection": 0,
"formCodeFieldCaption": "",
"gridName": "",
"gridRange": "",
"isAllowExtendData": true,
"isAllowHoriExtendData": false,
"isCreateDB": true,
"name": "tableDefine0",
"nameSeed": 3,
"sortFieldList": [],
"tableCaption": "车型",
"tableName": "t10001_C2301",
"version": 1,
"formCodeFieldName": ""
}
],
"tableMapNameSeed": 0,
"templateCode": "车型",
"templateName": "车型",
"templateUrl": "template",
"toolBar": "",
"type": "form",
"url": "new",
"workflowDefine": {
"actionType": "review",
"completeButtonCaption": "",
"enable": true,
"isLockFormAfterFinish": false,
"isSendEmail": false,
"isSendSMS": false,
"startButtonCaption": "",
"summaryExpress": "",
"taskList": {
"itemList": [],
"stateField": ""
},
"type": "simple",
"user": {
"srcObject": {
"filter": "",
"functionCaption": "11",
"functionName": "11",
"functionType": 3,
"isAllowInput": false,
"isComposeMultiRecAsOne": false,
"isMultiSelect": false,
"isNotShowDlgWhenEmpty": false,
"isShowDialog": true,
"templateId": "0",
"templateName": "",
"type": "templateFunction"
}
},
"version": 2
}
} 非常感谢
其实不用这么麻烦，数据表管理里面位置和名称之间隐藏了一个字段，是数据库对应的字段名
页:
[1]