Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Dashboard - md-table-container


  • Hi,

    I have created a couple of devices (e.g. Dev1, Dev2, Dev3...) with the same data points (Pt1, Pt2, Pt3,...)

    How do I create a table that shows in the following format?

    0_1596121791414_eaa7bc35-af6a-4be5-9393-e380adb78eb5-image.png

    BR,
    Ricardo


  • https://forum.infiniteautomation.com/topic/4883/events-table-for-a-specific-data-source/2

    Do some forum searching please.

    replace pt.activeEvents with pt.value

    Also, this post.shows.you how to iterate through point values...
    https://forum.infiniteautomation.com/topic/4843/dashboard-losing-connectivity


  • Thanks Matt for the pointers. Here are my screen shot and final code below.

    Now that I have the table, how can I create a device name query that can filter for devices with a point that equals a certain value? For example, how do I modify my code below to only show the device with Assigned == Yes?

    0_1597396419334_99613843-4f28-4cff-b9d3-6c3a74f4b64d-image.png

    <ma-device-name-query device-names="deviceNames" contains="'Tag-'"></ma-device-name-query>
    
    <md-table-container>
        <table md-table>
            <thead md-head>
                <tr md-row>
                    <th md-column>Device Name</th>
                    <th md-column>Alarm</th>
                    <th md-column>Assigned</th>
                    <th md-column>Location</th>
                    <th md-column>Timestamp</th>
                </tr>
            </thead>
            <tbody>
                <tr ng-repeat="device in deviceNames">
                    <td>{{device}}</td>
                    <td><ma-point-value point-xid="{{'DP_' + device + '-Alarm'}}"></ma-point-value></td>
                    <td><ma-point-value point-xid="{{'DP_' + device + '-Assigned'}}"></ma-point-value></td>
                    <td><ma-point-value point-xid="{{'DP_' + device + '-Location'}}"></ma-point-value></td>
                    <td><ma-point-value point-xid="{{'DP_' + device + '-Location'}}" display-type="dateTime" date-time-format="LTS"></ma-point-value></td>
                </tr>
            </tbody>
        </table>
    </md-table-container>```
    
    

  • Nicely done, thanks for giving it a go!
    Ok I suggest you try the ma-get-point-value component.

    <tr ng-show="assigned[device].value=='yes'" ng-repeat="device in deviceNames">
                    <td>{{device}}</td>
                    <td><ma-point-value point-xid="{{'DP_' + device + '-Alarm'}}"></ma-point-value></td>
                    <td><ma-get-point-value point-xid="{{'DP_' + device + '-Assigned'}}" point="assigned[device]"></ma-point-value>{{assigned[device].value}}</td>
                    <td><ma-point-value point-xid="{{'DP_' + device + '-Location'}}"></ma-point-value></td>
                    <td><ma-point-value point-xid="{{'DP_' + device + '-Location'}}" display-type="dateTime" date-time-format="LTS"></ma-point-value></td>
                </tr>
    

    Fox