为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:win10
【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 WHERE FIND_IN_SET( id, ppp.prev_task_id ) ) prev
FROM
pm_project_plan ppp
WHERE
project_id = ‘11’
AND version_id = ‘11’
AND is_delete = 0
AND type = 1
ORDER BY
sequence
如果你是从mysql迁移到DM,find_in_set函数可以改写成达梦的对应语法:https://eco.dameng.com/community/article/a92bc26bbf73142116a7ec0d3daadcdc