Forms – EQuIS SQL Form – New User Interface and Editing Features [d40319]
Updated the EQuIS SQL Form user interface to use the Syncfusion WinForms Syntax Editor Control. This change adds support for syntax highlighting, line numbers, zoom, find and replace, and other context menu/toolbar editing tools.
Forms – Microsoft 365 OAuth Form – Improved Options for Token Acquisition [d40453]
Updated the Microsoft 365 OAuth Form to add an option that creates a Microsoft Entra (formerly known as Azure Active Directory) access token using a service principal/managed identity (e.g., an assigned EQuIS role) instead of requesting a token for an individual user.
Professional – Added Ability to Manually Add Records to DT_GEOGRAPHY [d40334]
Updated the DT_GEOGRAPHY table to allow users to manually enter geography records within EQuIS Professional.
Professional – Added Example Boring Log Templates to Installer [d42342]
Added the following example Boring Log templates, which do not rely on the Geotech Schema, into the Professional installation package:
- EarthSoft_Enviro_Well.xml
- EarthSoft_FullWellDiagram.xml
- EarthSoft_BoringLog.xml
Professional – Expanded EDP Button Tooltip [d40409]
Improved the EDP launch button tooltip to inform users that clicking CTRL+EDP will launch EDP without loading the last used format file.
Professional – Fixed Application Opening Position [d40200]
Fixed a bug so the Professional application will open at the location where Professional was last closed instead of always opening in the center of the screen.
Professional – Fixed Rows Being Overwritten in ST_LOG and ST_USAGE Tables [d40259]
Fixed a bug where making edits to ST_LOG or ST_USAGE would result in the entire table being overwritten with the values of the edited row. Note that EarthSoft does not recommend modifying entries in these tables in general, as they store automated system records.
Professional – Fixed Signout Issues for "Sign in with Microsoft" Authentication [d43083]
Fixed a bug that occasionally kept users logged in via "Sign in with Microsoft" from being fully signed out when clicking the "Sign Out" button.
Professional – Login Screen – Call Enterprise Login to Support Multi-Factor Authentication [d40187]
Updated the EQuIS Professional Sign In for EQuIS Enterprise Application Level Security (ALS) users. Instead of entering a username and password, or remembering the password, these fields have been removed and the Sign In button will now open the EQuIS Enterprise Login screen in a new browser-based window.
Professional – Prevent Values from Having Trailing Spaces in Grid View [d40353]
Updated saving from the Grid View in Professional to truncate trailing space characters in all new or edited records.
Professional – Renamed "Publish Column Configuration" to "Publish Column Choices" [d40392]
Renamed the "Publish Column Configuration" option for saving user reports (in the Column Chooser) to "Publish Column Choices" to avoid confusion with the Action Level Exceedance II "Column Configuration" report parameter.
Professional – Updated ST_USER.LAST_USE_DATE Upon Login [d40325]
Updating the date and time in ST_USER.LAST_USE_DATE each time a user logs into Professional, matching the current behavior for Enterprise users.
Reports – Action Level Exceedance II – Fixed Sum Rows Not Being Added to Report Output When Selected MAG Differed from AAL MAG [d41314]
Fixed a bug in the MAG_SUM (Method Analyte Group) and TEQ_SUM (Toxic Equivalency Factor) calculations that caused the advanced action levels to not add sum rows to the report output when the analyte group selected in the report parameters didn't match the Advanced Action Level MAG. Alternatively, setting the CALC_METHOD in DT_ACTION_LEVEL_LOOKUP equal to "Match ARII" can be used to only add results that match the Advanced Action Level MAG.
Reports – Multi Facility Overview – Added FACILITY_ID Column to Report Output [d41343]
Updated the Multi Facility Overview report to include the FACILITY_ID field in the output, enabling the Enterprise Map widget to utilize the session facility in the report.
Reports – Publishing – Populate ST_REPORT.REPORT_INFO with Output Type, Columns, and Version for Grid Reports [d38774]
Professional will now populate metadata in ST_REPORT.REPORT_INFO when a grid report is published.
Schema – License Database – Updated External SQL License Database Script [d40672]
Updated the License_Database.sql file (available in the License_Database.zip package on the EarthSoft Community Center) to include the ES_PUBLIC database role.
Note, the License_Database.sql file needs to be re-run for all users that are using a standalone license database.
Schema – Professional – Added EQUOTE_CODE Field to DT_CHAIN_OF_CUSTODY for SPM Use [d40586]
Updated the Professional Schema with new field EQUOTE_CODE in the standard DT_CHAIN_OF_CUSTODY table to support workflow for the Sample Planning Module (SPM). This field stores the eQuote code generated by a laboratory.
Schema – Professional – Increase Maximum Character Length of ST_USER.PASSWORD [d40594]
Increased the maximum length of ST_USER.PASSWORD to be able to store 100-character passwords.
Schema – Update External SQL License Database Script to Match Current Schema [d41110]
Updated the External SQL License Database Script to match current Schema. This script is available on the EarthSoft Community Center and is backwards-compatible.