Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT Forum
    • Sign In
    • All tags
    • SQL
    • <<depth>>
    • AGS4
    • Azure
    • correspondence file
    • count
    • expression
    • gINT
    • gINT Queries
    • Graph
    • graphic table
    • Key Set
    • Lead
    • legend
    • Log
    • output
    • output condition
    • piezometer
    • Queries
    • Report Design
    • SqlList
    • SqlRange
    • tab
    • tabs
    • text vs. depth
    • water
    • Date SQL Query Not Working

      Miles
      Miles
      Hi all, Phil Wade helped me with the SQL for this query the other week and it worked fin, until now! It goes like this:- A non-SI based gINT setup for concrete cube testing. Data about each cube is stored in the CUBEDATA table, including Date created…
      • over 9 years ago
      • OpenGround | gINT | Keynetix
      • gINT Forum
    • Re: Average of Recovery lengths

      Dave Kyllonen
      Dave Kyllonen
      Here are two expressions that will work on Log reports and Fence reports. Average Depth: <<Sql(_ SELECT AVG([SAMPLE].[Depth]) _ From [SAMPLE] _ Where [SAMPLE].[PointID] = '<<PointID>>' _ And [SAMPLE].[Group ID] = <<SAMPLE.Group ID>>; _ 0.000_ )…
      • over 11 years ago
      • OpenGround | gINT | Keynetix
      • gINT Forum
    • Re: More than one Foreign PointID Expression

      Pat Cummings
      Pat Cummings
      "...I’d like to show CPT and lab test results [for] up to seven associated points for one borehole..." So in that case, you will probably need a loop from 1 to the count of the associated points to establish a single value for the list item position…
      • over 10 years ago
      • OpenGround | gINT | Keynetix
      • gINT Forum
    • Re: "Simple Text"

      Pat Cummings
      Pat Cummings
      You may need an SQL query to collect information from multiple tables, since you are already using the <<PointID>> keyfield in your expression without success. gINT Help has a lot of examples and description of SQL usage under several topic headings…
      • over 12 years ago
      • OpenGround | gINT | Keynetix
      • gINT Forum
    • Re: Show geological layer name for test results on graph report

      Pat Cummings
      Pat Cummings
      Rob, it sounds like you want to know what layer stored in GEOL matches the depth of the lab sample from LAB SPECIMEN. This is very similar to Help Example 2 in the SqlRange function topic, where we look for the USCS code that matches a field sample depth…
      • over 11 years ago
      • OpenGround | gINT | Keynetix
      • gINT Forum
    • Re: Show geological layer name for test results on graph report

      jason@geolabs.net
      jason@geolabs.net
      I also have the same problem. I have a graphic table with various results (Blow Counts, PI, Su, etc.) and would also like to display the geologic origin and USCS code in the sample table. I used the SqlRange function and followed example 2 from the help…
      • over 11 years ago
      • OpenGround | gINT | Keynetix
      • gINT Forum
    • View related content throughout OpenGround | gINT | Keynetix
    • 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