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.

Thank you! That probably won't make the point usable for what we want, but is good to know. I guess we could use the /data-sources/status/{xid} API endpoint and parse the results to see if there are any failures over the past x minutes.

Hi Nur

Phillip no longer works for IAS. The best solution I can think of is to create and virtual binary point. Use a setpoint event handler to set or reset this point on the data source alarm events.

For anyone interested, I did find a way around this. The issue isn't with Mango, but how Windows works. By default Windows does not allow a service to "see" mapped network drives.

The way around this was to create a link in C:\ to the folders we have set up on the network share.

mklink /D C:\Backups \\yourSharedServer\share\Backups

Doing this allows us to use the shared drive to house backups and other files. Before, when the drive was mapped as z:\ the Mango UI would say it couldn't find z:\Backups. Now it can find the link created and works well.

Thanks,
Chad

Might be worth writing your own bridge to parse the data between the two systems.
Are you using an RTU encapsulation to talk to the stm32 or is it just TCP directly to it?

Just thinking it would definitely be a better option than trying to talk to your micro and not brick anything....

Fox

Thanks, at the end the problem was solved on network side, it was really too slow. Thanks

Thanks, Joel and Matt for the replies. I'll try to put something together based on what you said.

It works,
thanks again,
Antonio

So an event detector must be used to trigger your alarm.

That's exactly what I was in the middle of discussing with Hayden...

No, it's built into the dashboard code amongst the event manager for websocket disconnections/timeouts.

@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