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.

@joelhaggar I looked at that documentation and i figured out how to do everything except get a list of values for each row under the name column. I can only get info for the first column, whether I'm doing row or column based query.
0_1510612638231_SQL.JPG

For example, I want to get a list in my javascript of everything under the "NAME" column so the result should be [play-area-admin, TC Gauges, custom-user-pages, Profile, hello .. etc].

I'm not really sure what you are referring to but here is one thing you can look at:

Enable Auto Scaling:
https://help.infiniteautomation.com/enabling-auto-scale/

Hi Pedro,

This was by design to keep compatibility with the old permissions system on the graphical views, I believe. The difference in code is simply adding

Permissions.ensureDataPointSetPermission(user, point);

at GraphicalViewDwr::372

Wonderful!!!

It works perfectly :D

Thanks @phildunlap

Another thing to consider is adding another SQL point that runs a delete statement on the table, such that after the script runs only the last day of data is in the table. You would simply write the delete statement in another "Modify table only" point and then set it to any value at all (presuming it has no parameters). You would then want to update the DataPointQuery call so as not to publish that point (not that it would matter much)

@phildunlap No: user id = 53. The blank fields for that user are homeUrl and timezone. All other fields are filled in.

Phil,

The 5V power supply was being used for the barrel jack directly on the single board computer (SBC) in the ES. The first unit we received from IAS actually came with a similar power supply, and we've been using them for powering ES devices on the lab bench while we configure them.

Moving forward, we're going to switch to using the screw terminal block power input with a compatible power source.

@avilla said in Help using MangoAPI to Set Point Values:

Also as you may have noticed I'm simply modifying the loginPageTemplate for my own GUI, is there a better way to create an angular app from scratch? I don't actually need the login template.

Have you considered just using the Dashboard Designer or Custom Pages? Are you using Mango 3?

Yeah there are definitely a lot of ways it could work. If they XIDs are programmatic or your fingers have too much sensation left, you can just have a big constant object you loop over....

var configured = {"reportName": ["Xid-for-excelReports.timeSeries[0].points-position-0", "...-position-1"], .... } //JSON.parse(someAlphanumericPointForStorage.value); //Or yeah, use the JSON store for(var report in configured) { var points = configured[report]; foundTeplate.name = report; for(var k = 0; k < points.length; k+=1) foundTemplate.timeSeries[0].points[k].pointXid = points[k]; /* Do import, launch report, take a break, continue */ }

Hi Nikospps,

I responded in your thread, but I'm not sure I understand what you mean "verify next step button." Can you post a screenshot?

Hi morris,

Thanks for sharing the resolution!

Certainly! Glad you got it resolved. Be sure to keep an eye on the data source event levels in the future while troubleshooting!

point is the variable name I gave to the meta data point the script is in. It defaults to my I believe, there is a text box for it on the meta data point edit page.

Hi Dovydas,

I have sent you an email!

@dovydasz If you are just trying to put a live view of the camera onto your dashboard you can probably use a simple HTML5 <video> tag as suggested by Maxim. It will depend on the camera and the codec it uses, I suggest you consult your camera's documentation.

The HTTP image data source can save a frame from your video every x seconds provided it provides its output as an image via HTTP. This is not really well suited to video though.

You're welcome!