【DM版本】:DM8
【操作系统】：DM8 + idea
【CPU】:
【问题描述】*：无法解析的成员访问表达式[FIND_IN_SET]
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_revised WHERE FIND_IN_SET ( id, ppp.prev_task_id ) ) prev
FROM
pm_project_plan_revised ppp
WHERE
project_id = ?
AND version_id = ?
AND is_delete = 0
AND type = 1
ORDER BY
sequence