Professional (24.1)

Forms – Action Levels – Added Chemical Name to Grid in Advanced Action Level Tab [d36386]

Added the CHEMICAL_NAME field to the Advanced Action Level Lookup tab. This will allow users to easily set the PARAM_CODE by selecting a chemical name from the drop-down, as well as to be able to see the chemical name for a CAS_RN value in the PARAM_CODE.

Forms – Action Levels – Clone Row Option Added to Lookup Tab of Action Levels Form [d36175]

The Action Levels Form has been updated to allow Advanced Action Level Lookup records to be cloned. This will make populating DT_ACTION_LEVEL_LOOKUP more convenient while using the form.

Forms – Microsoft 365 OAuth Form – Update System.Buffers Reference to 4.5.1/4.0.3.0 [d36047]

Updated an internal library reference to improve system performance (System Buffer 4.5.1) in the Microsoft 365 OAuth Form (EarthSoft.Forms.Library.d23880.dll file). For more information, see https://help.earthsoft.com/lib_microsoft-365-oauth-form.htm.

Forms – SampleTestResult II and III Forms – Able to Save Whether or Not Cursor Remains in Edited Cell/Table [d35921]

Fixed an issue when making edits in either the SampleTestResult II Form or the SampleTestResult III Form (EarthSoft.Forms.Library.6621303.dll) so that users no longer need to click out of the cell before saving.

Professional – Grid-Filtered Numeric Field Wrongly Exports to Excel with Different Number of Records [d36015]

Fixed a bug in EQuIS Professional where data tables with column filter values containing a decimal were not exporting consistently to Microsoft Excel.

Reports – Action Level Exceedance II – Inconsistently Using Advanced Action Levels [d36964]

Fixed a bug that could cause one or more action level selections to be ignored when running the Action Level Exceedance II report multiple times with different action levels.

Reports – Action Level Exceedance II Reports – Conversions Fail for Formula Units [d35958]

Fixed a bug where units were not being converted in Action Level Exceedance II reports (reports in EarthSoft.Reports.Library.51729.dll) when converting to or from action levels using a reporting formula. These reports, if already published to your project database(s), MUST be republished, following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.

Reports – Analytical Results II – Stop Applying ND Multiplier Significant Figures to ND Report Results [d35842]

Updated the Analytical Results II report so that it no longer formats non-detect results with significant figures by default. This will prevent undesired non-detect results if the value of 'ND Multiplier' parameter is not correctly configured.

Reports – New – Lithology Data [d35048]

Added new Lithology Data report (EarthSoft.Interfaces.d34009.dll) to the EQuIS Standard Report Library. The Lithology Data report compiles information from the DT_LITHOLOGY table and its associated DT_LITHOLOGY_COMPONENT table.

For more information, see https://help.earthsoft.com/index.htm?lib_lithology-data.htm

Reports – New – Relative Percent Difference IV [d36451]

Added new Relative Percent Difference IV report (EarthSoft.Reports.Library.d31287.dll) to the EQuIS Standard Report Library.

The report uses Analytical Results II parameters to return a dataset with Relative Percent Difference (RPD) calculations based on analytical results from primary, duplicate, and triplicate samples. Output includes those calculations as well as Analytical Results II data for the primary sample.

The RPDs are compared to an RPD limit and optional warning limit then flagged accordingly. The report can be crosstabbed to highlight exceedances in the limit or warning limit.

For more information, see https://help.earthsoft.com/lib_relative-percent-difference-iv.htm

Reports – Publishing – Added Option for Non-Admin Users to Publish Reports and Forms [d35188]

Enabled non-admins with appropriate permissions to publish reports and forms. Admin permission is still required to publish SQL reports.

Schema – Professional – Added VALIDATION_LEVEL Field to DT_RESULT [d35964]

Updated the Standard EQuIS Schema with new column VALIDATION_LEVEL in the DT_RESULT table. This column stores the level of data validation completed for each result.

Schema – Professional – Updated TIMEZONE_CODE Fields from varchar(10) to varchar(40) [d36126]

Increased the length of TIMEZONE_CODE fields. These fields are in:

DT_LOCATION, RT_COMPANY
RT_TIMEZONE
RT_TIMEZONE_OFFSET

As well as (due to WQX Schema):

DT_SAMPLE.SAMPLE_DATE_TIMEZONE
DT_TEST
DT_TEST.ANALYSIS_DATE_TIMEZONE
PREP_DATE_TIMEZONE

Schema – RadChem – Expanded DT_RESULT.RESULT_NUMERIC to DECIMAL(28,19) Precision for Radiological Data [d35098]

Updated the Schema to increase the size of DT_RESULT.RESULT_NUMERIC to allow for more precise measurements in radiological data.

Customers can request the RadChem Schema update from Support at https://help.earthsoft.com/earthsoft_support.htm.

Note: Prior to applying this Schema update, the database must be updated to 7.21.3 Build or later to ensure that the DT_RESULT.RESULT_NUMERIC value is large enough to contain the data from the expanded RESULT_NUMERIC field.