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.
maEvents and query by tags not working.
-
We are trying to filter the data using maEvents
in the way as below
getEvents() {
this.Events
.buildQuery()
.and()
.eq('active', true)
//.eq('eventType', 'DATA_POINT')
.eq('tags.Site', 'WC')
.limit(1000)
.query()
.then(events => {
this.eventsCount = this.mapEvents(events);
this.myAlert = this.eventsCount.information + this.eventsCount.important;
this.subscribeToEvents();
});Possibly unhandled rejection: {"data":{"cause":"ShouldNeverHappenException: No column found for: tags.Site","mangoStatusCode":-1,"mangoStatusName":null,"localizedMessage":"Internal Server Error — com.serotonin.ShouldNeverHappenException: No column found for: tags.Site"},"status":500,"config":{"method":"GET","transformRequest":[null],"jsonpCallbackParam":"callback","timeout":{},"url":"/rest/v1/events","params":{},"headers":{"Accept":"application/json, text/plain, /","X-Requested-With":"XMLHttpRequest","X-XSRF-TOKEN":"d0c58960-cbc6-44c3-8952-49cb6f254e2b"},"cached":false},"statusText":"Server Error","xhrStatus":"complete","mangoStatusText":"Internal Server Error — com.serotonin.ShouldNeverHappenException: No column found for: tags.Site","mangoStatusTextShort":"Internal Server Error — com.serotonin.ShouldNeverHappenException: No column found for: tags.Site","resource":[]}
Then we tried doing the below method:
rqlQuery = "eq(tags.Site,WC)&eq(name,State)";
"this.Point.query({rqlQuery}"This is working but the data is not in prescribed manner and on using with maPoints its showing the below error.
We are trying to follow the example of alarmList.js page of hvac dashboard model
https://docs-v4.mango-os.com/hvac-dashboard-development-create-alarm-list-component