Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
OpenFlows | Water Infrastructure
OpenFlows | Water Infrastructure Wiki
OpenFlows | Water infrastructure Wiki
Sign In
All tags
SQL
WaterGEMS
CivilStorm
Duplicate
Filter
filtering
FlexTables
GE Proficy Historian
HAMMER
IN Operator
LIKE operator
Migrated
ModelBuilder
Queries
query
Real-time
Reviewed2016
reviewed2017
Reviewed2018
Reviewed2020
SCADAConnect
SewerCAD
SewerGEMS
signals
StormCAD
WaterCAD
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
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
View related content throughout OpenFlows | Water Infrastructure
More
Cancel