Sign In Help
Schneider Electric
HelpLogin / Register

Invite a Co-worker

Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel

Invitation Sent

Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
  • Home
  • Communities
  • :
  • SCADA & Telemetry Solutions
  • :
  • Geo SCADA Expert Forum
  • :
  • Custom Inherited Fields
Community Menu
  • Forums
    • By Topic
        • EcoStruxure Building
          • Field Devices Forum
        • EcoStruxure Power & Grid
          • Metering & Power Quality
        • EcoStruxure IT
          • EcoStruxure IT forum
        • Industrial Automation
          • Industry Automation and Control Forum
          • Alliance System Integrators Forum
          • Machine Solutions in the Digital Transformation
          • EcoStruxure Automation Expert / IEC 61499 Forum
          • Industrial Edge Computing Forum
          • Level and Pressure Instrumentation Forum
          • Modicon User Group
          • PLC Club Indonesia
          • SEE Automation Club Forum
          • Fabrika ve Makina Otomasyonu Çözümleri
          • Форум по промышленной автоматизации СНГ
          • Motorabgangstechnik & Antriebstechnik Forum
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Forum
          • SCADA and Telemetry Devices Forum
        • Power Distribution IEC
          • Power Distribution and Digital
          • Power Standards & Regulations
          • Solutions for Motor Management
          • Paneelbouw & Energie Distributie
          • Eldistribution & Fastighetsautomation
          • Elektrik Tasarım Dağıtım ve Uygulama Çözümleri
        • Power Distribution NEMA
          • US Utility Forum
        • Power Distribution Softwares
          • EcoStruxure Power Design Forum
          • LayoutFAST User Group Forum
        • Wireless Information Network Solutions
          • Instrument Area Network
          • Remote Monitoring
          • Tank Level Monitoring
          • Remote Data Collection
        • Solutions for your Business
          • Solutions for Food & Beverage Forum
          • Solutions for Healthcare Forum
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Forum
        • Healthcare
          • Solutions for Healthcare Forum
      • EcoStruxure Building
        • Field Devices Forum
      • EcoStruxure Power & Grid
        • Metering & Power Quality
      • EcoStruxure IT
        • EcoStruxure IT forum
      • Industrial Automation
        • Industry Automation and Control Forum
        • Alliance System Integrators Forum
        • Machine Solutions in the Digital Transformation
        • EcoStruxure Automation Expert / IEC 61499 Forum
        • Industrial Edge Computing Forum
        • Level and Pressure Instrumentation Forum
        • Modicon User Group
        • PLC Club Indonesia
        • SEE Automation Club Forum
        • Fabrika ve Makina Otomasyonu Çözümleri
        • Форум по промышленной автоматизации СНГ
        • Motorabgangstechnik & Antriebstechnik Forum
      • SCADA & Telemetry Solutions
        • Geo SCADA Expert Forum
        • SCADA and Telemetry Devices Forum
      • Power Distribution IEC
        • Power Distribution and Digital
        • Power Standards & Regulations
        • Solutions for Motor Management
        • Paneelbouw & Energie Distributie
        • Eldistribution & Fastighetsautomation
        • Elektrik Tasarım Dağıtım ve Uygulama Çözümleri
      • Power Distribution NEMA
        • US Utility Forum
      • Power Distribution Softwares
        • EcoStruxure Power Design Forum
        • LayoutFAST User Group Forum
      • Wireless Information Network Solutions
        • Instrument Area Network
        • Remote Monitoring
        • Tank Level Monitoring
        • Remote Data Collection
      • Solutions for your Business
        • Solutions for Food & Beverage Forum
        • Solutions for Healthcare Forum
      • Food & Beverage
        • Solutions for Food & Beverage Forum
      • Healthcare
        • Solutions for Healthcare Forum
  • Blogs
    • By Topic
        • EcoStruxure Power & Grid
          • Backstage Access Resources
        • Industrial Automation
          • Industry 4.0 Blog
          • Industrie du Futur France
        • SCADA & Telemetry Solutions
          • SCADA and Telemetry Blog
        • Power Distribution IEC
          • Power Events & Webinars
          • Power Foundations Blog
          • UK&I Residential and Commercial Electrical Distribution
        • Power Distribution NEMA
          • NEMA Power Foundations Blog
        • Power Distribution Softwares
          • EcoStruxure Power Design Blog
        • Solutions for your Business
          • Solutions for Food & Beverage Blog
          • Solutions for Healthcare Blog
          • Solutions for Retail Blog
          • Solutions for eMobility
          • Digital Hospital Solutions – UK&I
        • Knowledge Center
          • Industrial Automation How-to videos
          • Digital E-books
          • Success Stories Corner
        • Community experts & publishers
          • Publishers Community
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Blog
        • Healthcare
          • Solutions for Healthcare Blog
        • Retail
          • Solutions for Retail Blog
        • Retail
          • Solutions for eMobility
        • Retail
          • Digital Hospital Solutions – UK&I
      • EcoStruxure Power & Grid
        • Backstage Access Resources
      • Industrial Automation
        • Industry 4.0 Blog
        • Industrie du Futur France
      • SCADA & Telemetry Solutions
        • SCADA and Telemetry Blog
      • Power Distribution IEC
        • Power Events & Webinars
        • Power Foundations Blog
        • UK&I Residential and Commercial Electrical Distribution
      • Power Distribution NEMA
        • NEMA Power Foundations Blog
      • Power Distribution Softwares
        • EcoStruxure Power Design Blog
      • Solutions for your Business
        • Solutions for Food & Beverage Blog
        • Solutions for Healthcare Blog
        • Solutions for Retail Blog
        • Solutions for eMobility
        • Digital Hospital Solutions – UK&I
      • Knowledge Center
        • Industrial Automation How-to videos
        • Digital E-books
        • Success Stories Corner
      • Community experts & publishers
        • Publishers Community
      • Food & Beverage
        • Solutions for Food & Beverage Blog
      • Healthcare
        • Solutions for Healthcare Blog
      • Retail
        • Solutions for Retail Blog
      • Retail
        • Solutions for eMobility
      • Retail
        • Digital Hospital Solutions – UK&I
  • Ideas
        • Industrial Automation
          • Modicon Ideas & new features
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Ideas
          • SCADA and Telemetry Devices Ideas
  • Knowledge Center
    • Building Automation Knowledge Base
    • Industrial Automation Knowledge Base
    • Industrial Automation How-to videos
    • SCADA & Telemetry Solutions Knowledge Base
    • Digital E-books
    • Success Stories Corner
    • Power Talks
  • Events & Webinars
    • Innovation Talks
    • Innovation Summit
    • Let's Exchange Series
    • Technology Partners
  • Support
    • Ask Exchange
    • Leaderboard
    • Our Community Guidelines
    • Community User Guide
    • How-To & Best Practices
    • More
