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.

Update, I ran the 24 hour report a few times using different loggers and different users. They were all coming up with data from the end of Jan 2016 and the beginning of Feb 2016. I edited the Excel spreadsheet, removed the good data, left in the old data, set the annotation to delete and imported the spreadsheet back into Mango. I then re-ran the reports. I had to do that a couple of times but it seems to have cleared the old data. The next few reports did not have the old data. Problem solved for now. Cheers Brian

I'm sorry this answer isn't more specific but I'm pretty sure you will find the answer to your questions in the videos in this section: http://infiniteautomation.com/forum/category/16/dglux-graphic-dashboards The way to display a value that doesn't exceed a limit is to first bind the value to a script and write a script to limit the value. Use the output of the script to bind to your gauge.

I totally agree Pedro and I plan to it to the wiki as soon as I can. I also plan to have one for PHP as well. If anyone out there would like to share a PHP version please feel free contribute to this thread. Thanks

Hi Phil, There are no report instances that we wish to save, they go out by e-mail and that is the end of them so for the time being i will have to remember to wipe the databases/reports directory every month. It seems you have already identified a fix in the github issue so hopefully it gets some attention for a release in the next couple months. thanks both for your time and assistance

It is done by the built-in process, done in the upgrade shell script. Also, that doesn't feel to me like an error that would be caused by a stale JSP. Jfree charts renders everything on the server and returns only an image, and look how nestled the call stack is into the JFree code. I don't rule it out, though.

I have sent you an email, let's conduct the rest there and I'll post anything insightful at the end if there is something to share.

Hi Brian, This was caused by a developer created a dependency on 1.1.3 of the dashboards module. Since that is now in the store, they will work together, and provides the possibility to define angular components in the graphical views module.

Hi Brian, I wonder, would giving your SQL column a ridiculous default value, say, -1000000 and discarding extreme values be an option?

In DGLux 2.5, I do not believe so. I don't think there is an event propagation model like in HTML, so there is no way built in to catch all keypresses by a single object.... but then, for almost all objects except explicit inputs it is not possible to catch any keypresses. So, there's the hack-it-together solution: use an input with a change trigger that invokes a script. The Script would read the text input and perform any behaviors necessary then set the input back to blank if it wasn't already. You wouldn't be able to use the arrow keys, since they probably don't have a value to the input field, but you could use WADS, the num pad or something.

Yep, I was referring to OS updates. Makes sense.

Okay, the no update event notification is working. I did have to increase the no update duration to be longer than the mango persistent tcp history synchronization interval. As far as the custom email templates, I would rather wait until it's implemented by you guys. Thanks for the help.

Thanks joel, it did help. :)

Hi edmond, can you post your select statement from your SQL data source? What datatype of sql column is your datetime?

Hello Phil, I just wanted to thank you. The point links worked great once I understood how to use them and the scripting. This is how I did it in case anyone else wants to know: I have an SQL data source that needs to be read when the data comes in, not on a set interval and I need to use the data's own timestamp. My data source uses this select statement: SELECT * FROM staging_all where logger_id=1 and flag=0 order by date asc limit 1; To trigger the reading of each row I set up a point link as follows: I have a source data point that is set a a virtual sinusoidal that is going between -1 and +1 every 10 seconds. I have a target data point set up as a modify table only point. The point link uses the following one line script: if (source.value >0) return '(1)'; return '(0)'; I needed this line because the target data point was an alphanumeric data point. My target point has this script: UPDATE staging_all SET flag=? WHERE logger_id=1 AND flag=0 ORDER BY date ASC LIMIT 1; Now the data point that modifies the staging table gets a trigger (1) several times a minute and that causes my data rows to be read one at a time until they are all marked as (1). Thank you for pointing me in the right direction.

Thank you very much. Cheers Brian

We are working to replace the JFreeCharts with the new AmCharts found in the DataPointDetails module. The new charts use new methodology to generate the data which include 'rollups'. Rollups allow you to request data placed into bins. So for example you could request the past 24hrs worth of data averaged at 10 minute intervals.

Correct

Thanks. In that case, let's hope that next time I restart, deleting the __MACOSX/ directory fixed things.

Thanks for clarifying this in the Wiki. Since /bin/ext-enabled is not under /overrides, it is not obvious that it would survive upgrades.