EcoStruxure Geo SCADA Expert Forum
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Link copied. Please paste this link to share this article on your social media post.
Posted: 2021-07-13 05:07 AM . Last Modified: 2023-05-03 12:02 AM
Is there a way to automatically fill custom fields with the result of an expression or SQL-query?
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2021-07-13 05:53 AM
Fields added to tables using Metadata do not have default values.
SQL can modify these fields, but you will need to trigger that from your application (e.g. on mimic, in Logic or in ODBC).
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2021-07-16 08:38 PM
Depending on what you're actually using the Custom Field for.. do you need to use it?
If you just want to display a value to an operator, then you could just use an animation to display this value.
If you want to store a value dynamically, then Logic might be the best approach. You could trigger it either periodically, or based on some event that you know of (i.e. a mimic script, or tag change or similar).
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.