Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Online报表 数据规则不正确 #6831

Closed
157677678 opened this issue Mar 23, 2023 · 2 comments
Closed

Online报表 数据规则不正确 #6831

157677678 opened this issue Mar 23, 2023 · 2 comments

Comments

@157677678
Copy link

157677678 commented Mar 23, 2023 •
edited
Loading

版本号：

3.5.0

问题描述：

在使用报表的数据规则时候，不能引用表里有但是报表里没有的字段 也不能使用sys_multi_org

截图&代码：

比如
给 统计在线用户 报表
添加菜单 及数据规则 createBy= 'sys_user_code'
生成的sql如下

select * from (select realname,username,sex,birthday,avatar,phone,email from sys_user) jeecg_rp_temp  where jeecg_rp_temp.createBy=?

用 sys_multi_org 会直接翻译成 字符串“A01A01,A02A02”，只能自己在sql中 用instr
@zhangdaiscott
Copy link
Member

ty

@jeecgboot jeecgboot deleted a comment from 157677678 Jul 17, 2023
@zhangdaiscott zhangdaiscott mentioned this issue Jul 17, 2023
Open
@zhangdaiscott
Copy link
Member

非bug 暂时归集到 #1312 ，待后期规划

@zhangdaiscott zhangdaiscott transferred this issue from another repository Jul 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@zhangdaiscott @157677678