为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:win10
【CPU】:
【问题描述】*:无法解析的成员访问表达式[GROUP_CONCAT]
sql语句:select
id ,
code ,
company_id companyId ,
create_by createBy ,
create_date createDate ,
is_delete isDelete ,
office_id officeId ,
update_by updateBy ,
update_date updateDate ,
name ,
project_id projectId ,
version_id versionId ,
parent_id parentId ,
parent_ids parentIds ,
plan_begin_date planBeginDate ,
plan_end_date planEndDate ,
actual_end_date ,
duration ,
plan_working_hours planWorkingHours ,
actual_working_hours actualWorkingHours,
complete_percent completePercent ,
prev_task_id prevTaskId ,
priority ,
task_type taskType ,
is_leaf_node isLeafNode ,
status ,
type ,
delivery ,
attachments ,
description ,
person_liable_ids personLiableIds ,
person_liable_names personLiableNames ,
sequence ,
(
select
GROUP_CONCAT(sequence)
from
pm_project_plan
where
FIND_IN_SET(id, ppp.prev_task_id)
)
prev
from
pm_project_plan ppp
where
project_id = ?
and version_id = ?
and is_delete = 0
and type = 1
order by
sequence
GROUP_CONCAT()是mysql的函数,实现行转列功能
在达梦中可以使用wm_concat(),功能以及使用语法是一样的
mysql: select id ,group_concat(info) from test group by id;
DM: select id ,wm_concat(info) from test group by id;
不支持mysql的GROUP_CONCAT函数 可以使用oracle 的wm_concat() 函数,