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.

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

无法正确根据角色获取用户列表 #62

Open
hujianxiong opened this issue Dec 26, 2019 · 3 comments
Open

无法正确根据角色获取用户列表 #62

hujianxiong opened this issue Dec 26, 2019 · 3 comments

Comments

@hujianxiong
Copy link

选择角色时获取的用户列表不正确
internal/app/model/impl/gorm/internal/model/m_user.go 47行 db = db.Where("record_id IN (?) ",subQuery)
IN后面多了一对括号,导致生成的查询语句执行结果与预期不符,去了括号就正确了

@LyricTian
Copy link
Owner

已经修复,是前端查询参数的bug

@hujianxiong
Copy link
Author

查询参数不是这样的吗?
{ pageNo: 1, pageSize: 10, roleIDs: "aee5db6b-594f-45a5-ba1e-0616b7b99fa5,56aa471c-d405-4b0e-bdcc-9b67e9379e32", userName: "", realName: "", status: 0 }

@LyricTian
Copy link
Owner

已经修复,这个bug只有在sqlite3数据库下有问题,mysql下没问题

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants