Tenant Dashboard Improvement

Updated the tenant usage dashboards so that they should be less prone to errors, especially when reloading the page. Also improved error handling.

Because the Azure databases have a limit on the number of active connections it is still possible to cause an error by opening multiple tabs which all load the dashboards.

Usage Dashboard Errors

Fixed an issue with the usage dashboards when loading from larger databases on Azure.

Search Filter User Ordering

Updated the search filters so that users can reorder them, via drag and drop, as desired. Filter order is stored in the browser, and will applied each time the page is loaded.

Also added the options to reset the filters to the default ordering, or alphabetize them.

Admin Usage Dashboard

Added a new page available to security admins that shows user logins, total cost record, cost record deletions, cost record creations, and cost record edits over a specified date range. The dashboard is accessible to security admins and, if configured, AgWare.

The data will be aggregated over various time spans depending upon the date range (the larger the date range, the bigger the aggregation timespan). Each data point allows the user to hover over it to see the value, and the timespan over which the data was aggregated. The points appear at the end of the time range specified.

The dashboards can be shared with AgWare to provide us with some general usage information. This is opt-in, optional, and reversible at any time. When the dashboard is shared with AgWare employees with proper permissions will be able to see an identical version on our internal Control Plane. Changes to the checkbox will take effect immediately, but the only for way AgWare to know is to manually check Control Plane.

Attachment Download Behavior

Updated the download link behavior in the attachment grid so that it will no longer open PDF and images for preview.

Forwarded Headers

Updated Cost New to use the forwarded for header from the gateway so that the IP address from which users access the site will be correctly displayed in the access log.

Improvement Summary Grid Quality

Added a quality selector to the search improvement summary grid to allow users to filter the data to certain quality improvements.

The quality types are not restricted by units, so it is possible to choose a combination for which there is no data.

History Updates

Updated the history pages to display improvement quality and cost record percent overrun (both were tracked before, but not visible on the history pages). Also updated the county column so that it displays the county name instead of the county code.

Grid Focus Row Fix

Fixed an issue with the improvement grid on the RCN Estimate page not focusing on improvements when the link button is clicked from a callout.

Search All States

Updated the state filter so that it behaves like other normal filters and is not required. This allows users to clear the state filter to search for records across all states easily.

The filter does still appear on the initial prompt to allow users to reduce the number of records returned, which will increase performance.

Xlsx Attachment Preview Fix

Fixed a bug where xlsx files could not be previewed.

Search Horizontal Map Resizing

Added a splitter to the map and improvement summary grid to match the vertical resizing behavior.

Download Button Column

Added a download button column to the attachment grid to allow attachments to be downloaded without opening the preview popup.

Clustering Fix

An update to the maps clustering library caused the clustering to break. To resolve the issue a compatible version was specified.

Location Selection Popup Prompt

Added text to the title of the location selection popup indicating that a marker should be dropped to pick the center point.

Query Performance Improvements

An attempted improving loading times of the details page for improvements with many components (and potentially costs with many improvements).

Duplicate Record Check

Added a popup to the cost creation page that will appear if the data entered is similar to other records in the database.

RCN Estimate Page Improvement Selection

Added a new tab to the RCN Estimate page that allows users to view the individual improvements that match the filter criteria, and choose which improvements are used in the regression. The choice is across filter updates as long as the improvement is not filtered out. All improvements will default to being used in the regression. The grid allows sorting, filtering, and exporting to Excel.

In order to facilitate matching improvement records to data points and map points, fly-outs were added to the chart and map which display some summary information about the improvement (not customizable) and link back to the improvement in the list (highlighted with red square).

The fly-outs for the map can display multiple improvements since the location is specified at the cost level.

In all locations that the improvement type and cost index appear they function as buttons to view the summary information if the user has permission to do so. If users do not have permission then only the text will appear, and clicking on it will have no effect.

RCN Estimate Trend Line Equation

Updated the RCN Estimate chart with the trend line equation. The equation represents the cost per unit estimate where x is the number of days since the earliest bid date.

Cost Record Default Status

Updated the default record status when creating a new cost record to "Incomplete".

Search Map Focusing

Fixed a race condition which caused the search map to not focus on the markers correctly in some cases. The map should now focus on the result markers when a user first navigates to the page and whenever a filter is changed.

