OG Template Studio - End of Borehole Text Limitations

Hi all,

I'm running into some limitations on end of borehole text. Please find thought process and attempts below. 

1. For reference, end of borehole text goes into this field within the Depth Columns setting. I noticed that by default, there's an expression written here that pulls details from the LocationDetails group.

Default expression: 'Terminated at '+text(fixed([LocationDetails.FinalDepth],2,false))+' ft. '+if(isblank([LocationDetails.TerminationReason]),'',[LocationDetails.TerminationReason]+'.')

 

2. My goal was to create two headers within LocationDetails. 

2a. The first field would be a LongText string field allowing data entry staff to override text printed at the end of the borehole log.

2b. The second field would a string calculation field that would build a sentence based on data entered. This field would only print if the first field has nothing entered. 

'Borehole terminated at a depth of ' + text(fixed([LocationDetails.FinalDepth], 1, false)) + ' feet bgs.\n' +

if(count([AggregateAll.ProgressByTime.DepthWater]) = 0, 'Groundwater was not encountered.\n', 'Groundwater was encountered at a depth of ' + text(fixed(first([AggregateAll.ProgressByTime.DepthWater]), 1, false)) + '.\n') +

if(count([AggregateAll.SPT.BlowsMain1]) > 0, 'Blow counts recorded for every 6 inches of drive (or fraction thereof) with a 140-lb automatic trip hammer / 30-inch drop.\n', '') +

if(count([AggregateAll.WindowSampling.Pressure1]) > 0, 'Pressure (psi) recorded to advance D&M Piston, Shelby Tube, and Pitcher Barrel Samplers.', '')

This formula does not work as a header calculation because the 'count' and 'first' functions are log only functions. https://docs.bentley.com/LiveContent/web/OpenGround%20Cloud-v12/en/GUID-2E79ABFA-3652-461D-B855-B4188721A6A2.html 



3. I tried skipping the header calculation expressions and putting the expression directly within template studio. This worked, however because the field is ShortText, you cannot copypaste carriage returns into it. 

 

4. After succeeding in step #3, I noticed that the End of Borehole text always prints center aligned even if the Header or text objects (in this case [DescriptionBar]) are left aligned. Furthermore within the Depth Column settings there is no option to change alignment of the text. I tried setting the entire column(s) to left align with no success. 


5. This isn't an issue, I am just listing it here for documentation for other OG users. After rewriting the End of Borehole expression to include the override for Data Entry staff, I noticed that writing '\n' into the field does not print a carriage return on the PDF. In this scenario, LongText string fields will accept carriage returns from Data Entry with the following rules. 

  • Enter = Exit and save data entry field
  • Enter + Alt = Insert 1 carriage return
  • Enter + Shift = Insert 2 carriage returns

I have a few questions: 

  • Is there a method to change text alignment of end of borehole text?
  • Does Bentley intend to program log only function capability into the rest of OpenGround? I don't see how this would be an issue for Header expressions, because these expressions retrieve all data via AggregateAll, and therefore shouldn't require groups to be Depth Linked as other Header expressions would.
  • Can Bentley create an additional window for users to edit expressions within? It's impossible to write expressions in OpenGround from a user experience perspective. See example screenshot below from gINT.
     
Parents
  • Hi Joseph,

    • Is there a method to change text alignment of end of borehole text?

    At the moment no. I'll add this as an enhancement

    • Does Bentley intend to program log only function capability into the rest of OpenGround? I don't see how this would be an issue for Header expressions, because these expressions retrieve all data via AggregateAll, and therefore shouldn't require groups to be Depth Linked as other Header expressions would.

    I don't think its planned. I'll check and if it's not I'll add it as an enhancement. 

    • Can Bentley create an additional window for users to edit expressions within? 

    Again, I'll add it as an enhancement.

    Martyn

Reply
  • Hi Joseph,

    • Is there a method to change text alignment of end of borehole text?

    At the moment no. I'll add this as an enhancement

    • Does Bentley intend to program log only function capability into the rest of OpenGround? I don't see how this would be an issue for Header expressions, because these expressions retrieve all data via AggregateAll, and therefore shouldn't require groups to be Depth Linked as other Header expressions would.

    I don't think its planned. I'll check and if it's not I'll add it as an enhancement. 

    • Can Bentley create an additional window for users to edit expressions within? 

    Again, I'll add it as an enhancement.

    Martyn

Children
  • Hi Martyn, 

    Two more enhancement request on this topic. 

    1. Currently the end of borehole text expression has no error checking. You can input whatever broken expression into it and it will let you save. Afterwards when you run a quicklog, if the expression has an error, nothing will print to the end of borehole text. Please add error checking to this field. 

    2. End of Borehole text ignores report template body boundaries. This is a critical error. The text should rollover to the next page.