Join Now
How can we help?
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
52704members
Join Now
247940posts
Join Now

Custom Inherited Fields

Options
  • Subscribe to RSS Feed
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Back to Geo SCADA Expert Forum
tfranklin
Lieutenant tfranklin
Lieutenant
‎2020-06-20 07:51 AM
0 Likes
3
611
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-06-20 07:51 AM

Custom Inherited Fields

I was playing around with Geo SCADA today and trying to figure out a good way to create inherited fields such as default view link/alarm view link, but there doesn't appear to be a good way to do it.  Has anybody implemented something like this in the past?

 

My use case here is to create something like an area of interest, but at a group level instead of a point level and where it would also inherit from parent if not explicitly configured on a point.  Regions could potentially be used here, but the issue is that things in these "groups" might not always fall into the explicit geographic region.  I kicked around the idea of just setting a fake location that falls into a region, but if there ever was a case for configuring lat/long down the road then this would no longer be valid or apply. 

 

What would be ideal is if AOI could be configured at a group level, but it doesn't appear to be possible.  I'm debating creating a link/reference field and creating some logic to populate this nightly, but wasn't sure if there was another way or something that I'm missing. 

 

Side-note and unrelated -- there should be a label for Metadata when submitting a forum post. 

Labels
  • ViewX
Tags (2)
  • Tags:
  • english
  • metadata
Share
Reply
  • All forum topics
  • Previous Topic
  • Next Topic
3 Replies 3
BevanWeiss
Sisko BevanWeiss
Sisko
‎2020-06-20 08:48 PM
0 Likes
2
603
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-06-20 08:48 PM

Re: Custom Inherited Fields

My understanding is that AOI only really applies to an Alarm Instance (normally based upon the configured Alarm AOI, but redirections can change this too I think).

There's not many ways I can think of doing this really.

1) via SQL.  If you have a Metadata field configured with a 'null' value defined (easy for Object References, tricky for things like integers), then you could sort by the LEN of the FullName, and have the query like:
   SELECT TOP(1) FullName, MyField
   FROM CDBObject
   WHERE MyMetaField <> {NULL} AND {MyObjectFullName} LIKE FullName || '.%'

   ORDER BY LEN(FullName) DESC

2 Via calculation point, but you'd be limited to only having a group level reference (which would contain the Calculation point)..

   IIF(".MetadataField" <> {NULL}, ".MetadataField", "..MetadataFieldCalc")

   and this would need to be in EVERY group... so it seems horrible

 

 

It might be worth raising a feature request for what you're after.  Although it does seem quite niche.

I try to avoid using AOI.  It always seems to be a real maintenance nightmare compared to the relatively small benefits that it provides.  Better in recent versions where imports don't SPAM the AOI list with hundreds of foreign language entries... but such erroneous entries still seem to find their way into the databases.

 

