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

  • When I run sql statement select * from pointvalues in mango sql console, the pointvalues table is empty. I have a backup copy of MangoSQL but it has extension .data format. I want to access the pointvalues table.

    1.What should I need to do to view the pointvalues table?
    2.Is it possible to attach the data file into H2 database so that I can execute the query for the pointvalues table in mango sql console?
    3.Is there any specific setting need to be configured for MangoNoSQL in the env.properties?

    Any help will be appreciated. Thanks


  • When you are using the Mango NoSQL database the data is not stored in the pointvalues table and rather in the NoSQL database. See this video for more information: The .data files are the NoSQL files where the data is stored. The number like 692.data refers to the date range within the file and the folder number it is in is the data point ID that relates to the dataPoint table. http://help.infiniteautomation.com/support/solutions/articles/14000022517-enterprise-nosql-database