拼接问题

sql("FRformal", "WITH TaskCounts AS (

    SELECT

        a.User_Id,

        (

            SELECT 

                COUNT(b.User_Id)

            FROM PD_Users b

            LEFT JOIN VIEW_Project c ON c.Scorer_Personnel = b.User_Id

            LEFT JOIN VIEW_Project_Process d ON d.Project_Id = c.Project_Id AND d.Project_Node = c.Project_Node

            WHERE b.Position = '询价工程师'

                AND d.Project_Process = '待复核评分'

                AND (d.Project_State = 1 OR d.Project_State = 3)

                AND b.User_Id = a.User_Id 

                AND is_mark = '否'

        ) AS task_count

    FROM

        PD_Users a

    WHERE

        a.Position = '询价工程师'

        AND a.Data_State = 1 

        AND a.User_Id IN (SELECT person_id FROM PD_Allocation_Region)

),

MinTaskCount AS (

    SELECT MIN(task_count) AS min_task_count

    FROM TaskCounts

),

MinTaskUsers AS (

    SELECT User_Id

    FROM TaskCounts

    WHERE task_count = (SELECT min_task_count FROM MinTaskCount)

),

MinTaskUsersCount AS (

    SELECT COUNT(*) AS min_task_users_count

    FROM MinTaskUsers

),

RegionFilteredUsers AS (

    SELECT person_id

    FROM PD_Allocation_Region

    WHERE area = '"+AD7+"'

)

SELECT User_Id

FROM MinTaskUsers

WHERE 

    (SELECT min_task_users_count FROM MinTaskUsersCount) > 1

    AND User_Id IN (SELECT person_id FROM RegionFilteredUsers)

UNION ALL

SELECT User_Id

FROM MinTaskUsers

WHERE 

    (SELECT min_task_users_count FROM MinTaskUsersCount) = 1", 1, 1)

==============

主要是这边原因

这个不行，这里实际是字符串，不能用数据集那套，应该改成 sql("xxx","语句前半段....='"+AD7+"' 语句后半段",1,1)