Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
OpenFlows | Water Infrastructure
Sign In
All tags
SQL
CivilStorm
Duplicate
Filter
filtering
GE Proficy Historian
HAMMER
Historian
IN Operator
LIKE operator
Migrated
ModelBuilder
Queries
query
Real-time
Reviewed2016
reviewed2017
Reviewed2018
SCADA
SCADAConnect
SewerCAD
SewerGEMS
StormCAD
WaterCAD
WaterGEMS
WHERE
Using the IN operator to query for elements in a set list of criteria
Scott Kampa
Product(s): WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm Version(s): CONNECT Edition Area: Modeling Problem How can I select elements in a query that meet a specific list of criteria, for example…
over 2 years ago
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Wiki
ScadaConnect SQL tag read fails
Andreu Fargas
I have an issue reading data from an SQL database. It is configured and working, but sometimes is not showing the data existing in the database. I go to the SCADA Signals, and try to access to the Historical data of a Tag. In my case, it works OKup…
over 3 years ago
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Forum
Watergems ScadaConnect Database connection fails
Andreu Fargas
Is there a specific configuration of the database date format? I've seen that Live and Historical connections read the date differently. And I have sometimes errors saying that it cannot transalate the date format. Could it be a Languange configuration…
over 3 years ago
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Forum
How to define real-time custom queries in SCADAConnect
Yashodhan Joshi
Product(s): WaterGEMS, WaterCAD, SewerGEMS Version(s): 10.00.00.50 and later (Water), 10.01.00.70 and later (SewerGEMS) Area: Modeling Original Author: Wayne Hartell, Principle Software Engineer, Bentley Systems Background…
over 4 years ago
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Wiki
Using the WHERE clause and Duplicate option in ModelBuilder to filter imported data
Jesse Dringoli
Applies To Product(s): WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm Version(s): V8i, CONNECT Edition Area: Layout and Data Input Original Author: Scott Kampa, Bentley Technical…
over 1 year ago
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Wiki
Using the LIKE and IN Operators with queries to filter on text fields such as label
Scott Kampa
Applies To Product(s): WaterGEMS, WaterCAD, HAMMER, SewerCAD, SewerGEMS, StormCAD, CivilStorm Version(s): CONNECT Edition, 08.11.05.XX+ Area: Modeling Problem How can I perform advanced SQL queries in the…
over 2 years ago
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Wiki
SCADA Signal SQL Error
Stephen Jackson
I am using WaterGEMS SELECTSeries 6, build 08.11.06.113 32-bit. I am attempting to set up a SCADA Signal connection to a GE Proficy Historian database. The connection has been successfully established, and by following the instructions in the article…
Answered
over 7 years ago
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Forum
View related content from anywhere
More
Cancel