Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenFlows | Water Infrastructure
  • 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
      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
      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
      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
      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
      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
      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
      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
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies