如何预置一个全局方案

栏目：云苍穹知识作者：金蝶来源：金蝶云社区发布：2024-09-23浏览：1

如何预置一个全局方案

有些场景需要预置一些共用的方案给表单的所有用户

如果是非布局的方案可以使用系统服务云->配置工具->过滤方案配置->全局方案

1. 首先需要在表单上保存一个方案

2. 新增全局方案

表单输入“xjTest123”，方案输入“123”

对于布局需要通过脚本进行预置

1. 查询方案

select * from t_bas_filterscheme where fschemename='123' and fformid='xjtest123'

2. 导出方案数据为预插脚本

INSERT INTO `bos_branch_dev_new_sys`.`t_bas_filterscheme` (`FSCHEMEID`, `FFORMID`, `FSCHEMENAME`, `FUSERID`, `FISDEFAULT`, `FSCHEME`, `FISSHARE`, `FNEXTENTRYSCHEME`, `FSEQ`, `FENTRYENTITY`, `FISFIXED`) VALUES ('/X28AT0P/WHH', 'xjtest123', '123', '13648', '0', 'rO0ABXNyABNqYXZhLnV0aWwuQXJyYXlMaXN0eIHSHZnHYZ0DAAFJAARzaXpleHAAAAACdwQAAAACc3IAF2phdmEudXRpbC5MaW5rZWRIYXNoTWFwNMBOXBBswPsCAAFaAAthY2Nlc3NPcmRlcnhyABFqYXZhLnV0aWwuSGFzaE1hcAUH2sHDFmDRAwACRgAKbG9hZEZhY3RvckkACXRocmVzaG9sZHhwP0AAAAAAAAx3CAAAABAAAAADdAAJRmllbGROYW1lc3EAfgAAAAAAAXcEAAAAAXQACXRleHRmaWVsZHh0AAdDb21wYXJlc3EAfgAAAAAAAXcEAAAAAXQAAjY3eHQABVZhbHVlc3EAfgAAAAAAAXcEAAAAAXQAAzEyMXh4AHNxAH4AAj9AAAAAAAAMdwgAAAAQAAAAA3EAfgAFc3EAfgAAAAAAAXcEAAAAAXQACWRhdGVmaWVsZHhxAH4ACHNxAH4AAAAAAAF3BAAAAAF0AAIxM3hxAH4AC3NxAH4AAAAAAAF3BAAAAAF0AAB4eAB4', '0', '0', '0', 'xjtest123', '0');

注意修改脚本的FISFIXED字段为’1’, 修改FUSERID为’0’

INSERT INTO t_bas_filterscheme (FSCHEMEID, FFORMID, FSCHEMENAME, FUSERID, FISDEFAULT, FSCHEME, FISSHARE, FNEXTENTRYSCHEME, FSEQ, FENTRYENTITY, FISFIXED) VALUES ('/X28AT0P/WHH', 'xjtest123', '123', '0', '0', 'rO0ABXNyABNqYXZhLnV0aWwuQXJyYXlMaXN0eIHSHZnHYZ0DAAFJAARzaXpleHAAAAACdwQAAAACc3IAF2phdmEudXRpbC5MaW5rZWRIYXNoTWFwNMBOXBBswPsCAAFaAAthY2Nlc3NPcmRlcnhyABFqYXZhLnV0aWwuSGFzaE1hcAUH2sHDFmDRAwACRgAKbG9hZEZhY3RvckkACXRocmVzaG9sZHhwP0AAAAAAAAx3CAAAABAAAAADdAAJRmllbGROYW1lc3EAfgAAAAAAAXcEAAAAAXQACXRleHRmaWVsZHh0AAdDb21wYXJlc3EAfgAAAAAAAXcEAAAAAXQAAjY3eHQABVZhbHVlc3EAfgAAAAAAAXcEAAAAAXQAAzEyMXh4AHNxAH4AAj9AAAAAAAAMdwgAAAAQAAAAA3EAfgAFc3EAfgAAAAAAAXcEAAAAAXQACWRhdGVmaWVsZHhxAH4ACHNxAH4AAAAAAAF3BAAAAAF0AAIxM3hxAH4AC3NxAH4AAAAAAAF3BAAAAAF0AAB4eAB4', '0', '0', '0', 'xjtest123', '1');

用脚本

select * from t_bas_filterscheme_l where fid='/X28AT0P/WHH'

导出多语言表数据

INSERT INTO t_bas_filterscheme_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('/X28AT0P/WHI', '/X28AT0P/WHH', 'en_US', '123', ' ');

INSERT INTO t_bas_filterscheme_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('/X28AT0P/3W7', '/X28AT0P/WHH', 'zh_CN', '123', ' ');

INSERT INTO t_bas_filterscheme_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('/X28AT0P/3W8', '/X28AT0P/WHH', 'zh_TW', '123', ' ');

3. 通过ksql工具校验上面的脚本

4. 将脚本翻译为具体的数据库方言进行执行