Search Grid Resizing

Updated the search grid to match Maven with a draggable splitter for resizing. This replaces the drop-down at the top of the grid.

Dashboard Editor Behavior

When opening the dashboard editor it will no longer display a dashboard automatically to avoid confusion about which dashboard is being edited.

Additionally, when a dashboard is deleted it will not automatically open another dashboard.

Empty editor:

Improvement Type Creation Fix

Fixed an issue when creating improvement types where the query parameter when creating a new improvement type was kept in the navigation history. This meant that users could navigate back to the new page, which would appear blank and look like the improvement type had not been created, where they could accidentally attempt to insert a duplicate primary key.

Now the navigation history for creating a new improvement is overwritten with the actual record URL, so that navigating back doesn't cause any issues.

Attachment Optimizations

On QA the maximum attachment size was increased to 30MiB, which highlighted some performance issues with larger files.

For both downloads and previews performance has been increased with larger files, and loading was added to the previews to indicate that the file is being processed.

Comment Default Size

Updated the comment boxes on the cost and improvement details pages so that they will not cause the page to expand, but will fill the available space by default.

The comment boxes are still re-sizable vertically, and will scroll if the content is large enough.

Quality

Moved quality to a class, which is controlled by AgWare, and removed the quality setup.

Added an optional quality field to improvements. Also added a filter on the search page for quality.

Non-Visable Type Behavior Fix

For user defined types (region, area, zone, etc.) it was possible to make them visible, assign them to a cost record, and then make them not visible, which would result in the assigned types not showing up on the cost record details page drop-downs. This lead to the fields looking unassigned when they actually were.

To avoid confusion the drop-downs will now populate values that are assigned to the cost record even if they are marked not visible.

Search Side Nav Fix

Fixed a bug where the side nav would sometimes be visible on the search page after entering the initial search fields. This also fixes an issue where navigating to and from the search page could leave the side nav hidden on other pages.

Search with the side nav visible:

RCN Estimate Date Range Reset Bug Fix

Fixed a bug where changing the date range on the RCN Estimate page and then switching tabs would reset the range selection.

Improvement Type Column for Component Results

Added an improvement type column for the component search results which allows users to open the improvement summary popup. Updated the improvement type column for improvements to match (improvement summary column was removed).

Search Result Exporting

Added the ability to export search results to Excel.

Attachment Tag Fix

Fixed an issue where uploading multiple attachments would cause the default tags to be cleared.

Failed attempt (tags are empty):

Expected behavior (tags are populated):

Component Search Results

Added a component tab to the search results can view component information. The component grid includes buttons to view summary information about its parent cost and improvement records.

Additionally the component results are not affected by the Display Unit.

Search Page Filter Help

Added some help icons to the search page to provide summary information about the filters.

Document Preview Errors

Improved the error handling for the document previews, so that if a document causes an error when being previewed it doesn't crash the whole page, and can still be downloaded.

Example with a broken Excel file:

Login Details Page ODIC Information

Updated the login details page to include OpenID Connect configuration information, if it's configured for the tenant.

When viewing the page the protocol is specified (Ws-Federation or OpenID Connect). The OpenID Connect information will display all of the metadata present at the metadata URL if the URL is configured. All of the key information shown is the key's ID and not the actual key value.

RCN Estimate Rounding

Updated the Rcn estimate rounding to 2 decimal places.

Marker Callout Content

Added more to the map marker callouts on the search page. They now include the cost index, the bid date, the total cost, and the industry.

Description Searching

Added the ability to search by improvement description on the search page. The description search will limit results to any cost records that have an improvement with a description that contains the filter string, and limit the improvements to those with a description that contains the filter string.

Descriptor Searching

Added the ability to search by component descriptor on the search page.

The component descriptor filter is usable when one component type is used for filtering. Once a component type is selected its descriptors will be available for filtering. When the component type filter is cleared, or added to the descriptor filter will be cleared.

Skia Renderer

Added the DevExpress Skia render NuGet package to resolve an error when previewing certain attachments on QA.

PDF Skia Renderer

Added the DevExpress Skia renderer for the PDF viewer to resolve an issue with the PDF preview only displaying loading indicators.