• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 4 Documentation Website Mango 5 Documentation Website Radix IoT LinkedIn

    maEvents and query by tags not working.

    Scheduled Pinned Locked Moved Dashboard Designer & Custom AngularJS Pages
    1 Posts 1 Posters 595 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • H Offline
      himanshu
      last edited by

      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

      1 Reply Last reply Reply Quote 0

      Hello! It looks like you're interested in this conversation, but you don't have an account yet.

      Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

      With your input, this post could be even better 💗

      Register Login
      • First post
        Last post