The events table holds most of the information about an event, which some information about if a user has silenced it in the userEvents table. To delete all past event / alarm information one would purge these two tables (audit events are in the audit table)

Good to know thanks Jared.

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

Hi pierjsap,

I too am somewhat confused. It sounds like you're asking if the SQL data source can read data? The answer is yes, it can store data from the data source's select statement or it can be configured only to update the table (which it must be if you wish to set the point to some dynamic value in the update statement, a point that isn't "Modify Table Only" will only have a constant update statement), You either have to match the 'Column name' property of the point to the column names returned, or do a "row based query" and have the column name match the value in the first column of the results, then its value in the second column.

There are a few examples scattered around the forum. If you can say more, perhaps I can recall a relevant thread for you.

@pierjsap said in How to managed data on DB and query by ma-point-query:

What's wrong?

I specified "from a dashboard", you are trying to use the function in a server side script. These are two different environments.

@pierjsap said in How to managed data on DB and query by ma-point-query:

Would you give me an example of how to recall classes and methods for working with datasoruce and datapoint and extracting the fields?

I was not suggesting to tag data points from within a script, in fact I would advise against this. I was suggesting to setup all your data sources for the sensors and possibly meta data sources as required then tagging these through the bulk data point editor in the UI. You can these use these tags from your dashboards to locate the applicable data points for the machine you are viewing.

Glad to hear you got it working!

The Set Point URL you have configured seems a little odd to me. The set point url is where to reach out to with a message if one of the HTTP points is set. So, if you have it pointed at the local httpds, you may be setting those values into other HTTP (or the same) point. Not sure what the objective is.

Hi pierjsap,

The ASCII file reader uses regex to parse values by line of the input.

There is good information in context help for the data file data source as to how to use it. That's the blue question mark by the data source name while you are editing it.

In brief, you have to implement a Java class that extends the abstract importer you wish to use. These threads have examples:
https://forum.infiniteautomation.com/topic/1636/problem-with-defining-class-for-csv-datafile-import
https://forum.infiniteautomation.com/topic/3126/file-datasource-breaks-on-file-upload

We can work through the CSV you need to import in this thread, if you'd like.

Another option that has come up in the past is reading the CSV from a scripting data source, as in this thread: https://forum.infiniteautomation.com/topic/2970/is-it-possible-to-read-several-csv-documents-by-scripting

@CraigWeb problem solved i hope that this could help you.

<button onclick="goBack()">Go Back</button> <script> function goBack() { window.history.back(); } </script>

@pierjsap said in Admin Template ma-map:

Hi guys, I tried to add the ma-map element to the home.html file of the admin template. But this is not displayed unlike the gauges. I added the Google API Key and within the dashboard designer it works correctly. Could you give me some indication?

I would highly recommend just using a full screen page (i.e. no menu/toolbar) inside the UI app instead of trying to use the admin template.

I suspect if you check your console you will find errors due to a missing maUiSettings service. The <ma-map> component will not work outside of the UI app. You can however use the plain <ng-map> directive, see the documentation here - https://ngmap.github.io/

@pierjsap
Please do share your solution as I can see this logic being very useful. I think my method would be to duplicate your event sent points and logic in the meta data point script. Then use the if statement that your proposed to set the meta point. Keep the event detectors so that your event page will still list the events.

thanks @phildunlap ;)

Hi @Jared-Wiltshire ,

I developed a similar thing using the admin template.
As soon as I have 2 minutes I send screenshots so that other users can benefit from it.
Thank you very much for the help you gave me.