Ask our Experts
Didn't find what you are looking for? Ask our experts!
Launch of Consumer/Home Owner registration process! We are pleased to announce the commencement of the Consumer/Home Owner Registration Process on Community. Consumers/Home Owners may now proceed to register by clicking on Login/Register. The process is straightforward and designed to be completed in just a few steps.
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Search in
Link copied. Please paste this link to share this article on your social media post.
Posted: 2020-09-14 05:18 PM . Last Modified: 2023-05-03 12:10 AM
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,
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: 2020-09-14 05:29 PM
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.
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: 2020-09-14 05:29 PM
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.
Link copied. Please paste this link to share this article on your social media post.
You’ve reached the end of your document
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.