Seal Report Forum
»
Report Edition
»
Reports
»
Can't get Restrictions to Work Now
Rank: Newbie
Groups ready for retrieval: Registered
Joined: 5/27/2021(UTC) Posts: 3  Was thanked: 1 time(s) in 1 post(s)
|
Note the where statements ignoring text values. Restrictions settings: Quote:[Description Contains 'UAP']
AND [Network Device Type Equals 'Wireless']
View SQL: Quote:
SELECT DISTINCT
Nodes.Caption AS C0,
Nodes.Description AS C1,
Nodes.Company AS C2,
Nodes.Site AS C3
FROM
(Nodes LEFT OUTER JOIN NodesCustomProperties
ON Nodes.NodeID = NodesCustomProperties.NodeID)
WHERE (Nodes.Description LIKE )
AND NodesCustomProperties.NetworkDeviceType IN ()
ORDER BY Nodes.Caption ASC,Nodes.Description ASC,Nodes.Company ASC,Nodes.Site ASC
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
it is strange, can you reproduce this with Northwind ?
Thanks
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
Can't get Restrictions to Work Now
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.
