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.

So an event detector must be used to trigger your alarm. That's exactly what I was in the middle of discussing with Hayden...

@terrypacker said in Dynamic select statement from SQL table using SQL data source: As a side note Mango 4.0 will have a Message event handler that will allow using Twilio and in the future other platforms to send messages. I've been wanting to do this! Thanks Terry!

That won't work for a start as point1Values will be an array, secondly, there is no such thing as an 'if' attribute in HTML. AngularJS supplies an "ng-if"but that's different again and works with angularJS variables. I was stating under the datapoint properties you can set min and max permitted values in the system I don't have the latest version of mango so i'm unable to give you a screenshot. But if you look under datasources -> points -> and edit the respective point you can make it ignore when you have 0s coming in from system resets. If however that is not possible and you need those zeroes then a function is required to filter them.

Okay, thank you. So we have to go through you guys for a license transfer and can't do that on our own? We'll take that into consideration on our setup.

@etantonio I believe you have made a typo on the moment filter: {{'now' | maMoment:'startOf':'month' | maMoment:'format':'dddd'}}. You forgot the ma

It's not working for me, I'll solve this repeating the page for any "trackerRowColumn" in the plant instead of creating a template to use for all the plant, thanks anyway. Antonio

Fantastic, thank you very much! I'll pass this along to the developers and let you know if we run into any issues. I appreciate the quick help.

@terrypacker Thanks for the reply. I have finally been able to connect. The solution was to change my h2-web-console.sh back to -webAllowOthers and my JDBC URL to jdbc:h2:/opt/mango/databases/mah2.199

@etienne-ott glad you got it sorted. The API can indeed be a very good way to do these sort of updates. For future reference, you can also export the data points as JSON, manipulate it, and reimport it.

You cannot do this on the query but you could do it on the update statement for the point. The setting of the SQL data point's value could be done via a Meta or Scripting data source. The help docs on the data source should get you going.

yes, you're right, the following code it's ok. thanks, var ssdao = new com.serotonin.m2m2.db.dao.SystemSettingsDao(); ssdao.setValue("emailFromName", "Etantonio"); instead for excelReport: var voExcelReport = com.infiniteautomation.mango.excelreports.dao.ExcelReportTemplateDao.instance.getByXid("My_DailyReport") voExcelReport.setName("Etantonio") com.infiniteautomation.mango.excelreports.dao.ExcelReportTemplateDao.instance.save(voExcelReport); Antonio

at the end of all the simplest working solution for me seems to be <ma-now update-interval="1 minutes" output="theTimeNow"></ma-now> <ma-calc input="theTimeNow | moment:'subtract':24:'hours'" output="theTimeADayAgo"></ma-calc> and then: <md-grid-list md-cols="11" md-gutter="0px" md-row-height="35px" ng-if="theTimeADayAgo.isBefore(TRK_0_1_automa_state.time)">

Have you checked under the examples menu? /ui/examples/svg/basic-usage There's also various help articles https://help.infiniteautomation.com/interactive-svg-graphics https://help.infiniteautomation.com/view-development-with-svg-in-mango https://help.infiniteautomation.com/dynamic-floor-plan There's also a lot of results if you search the forum. @etantonio said in Examples code is available?: it is interesting so I want to know if somewhere is available the corresponding code. Thanks, No I don't believe the markup is available anywhere. However there is nothing in particular special about that page, its some images, point value components and a <ma-tile-map>.

@craigweb said in SNMP Publisher / Agent: Hi @ricardo Mango only has 4 publishers: BACnet, Modbus, Mango PTCP and an HTTP publisher Also Twilio and Pachube.

Hi Joel, Thank you very much for taking the time to respond! I was kind of thinking this might be the case and BACnet is an element of possibility; it may just need to be done in phases or we go S4. Either way, this is good intel to bring back to the table to support moving forward with looking at Mango more seriously! Thanks Again, Shawn

Hi v8dave, That sounds to me like a time to use the ng-class attribute, where you can use logic to apply one or another CSS class. For example, this thread has an LED of many colors throbbing: https://forum.infiniteautomation.com/topic/4469/how-to-make-style-blinking-via-value/4 There are also many other examples of using ng-class on the forum.

@v8dave said in Can't get heading to change: This is the error from the console. mangoUi~ngMango~ngMangoServices.js?v=f41ab677f738e8ffe5b8:39 Error: <g> attribute transform: Expected number, "rotate()". You have not addressed any of the other comments I have made. You can see from that error that myDirection.value is undefined. See above for how to solve and for how to stop the error in the console.

For another option, the strategy I took was that I created global scripts to create the data points (MQTT/Modbus, virtual, meta) for my devices. The scripts I have are: dataPointJsonTempates --> This script contains the minimal set of values I need to set for each type of data point. createDataPointFunction --> This script contains the list of points I need for each of the devices. It loops through each list of points and calls the appropriate function below. createDeviceFunctions --> This script creates each of the appropriate data point, event detector, and event handlers. The intention was to detect the error generated when an unknown MQTT topic is subscribed to and create the required data points from the device id in the topic. I haven't gotten that working yet but it is a lower priority item at the moment. For now, I have a scripting data source to call the function: createDevice('PCU_110006'); I have created multiple 'createDataPointFunctions' scripts for the different devices I need. The same pattern is applied. Ian

to answer my own question, i found the statics in 'internal metrics': [image: FdY3sVa.png] [image: Xetr4DV.png]