• Text Tables: Statistics For a Non Key Field

    Jason Varounis
    Jason Varounis
    Within the LITHOLOGY table, there is a field .Stratum where each row in LITHOLOGY can be assigned a .Stratum integer 1-9. Suppose they are not necessarily in depth order (interlayered) and several LITHOLOGY rows within a POINT might be assigned the same…
    • Answered
    • over 1 year ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • dbo.WH_TableProperties and dob.WH_ColumnProperties

    James Elvy
    James Elvy
    Hello all, Does anyone have a data dictionary for these tables (gINT CONNECT 10.00.00.69 (gINT Professional Plus) & MS SQL Server 2017 Express) which are created on the SQL database when upsizing a gINT project to an enterprise database? Some fields…
    • over 4 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • gINT: Use NextDepth function inside SQL

    Ratna Yesuraj
    Ratna Yesuraj
    Hi All, For a project, I need to get the difference between current depth and the next depth in SQL. I've tried the following code at it fails. I also tried SQL LEAD and it seems it's not supported by gINT. Any idea how to get both current and next…
    • Answered
    • over 4 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • gINT Data in a SQL Environment

    tmckenney
    tmckenney
    Team, My company is starting to research the use of SQL to host it's gINT data. It is working out very well in our test group. We are able to use the data in a BI software and create boring plans in GIS very efficiently. We are only seeing a few items…
    • over 7 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Enterprise Databases Hosted in AZURE

    tmckenney
    tmckenney
    Hi Folks, I am looking for some insight on if anyone has tried or been successful with using AZURE with gINT. I have been able to get the database created but I am having a few problems. When trying to upsize I get a timeout error around 30 seconds…
    • over 7 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • gINT - Correspondence File SQL Query / Text too long?

    Poolio
    Poolio
    I am trying to concatenate a few bits of text into my Hole_Log table. Basically I want to combine 2 fields within some hand written text e.g. "Original log produced by " <<HOLE_LOG>> "in" <<HOLE_STAR),yyyy " and digitally reproduced by My Company…
    • Answered
    • over 8 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: combining data from multiple tables in component descriptions

    Pat Cummings
    Pat Cummings
    I haven't tried to use <<CompDescChild()>> because its stated function is to bring in children of the components table. Since lab data is a child of sample, it doesn't seem applicable. Do you think there's a way to use it here? I asked to find out…
    • over 12 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: gINT Text Reports

    Pat Cummings
    Pat Cummings
    Jaffa, the command Max( expression ) will work for most purposes, including a simple list of dates. In that case, the Julian day number of the date that results from (expression) will be evaluated and the maximum value returned. This will be the latest…
    • over 12 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • SQL Syntax and Logic in gINT

    Pat Cummings
    Pat Cummings
    RyanZ asked a good question that illustrates a common issue in using the <<SQL()>> function in gINT reports: We are working with two separate coordinate systems in our database. One that is describing the lithology of the soil, lab specimen.depth,…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: Missing legends on graphs plots from Sql

    Pat Cummings
    Pat Cummings
    Thanks, Phil! I suspect the problem may be the shift from single project to multiple project. RecordItem, as you have noted, works with the single-project GPJ or SQL Server instance. It's only when you are trying to specify data by RecordItem from…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: Display soil description in Sample Table

    Pat Cummings
    Pat Cummings
    Just looking at the SQL, there are some problems: <<Sql(SELECT (LITHOLOGY.DESCRIPTION) _ FROM LITHOLOGY _ WHERE (<<Sample.Depth>> < <<Lithology.Bottom>>) AND _ (<<Sample.depth>> >= <<lithology.depth>>) _ )>> should be: <<Sql(SELECT [LITHOLOGY…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: Muliple dependant data in graphs

    Phil Wade
    Phil Wade
    You need to relate the TRIT data back to the TRIG table, since your graph has a keyset of PointID,Depth. <<SQL(_ select avg([TRIT].[TRIT_CU]) _ from [TRIT] _ where [PointID] = '<<TRIG.PointID>>' _ and [SAMP_Depth] = <<TRIG.SAMP_Depth>> _ and [SAMP_REF…
    • over 10 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
  • View related content throughout OpenGround | gINT | Keynetix
  • More
  • Cancel