Custom Table widget with View Limitation not loading

I have a Custom Table widget that loads fine when not on a view with view limitations. Once view limitations are turned on it just says it is loading. Regardless of whether or not view limitations are on, the preview when editing the widget displays the correct data. 

Is it possible to turn off view limitations only on one widget within a view?

  • Depends on the definition of the Custom Table.  If the table is SWQL, then it's reporting as it should (based on the account or page limitations).  Any chance you can share the code behind the table or provide a screenshot and details on the limitation?

  • i will try last time I added code it thought it was spam

  • Here is what it should and does look like with out limitations. 

    The limitation setup is just a restriction to a specific group of nodes. 

  • select n.DisplayName as Name, n.DetailsUrl as _LinkFor_Name, a.CurrentValue as Vin, output.CurrentValue as Vout, current.CurrentValue as Amps, temp.CurrentValue as Temp
    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

  • Huh - it should be fine (the SWQL is valid).  What are the defined view limitations?

  • I just have the view limitation set to a Single Group. Yes, I have verified that a node with the defined pollers is included in the group. I also believe that this was once working at one time. I can't verify it, but it may have quit working when I upgraded to 2020.2.6.

  • I'd open a support case.  This has the feel of a bug, but I cannot be 100% sure without having more access to your system.