title: Next draft: false date: 2025-06-19

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.

• Summary Printing (CSS)

Updated the site styling to make the summary page printing better. The menu bar, side bar, and footer are no longer visible in the printed version, and pages will avoid breaking groups and fields.

The styling should work when printing from the popup on the search page, and when printing from the summary page.

Grid Cancel Button Fix

Fixed a bug with the grid row editing where clicking cancel would not discard the changes.

Fixed for:

• Component grid on improvement details page
• User grid on the admin page
• All type grids (area type, component type, etc.)

Draggable Marker Exception Fix

Maps with draggable markers could crash the page if a user opened, and subsequently closed, the map before the marker was fully added to the map (most obvious on the location selection popup when searching).

Attachment Preview

Added the ability to preview all attachments in a popup on the attachment tabs (cost and improvements details pages). The attachment popup has a download button in the upper right hand corner to allow users to download the attachment.

Focus Row Changes

Updated the focus row styling to improve contrast and readability.

Multiple Attachment Upload Error

Fixed an issue where uploading multiple attachments at once would cause an error (failed to save the changes).

Details Page Help

Added the ability for help information to be associated with to form fields and portions of the UI. The information appears as a fly-out linked to an icon on the page.

Examples: (help information is provided for the industry, record status, and total cost fields)

When the user clicks on the icon the fly-out appears.

All of the information is static, and specified by AgWare. This is just a slightly more convenient way to provide quick information about a field in Cost New.

The user has the option to disable the help icons from the profile page. The setting defaults to true, and once set is stored in the browsers local storage. The toggle behaves the same as the time zone and requires the user click the "Save Changes" button for the changes to be stored. The help icon on the profile page will always appear regardless of the user's settings to provide information, and an example, of what the toggle does.

RCN Estimate Layouts Update

Updated the RCN estimate page layout so the RCN/Unit field is above the tabs to indicate that it is not affected by the tabs. Also added a new field that solely indicates the value of the regression estimate so the estimate does not get lost when a user changes the RCN/Unit field. When the RCN/Unit and RCN/Unit Estimate fields are not equal, and the estimate is not empty, the button to the right will be enabled. Clicking the button will overwrite the RCN/Unit field with the estimated value.

Size Suggestion Edge Case

Updated the suggestion logic to handle an edge case when the improvements only use one unit, and the cost record has another unit used on the first size the primary suggestion should be displayed on the second size.

Percentage Overrun Field

Added a field to track the percentage overrun of the total cost.

History Page Exception Fixes

The cost, improvement, and improvement type record history pages would throw an exception when an unauthenticated user tried to load the data. This is now fixed.

Required Field Highlighting

Updated all of the edit forms and grids so that required fields are highlighted when a user loads the page.

Updated pages:

• Cost creation page
• Cost details page
• Improvement details page
• Improvement type details page
• All of the simple type pages (area type, component type, etc...)

Regression Improvements

Updated the RCN estimate page so that the regression line is calculated using least squares instead of online gradient descent. This improves the R squared values of the models and removes occurrences of negative R squared values. The model is now trained on the entire data set as well.

New Units

Added "Cu Ft" and "Cu Yards" units to the unit classes.

Cost Record Last Edited Property

Added a property to cost records that keeps track of the last time the cost record or any of its child records (improvements and components) were changed.

The property can be used on the search page to filter results.

Unit Filtering Update

Updated the way the unit filtering works.

Added a new required field called "Display Unit" which controls which unit information is displayed in the unit class, size, and dollar per unit columns.

All three unit fields (Display Unit, Unit, and Improvement Unit) are bound to the same data behind the scenes, so changing one will change the other two.

The unit filters will only limit results once a size has been set.

Home Page Recently Edited Records

Added a grid to the home page which will show up to the last 10 cost records edited by the user.

Empty Map Display

Updated the search page map so that it will focus on the US when there are no search results with a location.

Size Suggestion

Added suggestions for the size 1 and 2 fields of cost records if the records have improvements with sizes and units. The suggestions appear at the top right of the size field groups when the size fields are not set. When a user clicks the suggestion the associated size, unit class, and dollar per unit will be updated on the cost record.

The suggestion are based on the most commonly used unit classes for all of the improvements. The top suggestion (units most used) will appear on first size, and the second on the second size. The size values are the sum of all improvement sizes that use the same unit, and the dollar per unit fields are calculated based on the size.

There are a couple of special cases for the suggestions.

If the first unit class is set to something other than the unit class of the first suggestion then the first suggestion will appear on the second size (provided the second size fields are empty).

If the second size unit class is set to the same value as the top suggestion unit class then the second suggestion will appear on the first size (provided the first size fields are not set).

Changing Cost Indexes

Updated the cost details page to allow users to change the index of a cost by changing the cost record state or bid date.

Because the index is a unique identifier the user should be made aware that it will change. To facilitate this the bid date and state fields were made read only on the main details page. A button was added to each that will open a popup.

The popup allows the bid date and state fields to be edited, and provides a warning when the fields are changed in a way that will affect the index.

The index will be updated if the state or bid date year changes. When they are changed the popup will display a warning comparing the current index to the new estimated index. If the user clicks save the changes will be saved to the database immediately. If the user closes the popup then the main values will not be updated.

The "to" index in the popup is only an estimated index. When the changes are saved the index will be recalculated to ensure that there are no duplicate values. The only part that can change during this is the suffix (e.g. "00001"). The true index will be displayed at the top of the details page after saving the changes.

Cost Layout Changes

Updated the layout of the cost details and summary pages.

Changes (large screen):

• Moved the sizes and total cost to the right
• Moved the improvements to the middle of the page
• Moved the comment and address below the improvement list
• Grouped the address fields

Changes (small):

• Moved the improvement list below the size

Narrow layout:

Address Geocoding

Added the ability for Cost New to geocode address latitude and longitude from Google using the information provided in the state, county, zip code, city, and address fields (address fields group).

If all of the address fields are filled out the Cost New and the latitude and longitude are not set Cost New will try to get a latitude and longitude based on the information provided when the user saves the changes.

If successful, a notification will be displayed to the user stating that the coordinates were filled by geocoding the address information.