Welcome to the new Schneider Electric Community

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

Close
Important Announcement: WELCOME to the new Schneider Electric Community! Community is now no longer part of Exchange, and is now rebranded under se.com. If you have any bookmarks and links saved, we request you to update them to ensure that you continue accessing our community from this new location. For any issues that you might encounter as part of this change, please reach out to SchneiderCommunity.Support@se.com, and the team will help to get your issues resolved.
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
82536members
350141posts

Read Data Table externally

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
599

Read Data Table externally

Hi,

I have a data table I have created in GeoSCADA, which has a number of fields, one of the fields is called originatorID.

The table is an object, so is it accessible via SQL (external using SOAP)?.

Can I access the fields content.

Below is a snippet from code used to read from the CDBPoint table externally.

 

I would like to read from the table top fields as to points.

I have tried, but I am not sure where to look in help files.

Do I need to go about it an entirely different way (different type of table, list) or is it a case of a certain SQL statement.

 

Select CurrentValueFormatted, FullName from CDBPoint where FullName='PoC.Web Service.Work Order.Machine 1.Request.reference'", obj, out limit

 

Thanks,

Tags (1)

Accepted Solutions
BevanWeiss
Spock
Spock
0 Likes
0
595

Re: Read Data Table externally

When you defined the properties of your table, one of them was TableName.

 

If you write your SQL query like:

SELECT OriginatorId
FROM {TableName}
WHERE OriginatorId > 120

 

Then it should provide you a query result set of all rows within your data table that have the OriginatorID field greater than 120.

 

If you go to the DB Schema, and show all entries, then normally your custom Data Tables will also show up in this view (Typically towards the bottom since they will have starting characters greater than 'C'.. and most ClearSCADA / Geo SCADA 'tables' start with C).

 

You can also access the DataTable using the object model (not the query model), but it's less convenient typically, since you are then restricted to the method calls that DataTable objects have.


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

Tags (1)
1 Reply 1
BevanWeiss
Spock
Spock
0 Likes
0
596

Re: Read Data Table externally

When you defined the properties of your table, one of them was TableName.

 

If you write your SQL query like:

SELECT OriginatorId
FROM {TableName}
WHERE OriginatorId > 120

 

Then it should provide you a query result set of all rows within your data table that have the OriginatorID field greater than 120.

 

If you go to the DB Schema, and show all entries, then normally your custom Data Tables will also show up in this view (Typically towards the bottom since they will have starting characters greater than 'C'.. and most ClearSCADA / Geo SCADA 'tables' start with C).

 

You can also access the DataTable using the object model (not the query model), but it's less convenient typically, since you are then restricted to the method calls that DataTable objects have.


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 (1)