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

Thanks Joel! This worked. However is there any way to make the time period dynamic. Ie. Instead of Month a user within DGLux would be able to select past 'Month, 2months, 3months or year.

I want to try to avoid creating seperate script and seperate variables for each time period.

I also was thinking if this is possible using a historical query table in DGLux? If I set the interval to 0 (when the parameter changes)
and set the period range (dynamic) and I sum the value column I believe I will end up with the count that I want.

Am I able to determine the sum of a column using a formula column and script? I have looked into using the rollup widget but have not been able to get anywhere with it.

Thanks,

There are lots of ways to do this. First make sure in the data point settings you have made the modbus point settable. Next on the graphic views add the point with one of the widgets. You can use a simple point to start with. Check both the Settable Override option and the display controls option. Now when you view the graphic view and hover the mouse over the item you will see a little wrench popup to allow you to set the points value.

You can also use a server side script to do all sorts of things. Here are some example scripts that would be helpful: http://infiniteautomation.com/wiki/doku.php?id=graphics:mango_graphic_views:server_side_script_examples

No, server side scrips are a totally different system. They actually run in the browser. Calling them server side scripts is missleading.

And i have tested, it is base on cron time,so the cron need after the 0 clock.

I could only find "Global Scripts" under the "Meta Data Source" and "Scripting Data Source" wiki headings. Consequently, it is unclear which of the "Scripting Data Source" recommendations also apply to global scripts (and also why I did not think to look at the icon bar for the Global Scripts). Specifically, the Scripting Data Source states:

Note how the typeof function is used to determine if constants need to be defined. This is an effective way of initializing the script context upon startup of the data source.

if (typeof(rho) == "undefined") { rho = 28; sigma = 10; beta = 8/3; dt = 0.01; }

I have defined functions containing equations in Global Scripts. They contain implicit constant definitions. For example:

return (2.43941E-7*W3 -0.5433*W2 +0.06*W+2.0)

The function seems to be working fine, but I'm concerned about the "effective way" cited on the Scripting Data Source page. Should I pull those constants out of the equation and declare them within a typeof structure? What are the implications of not doing that? Performance? Memory? Memory leaks? Why is this recommended for a Scripting Data Source? Speed?

Thanks.

I have a PHP script that creates JSON for adding data points. Could i run the JSON from command line (in linux)? I could then trigger it from the PHP script.

Currenlty PHP creates the JSON file to the templates folder and I then need to run it from "Templates" by selecting it from the drop down list. Not very convenient...

this actually one problem i also meet? what 's your solve now?

Here is some suggest:
you script below is not right, because .ago will get the least value before 15 miniute,but not get the value at before 15 miniute.
if (p78.ago(MINUTE,15) != 0)
return p78.value - p78.ago(MINUTE,15) ;
else
return 0 ;

the best way is official provide on function to get the exactly time values.

the second way you can try like this,
if ((p78.ago(MINUTE,15) -p78.ago((MINUTE,16))==0),this means you point is interruption

SOLVED!!

I mucked around with this for a few hours and found if I changed all the labelled set points from say 'AUTO' and 'MANUAL' to just true and false it now works, brilliantly!!

Thanks Joel and team for all your assistance!

Although I do still notice nothing in the trace log for the script other than the Data source started line.

Cheers
Dan

Yes, your example is better but the current value of a data point is stored in cache so does not require a database read.

Hi Dan,

Currently the only supported scripting engine is JavaScript. On top of that there are hooks for the Mango functions to get and manipulate point values. This documentation can be found in the meta point properties help dialogue, or here: http://wiki.infiniteautomation.com/doku.php?id=meta_data_properties starting at the 'Scripts' header.

Hi,

How could I create two input boxes in the Graphic view and process a POST using a HTTP sender publisher with the current two values from the Graphic View?. Thanks in advance.

I tried to look into your question briefly to see if there was a function you could call, something like mango.view.initPointDetails() or DataPointDetailsDwr.forcePointRead(dpid, callback func) from a server-side script, but I haven't met obvious success trying that. I doubt those functions prompt the modbus to poll, but I'm not 100% certain.

It's something to experiment with, if you feel so inclined. My intuition is aligned with Joel's, though: this is something that would take code customization to achieve.

Hello!

It looks to me like you might be looking for something like the function call in DataPointEditDwr.java @ line 131. That file can be found https://github.com/infiniteautomation/ma-core-public/blob/21b40809b07fac6c74aa3905a6124e880ea2073b/Core/src/com/serotonin/m2m2/web/dwr/DataPointEditDwr.java for the source code.

The call that may help is,

Common.runtimeManager.purgeDataPointValues(point.getId());

Hope that helps! The alternative is probably to call DataPointEditDwr, and purge it through the tools already available. I have not tested these, yet, though, so let us know if it worked and how!

Matthew, perfect.... you rock!!!

Regards,
Narayana Swamy

Inside the Meta Script Data Source edit page click on the small "?" you will see an explanation there. Here is a excerpt of it:

JavaScript / ECMAScript

This data source requires some knowledge of JavaScript, also known as ECMAScript. (The full specification for ECMAScript is available here.) JavaScript is arguably the most popular scripting language in use today, it being the only language available for use in every popular web browser. The result is that, by far the common usage of JavaScript is in web pages. The context within the Meta data source is of course different, there being no "window" or "document" objects, among other more subtle differences. Contextual differences aside, a full and complete implementation of ECMAScript is available within this data source. Specifically, the Rhino implementation is used https://developer.mozilla.org/en-US/docs/Rhino.

Thank you for answering!

What should I pay attention on? I don't understand.

Hi Eli,

Some BACnet equipment is just very slow at responding. Are you only communicating with one peer? If not you might try parallelizing your requests by wrapping your calls in functions and running them concurrently.

Even if you're only talking to one peer, this might still be possible but some hardware i know of will only service a single request at a time, so it may not help.

it works good.