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.

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?

Parents
  • 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?

  • 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

Reply
  • 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

Children