(apparently trying to add a tag automatically posts the message... this forum software is painful)

 


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
Tags (2)
  • Tags:
  • english
  • metadata
Share
Reply
sbeadle
Sisko sbeadle Sisko
Sisko
‎2020-06-23 01:32 AM
0 Likes
1
586
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-06-23 01:32 AM

Re: Custom Inherited Fields

Thanks guys. Thinking aloud, what about a Metadata field which has an expression to set its value. So you have one metadata field which has an optional value, such as "SetProperty", and another based on an expression "SetPropertyInherit" which reads its value or the parent value if blank if(".SetProperty"='',"..SetProperty",".SetProperty")

 

You could implement as a string variable/constant now, and use a single Logic program on a daily/scheduled basis to modify it as config changes (take care only to write new values if changed).

Tags (1)
  • Tags:
  • english
Share
Reply
tfranklin
Lieutenant tfranklin
Lieutenant
‎2020-06-23 10:02 AM
0 Likes
0
580
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-06-23 10:02 AM

Re: Custom Inherited Fields

It sounds like what I'm asking for is not something OOB, which I kind of assumed.  I don't think this feature would be a niche feature at all though.  For the purpose of this thread, it's a topic regarding creating a "group" type field that is pushed down to all children who inherit from parent, similar to default view.  However, I think the use cases for this could be rather large if it were a configurable metadata type that could be added.

 

I think the route I'll end up going here is to create a search key metadata field instead.  This seems simple enough to implement with a logic program that runs periodically. 

 

For the purpose of this thread topic specifically, I think expressions as they work today would be more work than it's worth  I would probably go this route if it was easier to set the properties on groups throughout the system.  Right now I don't believe there's a method to do this via script (please let me know if I'm just missing it!).  I haven't looked into the API yet to see if it's possible there (I'm sure it is). 

 

Stop reading here if you only care about the thread and not my feature requests! lol

 

I think template expressions in general leave a bit to be desired.  I've raised my desires about this with support before.  Early on my assumption was that I could configure the expressions to reference properties or objects relative to the template that you set them in, but that's just not the case. I believe right now the only properties you can assume from the template level are name, fullname, and parent.  Being able to create an expression at the template level for these would allow for a lot of automatic configuration of objects and properties. 

 

An example would be to set the alarm source for points to relatively reference certain attributes within the template level.

"..Name" + ' << ' + "Name" + ' >> ' "..objCommDeviceName"

 

Example 2:  Imagine a scenario where you have a station grouped up as such:
Device

  Run 1

    GQ

  Run 2

    GQ

  Station

  Valve XYZ

 

By setting RTU level specific properties at the device level, there would be no need to try and figure out how many parent folders you need to jump to in order to access properties from the Device folder.  These would be auto-magically pushed down and accessible using something like ".PropertyName".  Whether by inheritance or expressions, you could make this much simpler and take the guess work out.  Expressions could be set at the template and no further configuration would be required.  If you had inherited properties rather than expressions, it would have the same affect and depending on the class could be an accessible attribute on the objects themselves.  The result would be if I query a point, I can get the device level properties in the same query without the need to jump through parentgroupid->parentgroupid->______. 

 

I guess I'm envisioning something like dynamic bindings rather than something that has to be explicitly defined per object. 

Tags (1)
  • Tags:
  • english
Share
Reply
Related Products
Schneider Electric
EcoStruxure™ Geo SCADA Expert
Top Experts
User Count
sbeadle
Sisko sbeadle Sisko
188
BevanWeiss
Sisko BevanWeiss
56
AndrewScott
Lt. Commander AndrewScott
17
AdamWoodland
Commander AdamWoodland Commander
17
JChamberlain
Lt. Commander JChamberlain Lt. Commander
16
geoffpatton
Lt. Commander geoffpatton
10
See More Top Experts
Find a Service Provider
Find a certified partner to help you address your integration, installation, maintenance and project needs.
View all Providers
Support

Have a question? Please contact us with details, and we will respond.

Contact Us
FAQ

Look through existing questions to find popular answers.

Learn More
About

Want to know more about Exchange and its possibilities?

Learn More

Full access is just steps away!

Join Exchange for FREE and get unlimited access to our global community of experts.

Connect with Peers & Experts

Discuss challenges in energy and automation with 30,000+ experts and peers.

Get Support in Our Knowledge Base

Find answers in 10,000+ support articles to help solve your product and business challenges.

Ask Questions. Give Solutions

Find peer based solutions to your questions. Provide answers for fellow community members!

Register today for FREE

Register Now

Already have an account?Log in

About Us FAQ Terms & Conditions Privacy Notice Change your cookie settings
©2021, Schneider Electric