Forms – Action Levels – Only Display Action Levels and Action Level Types with STATUS_FLAG = A [d26618]
Modified the Action Level Form to only display action levels and action level types with STATUS_FLAG = A.
Improve Encryption of *.equis Files [d26117]
The *.equis files that are downloaded (from EQuIS Enterprise) when launching EQuIS Professional from EQuIS Enterprise are encrypted. Similarly, the *.equis files created when saving connections in EQuIS Professional are encrypted. This release strengthens the encryption to improve security of those files. Any *.equis files created by earlier versions of EQuIS Professional (when saving a connection) will continue to work.
Professional – Allow Users to Open ST_ROLE when There Are Denied Fields [d26012]
Certain users with restricted access to ST_ROLE can now open the table as expected.
Professional – Interfaces – Format Interface Buttons Launch *.ZIP Files [d25897]
In EQuIS Professional, the format interface buttons for SEDD, AGS, DIGGS, ERPIMS, GeoTracker, and HazSite now look for *.ZIP files, rather than *.XSD or *.XSE files, when trying to open the format.
Professional – OpenID – Use WebView2 (Microsoft Edge) Instead of WebBrowser (Internet Explorer) for IdentityModel.OidcClient [d26301]
OpenID
now uses Microsoft Edge as the rendering engine.
Reports – Action Level Exceedance II – Action Level(s) Report Parameter Only Display Active Action Levels [d26525]
Updated the Action Level Exceedance II report so only action levels with DT_ACTION_LEVEL.STATUS_FLAG = A are displayed in the Action Level(s) report parameter list. (Note that DT_ACTION_LEVEL.STATUS_FLAG has been added in the EQuIS Schema update for this release.)
Reports – Action Level Exceedance II – MAG Sum and TEQ Sum Transformations Resulted in Error and Did Not Return Sum Rows [d25453]
Fixed a bug in the TEQ Sum and MAG Sum transformations that caused an error when these transformations were selected in the Analytical Results section of the Action Level Exceedance II report parameters. These functions worked without error when called as part of an Advanced Action Level.
Reports – Action Level Exceedance II – Single Quotes Caused Error with Advanced Action Levels [d26480]
Fixed a bug in the location-specific monthly average advanced action level where comparison_operator = MON_AVG_H would throw an error if a single quote was used in the SYS_SAMPLE_CODE.
Fixed a bug in the TEQ_SUM advanced action level that caused an error if a single quote was used in the ANALYTIC_METHOD.
Reports – Analytical Results II – Add Transformation Error Message [d25691]
Analytical Results II (AR II) now generates a row with an error message if the transformation DLL information in ST_MODULE and DT_ACTION_LEVEL_LOOKUP is incorrect during configuration, or if the DLL itself is invalid. Note that AR II reports for previous builds will ignore errors if the AR II Transformation fails to work.
Reports – Analytical Results II – Enable Running Transformation DLLs from ST_MODULE [d25477]
Analytical Results II (AR II) Transformation .DLL files no longer need to be placed in the EQuIS Professional folder or in the Enterprise bin folder if they are uploaded to ST_MODULE.
Reports – Analytical Results II – Parameter to Only Show Analytes with at Least One Detect [d23030]
Analytical Results II has a new parameter,
Result | Analyte | Exclude Analyte(s). The "Without detects under the selected parameters" option will exclude analytes that do not have at least one detected value under the selected parameters from the output. Republishing the report assembly (EarthSoft.Reports.Library.50943.dll) is recommended following these instructions: https://help.earthsoft.com/index.htm?pro_republish.htm.
Reports – Crosstabs – Add Detects-Only Aggregate Options for Tabbed Data [d24827]
Added detects-only Aggregate options for tabbed data within crosstabs: "Maximum (Detects Only)", "Minimum (Detects Only)", and "Sum (Detects Only)".
Reports – Crosstabs – Add Formatting for Non-Detect Exceedances [d25541]
Crosstab configuration options now include additional formatting options, Display (Non-Detect), for non-detect exceedances in Row Header(s) and Column Header(s).
Reports – Crosstabs – Fixed Action Level Captions from Crosstab XMLs [d27223]
Previously, captions for action levels ([action level name]_action_level fields) loaded into Crosstab reports from crosstab configuration XML files may have displayed incorrectly. This has now been fixed.
Reports – Crosstabs – Saved XMLs Changing [action_level]_FLAG to [action_level]_WARNING_FLAG [d26225]
When loading crosstab configuration XML files, EQuIS Professional would interpret a modified, generalized (to force acceptance of different sets of action levels) row or column header such as 1_FLAG as x_WARNING_FLAG instead of x_FLAG. The issue has been solved.
Reports – Ionic Charge Balance – Update Source to Analytical Results II [d25959]
Updated the "Ionic Charge Balance" report to retrieve source data from Analytical Results II, rather than the superseded Analytical Results database report. Republishing the report assembly (EarthSoft.Reports.Library.60525.dll) is recommended following these instructions: https://help.earthsoft.com/index.htm?pro_republish.htm .
Reports – ND_X Multiplier Not Applied in MAG Sum for Cultures with Comma Decimal Separators [d26963]
Fixed an issue assigning the ND_X multiplier in the MAG Sum function when using comma decimal separator cultures.
Reports – ND_X Multiplier Not Applied in TEQ Sum for Cultures with Comma Decimal Separators [d27000]
Fixed an issue assigning the ND_X multiplier and TEF multipliers in the TEQ Sum function when using comma decimal separator cultures.
Reports – TEQ Sum Transformation Setup Now Requires MAG Row in DT_ACTION_LEVEL_LOOKUP [d26251]
The code for the Toxic Equivalency Quotient (TEQ) Sum Transformation has been modified so that a new Method Analyte Group row (with COMPARISON_ID = 'SUM') is now required in DT_ACTION_LEVEL_LOOKUP, similar to the TEQ Sum Advanced Action Level DT_ACTION_LEVEL_PARAMETER setup.
Schema – Professional – Add CATEGORY Field to RT_COST_TYPE [d24558]
Added CATEGORY field to the RT_COST_TYPE table in the standard EQuIS Schema.
Schema – Professional – Add FACILITY_ID to the Unique Key Constraint for DT_COST [d24556]
Added FACILITY_ID to the Unique Key Constraint for the DT_COST table in the standard EQuIS Schema.
Schema – Professional – Added DT_ACTION_LEVEL.STATUS_FLAG [d26521]
The STATUS_FLAG column has been added to the DT_ACTION_LEVEL table.
Schema – Professional – Drop Foreign Key on DT_SDG [d26141]
Due
to the different ways EQuIS modules use the DT_SDG table, a Schema update has
been added to drop the Foreign Key on DT_SDG.DATA_REVIEW_COMPANY if it exists.
Schema – Professional – EQUIS.USER_CONTEXT Creates User in ST_USER Automatically with AAD Login [d26362]
Modified the EQUIS.USER_CONTEXT stored procedure to check for a user in the ST_USER table with the same email address. Previously, running stored procedures with Azure Active Directory (AAD) logins from SQL Server Management Studio (SSMS) would populate ST_USER with a new '@example.org' user, rather than calling the existing user.