Hi all,

On the seal, the report used an mssql query for selecting the data, when using restriction it only gets affected for mail select statement its not getting affected for queries used in 'common table expression', don't know how to use restriction for 'common table expression', anyone knows the solution for this?


Example query:


WITH CTE_TEST AS (
Select * from tblbase
)

Select
col1,
col2,
select col3 from CTE_TEST
FROM
(Select * from tblbase) as CET

Thanks