注册

无法解析的成员访问表达式[GROUP_CONCAT]

ꪶꪮꪜꫀꪑꫀ 2021/09/27 2212 2 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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

回答 0
暂无回答
扫一扫
联系客服