How to suggest by Matt you can customize your gauge.

<ma-gauge-chart id="4cab95e2-1514-4e14-9edc-4563c92bebf1" style="position: absolute; width: 400px; height: 400px; left: 0px; top: 116px;" point="YOUR_POINT" animate-band-mode="true" arrow-alpha="0" interval="15" value-offset="15" tick-interval="90" tickcolor="#ff0000" band1-color="#ff0000" auto-start="true" auto-end="true" band1-end="90" options="{titles:[{text: 'YourTEXT',size: 15}],axes: [{startAngle: -90, endAngle:90,innerRadius:100}], radius: '105'}" radius="105"></ma-gauge-chart>
You can read the API and this post Gauge styles to realize personalize your gauge.

I hope this helps ;) bye @petermcs

Hi guys, I would need to know in which DB table the events are inserted. I had read a post about it but I can not find it anymore
Thanks in advance

Thanks guys ;)

Hi guys,
Is it possible to query an external web service from a mango page?
I have included a GET and post-AJAX calls on a page.
The chrome console highlights the error "Refused to connect to" http: // localhost: 62224 / api / products' because it violates the following Content Security Policy directive: "connect-src ws: wss: 'self'". "

Thank so much @Jared-Wiltshire and @phildunlap ;)

@phildunlap said in Convert from H2 to mySQL Database guidelines:

You need to have installed a MySQL server for Mango to connect to, and created a database with a properly privileged user, before you can convert your existing H2 database.

You need to have installed a MySQL server for Mango to connect to, and created a database with a properly privileged user, before you can convert your existing H2 database.

@phildunlap for created database do you mean to create an empty database? or do I have to run some script for the generation of the db with mySQL Server?

@jared-wiltshire said in Convert from H2 to mySQL Database guidelines:

${MA_HOME}/overrides/properties I modified this, only that I would need explicit help because I have no idea how to port mysql. I did various tests without results.

Thanks @Jared-Wiltshire

Hello everyone,
I followed the guidelines on this page. But I could not create the mySQL database.
I downloaded "Mango Automation 3.4.3 Free", I started it, I accepted the license and then I closed mango and proceeded to modify the env.properties file.

convert.db.type=mysql
convert.db.url=${ma.home}/databases/mySQLMango
convert.db.username=admin
convert.db.password=admin

When I restart mango, the page loading stops and a H2 db is generated even though I had deleted it before starting the application

Could you explain the procedure step by step?
Thanks in advance

I linked an external database I did Statement test with a simple select * from my table query and I managed to get the result set. So, I tried to create a datapoint because I imagined that they could be used to derive data through a sql script. As far as I could understand, can only insert and update?
Thanks in advance for the support

Try setting CSS height and fixed width.
If you have already done so you probably have not set the parameters well.
I suggest you go to the examples -> Chart -> Advanced Chart section and visit API Documentation for <ma-serial-chart> & <ma-point-values>.
Ciao a presto ;)

@Jared-Wiltshire
Its pretty easy to enable/disable data points from a dashboard using a point's enable() method. And yes you can also enable/disable data points or data sources from a script. However I'm not sure this is necessary, I would probably just leave the data points logging continuously.

What's wrong?
Would you give me an example of how to recall classes and methods for working with datasoruce and datapoint and extracting the fields?
I do not know the Java architecture you have implemented ...

Tag each data point with a set of tags to uniquely identify the machine.

It is possible to set "tags{}" field ?
Eg. tags:{"nameProduct" : "productAlpha" , "id": "164", xid": "DP_RomeElettricoScrPotenza","name":"RomeElettricoScrPotenza"}

Thanks in advance