View limitation interfering with custom table generation

I have created custom table using SWQL. It displays properly on a view with no view limitation. When I add a view limitation the custom table just displays  .

Here is what it should look like.

And here is the SWQL that generates the datasource for the Custom Table widget.

select n.DetailsUrl as [DetailsUrl], n.DisplayName as [Name], a.CurrentValue as [Input], output.CurrentValue as [Output], current.CurrentValue as [Current], temp.CurrentValue as [Temperature]
from orion.npm.CustomPollerAssignment a
join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID
join orion.Nodes n on a.NodeID=n.NodeID

join (select a.CurrentValue, a.NodeID as node
from orion.npm.CustomPollerAssignment a
join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID
join orion.Nodes n on a.NodeID=n.NodeID
where b.UniqueName = 'BMMoutputVoltage') as output on a.NodeID = output.node

join (select a.CurrentValue, a.NodeID as node
from orion.npm.CustomPollerAssignment a
join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID
join orion.Nodes n on a.NodeID=n.NodeID
where b.UniqueName = 'BMMoutputCurrent') as current on a.NodeID = current.node

join (select a.CurrentValue, a.NodeID as node
from orion.npm.CustomPollerAssignment a
join orion.npm.CustomPollers b on a.CustomPollerID=b.CustomPollerID
join orion.Nodes n on a.NodeID=n.NodeID
where b.UniqueName = 'BMMbatteryTempF') as temp on a.NodeID = temp.node

where b.UniqueName = 'BMMinputVoltage'
order by n.DisplayName
Parents Reply Children
No Data