场景:
由于公司有多个业务系统,为实现数据共享,因此需要开放一些云表平台的数据给其他平台的业务系统 进行数据共享。
共享方式; 授权 ”自定义的数据库视图“给外部程序。

问题:
由于 云表模板对应的数据库表,在数据库中 字段全部是,“f1-f2....”等等 数字段 没有实际的意义 ,无法和模板中的数据字段关联起来,自定义视图不能实习。
需求:
希望官方给出模板和数据库字段对照表。或则别的解决方式。


+1 0
3条回帖
mfkpie8 云粉 2017-6-28 09:29:45
在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 0
沈阳 云侠 楼主 2017-6-29 10:55:14
非常感谢
+1 0
lato_will 云粉 2017-7-1 18:27:53
其实不用这么麻烦,数据表管理里面位置和名称之间隐藏了一个字段,是数据库对应的字段名

1498904819.jpg

1498904819.jpg
+1 0
需要登录后才可进行回复 登录

玩转云表从入门到精通
扫码添加微信立即领取

·云表创始人授课文件
·加入社群与培训学习
·切磋云表开发玩法

商务咨询:0756-3335860
客服咨询
Baidu
map