bFilter breaking with GROUP_CONCAT
bFilter breaking with GROUP_CONCAT
drpuddingq
Posts: 9Questions: 0Answers: 0
I am finding that when I use a GROUP_CONCAT in my DataTables query, the filter no longer works and is stuck on Processing. Is this a known issue? Any suggested workaround is welcome!
[code]
select
users.id, users.username, users.email, group_concat(roles.name) as rolenames
from
users
left join
assigned_roles on assigned_roles.user_id = users.id
left join
roles on roles.id = assigned_roles.role_id
group by
users.id
[/code]
[code]
select
users.id, users.username, users.email, group_concat(roles.name) as rolenames
from
users
left join
assigned_roles on assigned_roles.user_id = users.id
left join
roles on roles.id = assigned_roles.role_id
group by
users.id
[/code]
This discussion has been closed.