logo
Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
venky  
#1 Posted : Thursday, December 1, 2022 8:41:43 AM(UTC)
venky

Rank: Newbie

Groups: Registered
Joined: 12/1/2022(UTC)
Posts: 3
India

Thanks: 2 times
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
epf  
#2 Posted : Thursday, December 1, 2022 5:32:32 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,208
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
to use restriction with CTE, perhaps you may try to use Common Restrictions.
Please check: https://sealreport.org/Sources#lineTables_cr
thanks 1 user thanked epf for this useful post.
venky on 12/2/2022(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.