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: 2020-09-24 05:33 AM . Last Modified: 2023-05-03 12:10 AM
I am trying to execute a query using the IQuery interface (ClearScada.Client.Advanced.IQuery). I can see using the Visual Studio object browser that the IQuerySource interface provides a method to do this:
IQuery PrepareQuery(string query, QueryParseParameters parameters);
However this is not a static method and so I need to find the method that returns an IQuerySource object and I have searched high and low but cannot find one.
Does anyone have any ideas?
@sbeadle do you have an examples to share of querying the Geo SCADA Expert DB using the Geo SCADA Expert Client API?
I know how to do this using ODBC but I want to understand and use the Geo SCADA Expert Client API.
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-24 09:20 AM
Not to worry, having thought a little harder and dug a little deeper it seemed obvious that the interface must be implemented by the server node or server itself. The IServer interface implements the IQuerySource interface and so the server interface object obtained from the ServerNode.Connect method exposes the PrepareQuery method, got it? Thanks for looking anyway (o:
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-24 09:20 AM
Not to worry, having thought a little harder and dug a little deeper it seemed obvious that the interface must be implemented by the server node or server itself. The IServer interface implements the IQuerySource interface and so the server interface object obtained from the ServerNode.Connect method exposes the PrepareQuery method, got it? Thanks for looking anyway (o:
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-25 08:05 AM . Last Modified: 2022-10-19 02:07 AM
There's an example here:
https://community.se.com/t5/Geo-SCADA-Expert-Forum/NET-API-to-query-ClearSCADA-View/m-p/200560
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.