Hello i have this query that works in the SWQL studio but when i try to add it to a web based report it says invalid if i remove the parameter it works. How do i add a User defined parameter to a web based report?
SELECT TOP 1000 N.DisplayName, E.EventTime, E.EventType, C.storeNo, E.Message
FROM Orion.Events E inner join Orion.Nodes N on E.NetworkNode = N.NodeID INNER JOIN Orion.NodesCustomProperties C on C.NodeID = N.NodeID
where EventType = 5000 and C.StoreNo = @TEST