|
|
【myApps/OBPM版本号】:v5.0- sp 1
【浏览器类型】:Chrome/其他
【联系方式-QQ】:请留下您的QQ号码
【联系电话】: 请留下您的联系电话,以便技术同事更好解决您的问题
【问题描述】:
Q:
这个视图配在菜单里正常,被包含进别的表单就不正常
报错,unknown column parent in where clause
A:
少了parent字段
没有字段就写空
以下补上id字段
(在外面包一层,按照这个模式写)
"select * from (select 'a' as id, '' as item_父节点编号, '1' as item_本节点编号, '中国' as item_本节点名称, '"+getDomainid()+"' domainid union all "+
"select 'b' as id, '1' as item_父节点编号, '2' as item_本节点编号, '广东' as item_本节点名称, '"+getDomainid()+"' domainid union all "+
"select 'c' as id, '1' as item_父节点编号, '3' as item_本节点编号, '北京' as item_本节点名称, '"+getDomainid()+"' domainid) aa"
|
|