This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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