Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
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.
Send Invite Cancel
84647members
353988posts

User Tables

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
DavidSkilbeck
Lt. Commander
Lt. Commander
0 Likes
1
930

User Tables

Hi,

I have had to use tables in a Geo SCADA project to display data.

 

Using Registries I can use and display values associated with the current user.

Is there any thing I can do similar with tables?

So I can display data that is associated with the current user.

 

I don't think there is a way to instantiate a table in Geo SCADA to be user specific.

 

Also, I don't think there is a way to write to registries using the automation interface.

I guess I can write to a point or a table. Then write the value(s) of the point or table to registries.

 

There may be a better way?

 

Thanks,


Accepted Solutions
BevanWeiss
Spock
Spock
0 Likes
0
918

Re: User Tables

This will probably be easier if you tell us what the actual goal is here.  Without how you think you could implement it.

I'll try to throw out some info tied to each of the keywords you've mentioned, but I'm not really seeing the associations between them... so my understanding of your enquiry would be enhanced by you providing context.

 

DataTables / DataGrids / DataSets are Database specific, not at all natively related to users, and not really Templateable either (they can technically be in a template, but they need unique names, so instantiating the templates is a bit less effective... DataSetRows are different here, and are ideal for Templates)

The SQL Query engine itself tends to not be user specific (i.e. I don't even think that it's possible to find what user a query is running under).

 

You can write to the Registry using Scripting (GetRegistry, SetRegistry).

If you are using the Automation Interface, then you also have access to COM functionality (external to GeoSCADA code) and you can read/write directly to the computer Registry (which prior to GeoSCADA contained the ViewX REGISTRY stuff... after GeoSCADA this REGISTRY stuff is now stored in the GeoSCADA Database... so you'd need to use the ViewX Scripting / Animation Expressions to retrieve it).

 

I don't recall seeing any REGISTRY access type stuff in the Automation Interface (or the .NET API), so you might need to submit feature requests for this functionality if you think that you need it for your use case.


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..

See Answer In Context

1 Reply 1
BevanWeiss
Spock
Spock
0 Likes
0
919

Re: User Tables

This will probably be easier if you tell us what the actual goal is here.  Without how you think you could implement it.

I'll try to throw out some info tied to each of the keywords you've mentioned, but I'm not really seeing the associations between them... so my understanding of your enquiry would be enhanced by you providing context.

 

DataTables / DataGrids / DataSets are Database specific, not at all natively related to users, and not really Templateable either (they can technically be in a template, but they need unique names, so instantiating the templates is a bit less effective... DataSetRows are different here, and are ideal for Templates)

The SQL Query engine itself tends to not be user specific (i.e. I don't even think that it's possible to find what user a query is running under).

 

You can write to the Registry using Scripting (GetRegistry, SetRegistry).

If you are using the Automation Interface, then you also have access to COM functionality (external to GeoSCADA code) and you can read/write directly to the computer Registry (which prior to GeoSCADA contained the ViewX REGISTRY stuff... after GeoSCADA this REGISTRY stuff is now stored in the GeoSCADA Database... so you'd need to use the ViewX Scripting / Animation Expressions to retrieve it).

 

I don't recall seeing any REGISTRY access type stuff in the Automation Interface (or the .NET API), so you might need to submit feature requests for this functionality if you think that you need it for your use case.


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..