RS Query error Recursive common table expression does not contain the top-level UNION all operator

When it comes to the model in FM, the query SQL that modifies the physical layer is as follows

SELECT * FROM Target_visit_gh
where GHKSDM in
(
Select dept_id from Dim_bi_dept_role where #sq (Camidlist ()) # like '%g:cn= ' +role_id+ ' "% '
) or #sq (Camidlist ()) # like '%g:cn=admingroup '% '

The result is an error when Ruan report, as shown in

is to solve the idea:

1: Copy SQL to local sqlservers database, execute report same error

2: But inside the FM test is OK

3: Then the problem occurs when the report run starts sending SQL to the database, the SQL database adapter that is sent is not adapted to cause the problem

Workaround:

Open the RS query and modify the query's properties

OK, next turn off the browser, re-test, the problem is gone.

RS Query error Recursive common table expression does not contain the top-level UNION all operator