A new optional Validation Report tab has been added to the DQM Event Report with:
- Only the minimally required columns in the output (including Qualifiers and Reason
- Other columns available for inclusion via a new report parameter
- All the included Reason Codes listed in the footnotes with their respective Descriptions
Fixed the bug that water_depth is not calculated when the "Water Level\Calculation\Depth:" parameter of the "Water Levels II" report (EarthSoft.Reports.Library.64102.dll) is selected as 'calculate'.
We recommend this report, if already published to your project database(s), be republished following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.
A new column named water_level_depth is added to the output of the Water Levels II Report (EarthSoft.Reports.Library.64102.dll). It equals DT_WATER_LEVEL.WATER_LEVEL_DEPTH if the depth_unit of the report result comes from DT_WATER_LEVEL.DEPTH_UNIT or a converted DT_WATER_LEVEL.WATER_LEVEL_DEPTH if the depth_unit comes from DT_FACILITY.ELEV_UNIT or DT_WELL.DEPTH_UNIT.
One improvement to the output for field names from the Additional Fields parameter, is that field names will no longer be limited to 30 characters in length, and always be tableName_fieldName, e.g. DT_DRILL_ACTIVITY_CUSTOM_FIELD_1 instead of DRILL_ACTIVITY_CUSTOM_FIELD_1 or DT_WATER_LEVEL_MEASURED_DEPTH_OF_WELL instead of WATERLEVELMEASUREDDEPTHOFWELL etc. Due to this change, if a saved crosstab parameters .xml file or published crosstab includes one of these longer Additional Fields parameters, then the crosstab parameters .xml file will need to be resaved and/or the published crosstab will need to be republished.
One improvement to extra_select is that processing is moved into the GetCoreSql method so that calling the method gets the extra_select content.
Added functionality to VW_LOCATION to prevent bad coordinate values stored in DT_COORDINATE from causing the error "Arithmetic overflow error converting varchar to data type numeric" causing the view to fail to return data; this also can cause reports, such as the ARII, from returning any data.
A new feature has been added to DQM that allows users to save default DQM Selections for each QAPP when Starting a DQM event.
A new parameter display type has been added for MultiSelect parameters, 'MultiSelectNonAlpha' was added to allow reports that depend on the selection order to remain in that order. Selections for parameters with ST_REPORT_PARAMETER.DISPLAY_TYPE = 'MultiSelect' will automatically be sorted in alphabetical order. This display type option is now the default setting for the ARII-ALEII Crosstab Report, which allows the report parameter selections for the Crosstab Column Headers, Row Headers and Tabbed Data to stay in the order that they were selected.
Fixed issue when using REPORT_RESULT_TEXT in an extra select statement, the actual text displayed in the new extra field will now match REPORT_RESULT_TEXT (to include non-detect symbol and unit conversions).
Fixed Bug that prevented users running Professional with a "Data" license (i.e. data only, no graphics) from running the Google Earth reports.
When exporting a table (e.g. data table or report output) to text, there are three new options available:
1) JSON Schema/Data (*.json) - this is a concise JSON format that lists the columns
once, then lists each row as an array of values. (This is the format that Enterprise
widgets typically use.).
2) JSON Table (*.json) - this is a more verbose JSON format that lists each row as an
object with properties.
3) Compressed Data Table (*.cdt) - this is a compressed, binary format (not
When running the DQM Complete Event function with only the Save to Validator Qualifiers option selected, the DQM Qualifiers did not save properly and, in fact, any existing qualifiers in the Validator Qualifier column were over-written. This bug has been fixed.
EQuIS Professional has been updated to automatically close the EDP window when changing facilities. Except when EDP is loading/processing, EDP will remain open and Professional will not change facilities.
Fixes issue in which ArcGIS Pro crashes when there is no map loaded in the project and user tries to connect to ArcEQuIS.
In previous versions, some Action Level columns did not reload when a saved Crosstab configuration was reloaded. All columns are now available in saved configurations. When using the same action levels that were in the original Crosstab configuration, there should be no further issues.
However, some combinations of columns are not compatible with the algorithm which attempts to match newly selected action levels to the original action level columns. The following suggestions should help ensure that the crosstab configuration can process various inputs:
1. Include the “regular” action level column (e.g., AL1_action_level) for all action levels
in the configuration, even if it is not populated.
2. Include the same combination of action level columns for each action level.
Fixes a bug in which some settings.xml files did not allow the saving and utilizing of Favorites within EQuIS Professional x86. Users who encounter this behavior should delete their current settings.xml file, and utilize the one created by installing EQuIS Professional 7.20.2 x86
Updated documentation links provided in the ACCEPTABLE_USE table (not visible in EQuIS Professional; must be accessed directly in SSMS or via the EQuIS SQL Form).
In previous EQuIS versions, when running a published Crosstab report (published with the "Published as grid report" option selected), the output to the report grid (in either Professional or Enterprise) was the unformatted crosstab data table.
With this build, the report output will be the same as the formatted output produced when running the Crosstab from the Crosstab UI (with the exception of header/row shading). This change will be seen in newly published Crosstab reports and also in Crosstab reports published in previous versions.
In previous EQuIS versions, when running a published Crosstab report (published with the "Published as grid report" option selected), the output to the report grid in EQuIS Professional was the unformatted crosstab data table.
With this Build, the report output will be displayed with full formatting in the Crosstab UI Form just like a manually generated Crosstab. The full toolbar, including the Export to Excel button, will be available. This change will be seen when running newly published Crosstab reports and Crosstab reports, published in previous versions.
Created new schema for O&M (i.e. Operations and Maintenance) that can store data such as that needed for treatment systems. This schema is intended to be included in an O&M module that should be released at a future date. Tables in the schema include:
- DT_TREATMENT_PARAMETER and
- AT_TREATMENT_LOCATION, with a few additional columns added to existing tables.
Removed obsolete utility folder and Convert_EQ5_ID_to_EQ6_EUID.sql script from EQuIS/db folder.
Database Update and Create Process were updated so that schema "Finalize" steps occur once automatically, rather than individually with each schema file; the "Finalize" steps were removed from the schema files.
In the standard Advanced Action Level functions SINGLE_LOOKUP, MULTIPLE(OR)_LOOKUP, and MULTIPLE(AND)_LOOKUP the ACTION_LEVEL_MIN column in the DT_ACTION_LEVEL_LOOKUP table (when populated) is now included in the processing of the ALEII Report.
Cost tables are added to the standard Professional schema. The new tables are: RT_COST_TYPE, RT_COST_PARAM_TYPE, AT_COST_PARAMETER, DT_COST, and DT_COST_PARAMETER (functionality for these tables to come in future releases).
Two new database functions are available in the EQuIS database (Professional Schema) for converting rates to amounts: EQUIS.UNIT_CONVERT_TIME_RATE_TO_AMOUNT and EQUIS.UNIT_CONVERT_RATE_TO_AMOUNT.
Additionally, three columns are added to RT_UNIT to support these functions:
When connecting to the EQuIS for ArcGIS interface through the EQuIS plugin, an issue occurred where the Premier Data and Graphics license failed to create a connection. This issue has been fixed.
A bug in the Report Parameter Selector caused an error for specific parameters (of type Parameter) on some reports. This has been fixed.
Removed obsolete db/migrate.xme file and Tutor/Reports/Oracle folder with ActiveChart_Oracle.rpx file from EQuIS folder.
Updated the WSP_CREATE_REPORT_TASK stored procedure so that the JOB_ID value assigned is from the [sq_sysid] sequence rather than using a EUID value.
All Syncfusion dependencies have been upgraded to v22.214.171.124. Assembly binding redirects are in place, as a result, references to older versions should automatically work with the new version.
The "ArcEQuIS" folder of the Pro install (C:\Program Files\EarthSoft\EQuIS\Interfaces\ArcEQuIS) is renamed to "ArcMap" to reflect the association of its content with the EQuIS for ArcMap interface rather than the recently released ArcEQuIS.
German language translation strings were improved and updated in EQuIS Professional.
Adding EnviroInsite Spider Diagram Functionality to the ArcEQuIS plugin.
A report has been added to the EarthSoft EnviroInsite Report Library called EnviroInsite Spider Diagram. This report is used to generate EnviroInsite shapefiles, which can then be used to load spider tables into ArcGIS Pro.
Added EBATCH column to Live tables: DT_LOGGER, DT_LOGGER_SERIES, DT_LOGGER_REMARK, DT_LOGGER_DATUM, and DT_LOGGER_DEPUM.
Added the [param_code] column to the Primary Key of the [DT_CHAIN_OF_CUSTODY_PARAMETER] table; this allows more than one parameter to be associated with the chain of custody.
The option to set the advanced action level to a NULL value for any matching LOOKUP value in the SINGLE_LOOKUP or MULTIPLE_LOOKUP functions has been added to the standard Advanced Action Levels in EarthSoft.ActionLevels.Library.105851.dll.
To skip samples with values of the COMPARISON_ID analyte in a given range (e.g. HARDNESS < 100), enter the text value “NULL” in the ACTION_LEVEL column in the DT_ACTION_LEVEL_LOOKUP table.
The Flow Data (EarthSoft.Reports.Library.178519.dll) has been created. It presents the data info of DT_FLOW that meets users’ selected parameters. When action level parameters are selected, the report examines instant_flow, average_flow or cumulative_flow with the selected action levels, and flags a value if it breaks an action level value.
The Flow Statistics (EarthSoft.Reports.Library.178519.dll) has been created. It presents the statistics of DT_FLOW that meets users’ selected parameters. When action level parameters are selected, the report examines the statistical values of instant_flow, average_flow or cumulative_flow with the selected action levels, and flags a value if it breaks an action level value.
Selecting additional MAG fields using the Additional Fields Parameter in the Analytical Results II Report would cause the report to not output data. This has been fixed for the Analytical Results II and Action Level Exceedance II reports. We recommend both report assemblies, if already published to your project database(s), be republished following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.
Running the DQM Exceptions Report by EDD in Build 7.20.1 results in an "Incorrect syntax near 'ANALYSIS'." error message. This was as a result of the change made in the test_batch_type Global Parameter that now allows multiple test batch types. This bug has been fixed in 7.20.2.
Copyright © 2020 EarthSoft, Inc • Modified: 19 May 2020