jquery 数据表中的组 Concat 方法

Question

我添加了jquery数据表并发出ajax请求。在服务器端，我正在使用表的连接。数据表加载完美，但搜索过滤器无法正常工作。搜索 ajax 调用时显示找不到列"screen"，这是真的，因为它在数据库中不存在。我该如何解决这个问题？

$data = self::sql_exec( $db, $bindings,
"select r.title,group_concat(distinct n.name) as screens, group_concat(na.action) as permissions "."
FROM `$table` as r
left JOIN permissions p on p.role_id = r.id
left join `navigations` n on n.id = p.nav_id 
left join `navigation_actions` na on na.id = p.action_id 
$where
group by r.id
$order
$limit
"
);

Answer 1

一种解决方案是在此语句之上具有另一个选择语句。

示例(在 mysql 中(：

SELECT * FROM (
"select r.title,group_concat(distinct n.name) as screens, group_concat(na.action) as permissions "."
FROM `$table` as r
left JOIN permissions p on p.role_id = r.id
left join `navigations` n on n.id = p.nav_id 
left join `navigation_actions` na on na.id = p.action_id 
$where
group by r.id
$order
$limit
"
) AS my_table WHERE screens = "your_query_data"