Presage/Recent Application Changes

General:

• Fixed: an issue where combo sorting was case insensitive, but the auto-suggest list was case sensitive.
• Changed: auto-suggest dropdown lists are no longer sorted, even if the primary combo list is. This makes it so that auto-suggested strings are always in 'fitness' order (how well they match the input.
• Added: advanced combo boxes now default to 'find input anywhere' when auto-suggest/auto-complete is turned on. This means results are matched no matter where the input is found in the string.
• Fixed: sometimes icon cells in an ITListCtrl would not automatically redraw when the screen changed what icons were being displayed in the cell.
• Fixed: dead whitespace in the list controls is finally fixed. The previous fix didn't account for situations in which the scrollbars were currently visible but were about to disappear (due to client space increasing).
• Fixed: a drawing issue where clicking in a field (causing a Scroll in the list) might not redraw the 'close buttons' on the items, leaving what looked like 2 sets.
• Fixed: (case 12012) Items half-way on the screen did not redraw correctly. This fixes an issue where items that were only partially visible were not being properly redrawn, causing checkboxes to not toggle their state if they were halfway on the screen.
• Fixed: (case 12012) This should fix an issue where the list allowed items to be only partially visible vertically.
• Fixed: an issue where, if a list had a footer control and hidden columns, some of the columns might not redraw correctly, and there were more columns than necessary.
• Added: if the user resizes a column by dragging a column header, the footer columns are now resized in real-time. This makes matching things up simpler.
• Removed: pretty much completely eliminated flickering that would happen in list footers when they were resizing.
• Fixed: an issue where hiding/showing/deleting/adding columns while the user had scrolled horizontally would cause the header tooltips to be misaligned.
• Fixed: if a list control is hidden when it is initialized, the footer will also start out hidden.

Graphing website:

• Fixed: the severity class retrieved for a particular result now considers the plant when getting the default severity class.
• Fixed: renamed f_format_acceptibility to f_format_acceptability (misspelled)
• Fixed: an issue where thresholds might show .000000 at the end of a whole number value in the legend.
• Added: (case 6478) all graphed series (both thresholds and data series) have their colors set based on the acceptability of the result. Green for acceptable, orange for marginal, red for unacceptable, and blue for out of bounds. If multiple analyses are being graphed at the same time, the colors are shifted slightly for each series of data to make them easier to tell apart.
• Fixed: an issue where selecting "ALL" from the analysis dropdown might not show all analyses.
• Added: (case 6478) the 'color shifting' between analyses of the same acceptability (multiple green series for example) has been tweaked to not repeat a specific hue. Differences between colors are more pronounced if fewer series are graphed. The color 'ranges' have been tweaked to look better and be more distinguishable.

Analysis:

• Fixed: an issue where the analysis option ordering wasn't saving if the user switched analyses and then switched back.
• Fixed (case 12371) an issue where renaming an analysis wouldn't move over the print quantities at the same time, causing the values to fall off the analysis.
• Added: (case 10130) there is now a permission for each of the 4 tabs on the analysis screen. If the user is set to permission level "None", the corresponding page will not appear. A user with level "Plant" will be limited to editing information just at their plant(s). The schedules tab requires global permission because those objects are shared between plants.

CommonResources:

• Added: (Case 10263) there is now a permission that controls what plant(s) the user can edit sample tag #'s at (if any).
• Fixed: an issue where numeric analysis option values might save with unnecessary precision (6.100000 instead of 6.1). This was making some reports look messy. This will only correct data moving forward.

Configuration:

• Added: (case 11879) user account names can now be edited in user configuration. New (unsaved) users can now be deleted as well (saved users are just de-activated).
• Added: (case 11879) when the user hits apply in user configuration, they will now be presented with a more user friendly error if there are duplicate user account names.
• Changed: minor UX tweaks to make user configuration easier and more consistent with other screens.
• Added: (case 11614) the configure users page now limits which users can be edited based on the current user's permissions. Essentially, users will only be able to administrate their own plant(s) now.
• Added: new user accounts will automatically inherit the current plant that the administrator user is logged into.
• Fixed: an issue where a user who didn't have permission to edit plants, users, groups, or locations might still be able to edit them on the configuration screen. Now, if the user doesn't have permission, those pages are missing and the button on the Directory page is greyed out.
• Changed: a user now needs global permission to edit groups, since they are shared across all plants.
• Fixed: the icon was missing on the Configuration menu option.

Database:

• Fixed: another misspelled function name in the database.
• Added: (case 10263) a new permission for editing tag #'s on WO samples. This new permission defaults to on for anyone who can edit WOs.
• Added: (case 12276) workorder.due (due date), which defaults to NULL (no due date).
• Added: ( case 10130) 4 new permissions for the analysis management screen.
• Fixed: all historical samples with unnecessary precision (6.100000 instead of 6.1) have been corrected. This leads to cleaner graphing and reporting.
• Fixed: all numerical thresholds with unnecessary precision (6.100000 instead of 6.1) have been corrected.

Investigations:

• Fixed: an issue where sending a sample to be investigated from the WO screen (before doing any searches) might cause a crash or bad samples to be loaded.
• Changed: clicking search when unsaved investigations are present will now prompt the user to save. All other save prompts have been standardized.
• Fixed: an issue where a user with "None" for the permission "Configuration"->"Can configure investigations" was still allowing the user to edit global defaults.
• Changed: several settings in the alerts page have had their scope changed to "Hidden" since they contain sensitive data.
• Fixed: a crash when starting a new investigation.

ITMySQLConnection:

• Performance: removed a bit of unnecessary meta-data that was being stored with every query result set.

Locations:

• Fixed: (Case 12299) an issue where the locations screen might crash if the user sent locations to be visualized.
• Added: (case 12451) there is now an "Animate" button on location visualization, which plays through the samples in the currently displayed order.

Login:

• Fixed: a possible crash/error that could happen if the application was launched without database access.

Master:

• Changed: (case 11921) it was possible that ITrack didn't have any valid database connection, but it tried to get the local versionlist anyway, which would stop the update process. Now, if that happens, the system acts the same as if no database connection is present and attempts to continue. This should help prevent a state where an installation cannot be used and cannot get updates.
• Added: when the user hits "reset updates", they will now be put into a mode where we force the download of updates. This ignores some things that would normally stop update downloading, including lack of access to the local database or lack of database extension.

Products:

• Added: support for a new permission that controls whether the user can mark products as in use at their plant(s).

SettingsFramework:

• Fixed: an issue where, if the database could not be reached, or there was no database extension loaded, updates would not be applied when Presage was closed.
• Added: (case 12371) support for a new 'rename setting' operation used by the analysis screen.

WorkOrders:

• Fixed: a minor issue where, during printing, a dropdown might reappear in the list after a message box popped up.
• Fixed: (case 12026) an issue where the user could print a tag or testing tag for an item by right clicking on it before it was saved. Now, the user will be prompted to save the item if it has been modified.
• Fixed: some performance issues that could cause loading, clearing, or saving a WO to take slightly longer than necessary. Another side effect is that the list of samples might flicker and the user's selection would be cleared.
• Fixed: (case 12011) an issue where changing the plant of a WO might not correctly remove all samples at other plants.
• Removed: (case 12164) clicking on a sample option no longer automatically puts the option's default into the sample.
• Added: (case 12164) marking a sample as sampled now automatically fills out all default values into the sample.
• Added: (case 12276) there is now a due date at the top of the screen next to the scheduled date.

Locations:

• Fixed: an issue that was keeping the search for samples button from working.
• Fixed: (case 10855) an issue where locations might show the wrong plant's default severity class (display issue only).
• Fixed: (case 11273) an issue where configuring locations at a plant with no default severity class might cause a crash.

Database:

• Fixed: an issue where p_clone_data might create a clone with a 'date scheduled' other than the user expected.
• Added: (case 11549) a new permission controlling when someone can edit samples on the sample history screen. This permission defaults to everyone with the permission to edit work orders.
• Added: (case 11550) a new permission controlling what plants a user can search on the sample history screen. This permission defaults to the open screen permission level.
• Changed: p_get_subtree now accepts a string instead of an integer for its primary value. This allows the user to pass in a comma separated list instead of a single value. All previous queries will keep working as per usual.
• Fixed: p_get_subtree will no longer return ids that were passed in that are invalid or duplicate.
• Added: (case 11270) new stored procedure, p_get_subtree_by_lookup, which is like p_get_subtree, but it will find all results in the table that match a wild-card enabled string on a specified column, and then get the subtree that fits all matches. This is a lot faster than running a query to get all matches, then running p_get_subtree for each result separately and then merging the results.

Commonresources:

• Added: (case 11404) analysis option value columns will now size themselves automatically to fit the data type contained in that column.

Login:

• Fixed: (case 11581) an issue where the data management screen wasn't respecting the "Can open screen" permission for that screen.
• Added: support for adding the transaction list to Presage.

Sampling:

• Added: (case 11270) there is now a product dropdown the user can use to search samples by product.
• Changed: the user can no longer perform a search with no plants selected.
• Added: various UI elements are greyed out if the user doesn't have permission to them at all.
• Added: the location auto-complete field now allows the user to type from the middle by default. All previous users will not be affected, but can change this preference in settings under "Auto-Complete".

Graphing:

• Fixed: an issue where handleWildcards was only replacing the first instance of a wildcard.
• Added: server-side support for product_id and product_name parameters. product_name supports wildcards. In either case, all child products will also be searched.
• Added: client-side support for product_id and product_name URL parameters.

ReportViewer:

• Added: date, time, and datetime fields now have the 'none' checkbox on the left, allowing the user to pass blank dates to reports, for situations were optional dates are desired.

Settings:

• Fixed: an issue where report parameter choices were not being loaded correctly.

Update 4/15/2014

Analysis:

• Changed: the layout and text of the columns in the analysis option values list have been adjusted to be more human readable.
• Fixed: an issue where extra empty thresholds were being inserted.
• Added: a new column in the choice/threhold list, 'Global'. Global thresholds apply to all plants. Non-global thresholds apply to only the current plant. The global column now defaults to checked.
• Added: switching whether a threshold has a product or severity class now switches whether a threshold can be global.
• Added: the product column is now populated with the products that apply to the current plant.

CommonResources:

• Fixed: an issue where the WO screen might show the wrong analysis options if more than one analysis shared the same name.
• Added: (case 10513) support for showing only checked options in the search results.
• Added: the sample detail list now has a column for product, which is populated with all valid products for the sample's plant.
• Fixed: (case 10750) the choice dropdowns for samples now limit the options based on the plant of the sample, the severity class of the location (or the default severity class if there is no location), the product of the sample (if any), and all parent products of that product.

Product:

• Fixed: crash that would happen if you opened the screen with an empty product list.
• Added: (case 10778) saving a product with an empty name field will now result in an error popup.
• Fixed: (case 10778) a crash error that could occur when adding a product underneath a product that was not 'in use' at the current plant.
• Added: (case 10775) hitting the add button will now add a sibling instead of a child product.

Sampling:

• Changed: (Case 10466) when searching analyses, all options are now unchecked by default.
• Added: (case 10513) only analysis options that are checked will show in the search results.

INI updates:

• Fixed: the urls that control the manual, credits, and changelog are now presage specific.
• Changed: (case 5938) the homepage for ITrack Online is now http://www.presageanalytics.com/.

Database:

• Updated: the plantid of existing analysisoptionchoice entries should now be filled out.
• Added: sample.plantid. This tracks the plant a sample was taken at. This was required because location is now optional on samples, which was the only gauranteed way to find plantid before. The initial value of this field has been set based on location or workorder.
• Added: new function, f_find_applicable_thresholds. This function will create a TEMPORARY TABLE TEMP_applicable_thresholds and fills it with all entries from analysisoptionchoice, remarking on each whether it applies to the specified parameters and otherwise, why not. This will be very useful for showing what constraints are applicable to an analysis value.
• Added: new function, f_check_applicable_thresholds. This function calls f_find_applicable_thresholds to get all thresholds that apply to the parameters, then does type specific casting in order to check to see which (if any) of the applicable constraints are violated by the value specified. This will be very useful for showing 'why' a value is coming up "Unacceptible" or "Marginal", etc.
• Changed: f_get_value_acceptability no longer calculates directly, but instead calls f_check_applicable_thresholds and returns the 'worst' violation.
• Added: f_get_value_acceptability now accepts a productid and plantid as arguments. This is required because the threholds now have more restrictions (global/plant specific, and per product or global).

WorkOrders:

• Added: support for products in the sample list.

Update 4/3/2014

• Added: (case 10778) saving a product with an empty name field will now result in an error popup.
• Fixed: (case 10778) a crash error that could occur when adding a product underneath a product that was not 'in use' at the current plant.

Update 3/31/2014

CrystalReportsExtension:

• Changed: (Case 10612) if the user prints a report with 'advanced options', the printer dialog that pops up now has a quantity field on it, which will be used to override the number of copies to print.

Database:

• Added: the sample table now has an optional reference to the product table for when samples begin to be collected for products.
• Added: the analysisoptionchoice can now have a reference to a product, allowing thresholds to be product specific.
• Changed: products are now global, except there is the ability to specify which plants each product is "In Use" at.
• Changed: p_get_location_subtree has been generalized into p_get_subtree, which can return a group_concat of primary keys of any simple hierarchical table.
• Added: support for product attachments.
• Added: permission for modifying products.

Products:

• Added: "Show inactive products" checkbox, which filters the product tree to just active products.
• Added: add/delete buttons to the bottom of the screen similar to the add/delete buttons on the location interface.
• Added: Similar to deleting analyses and locations, the system now checks to see if deleting a product is 'safe' (IE if its currently in use on saved samples or analyses). 'Unsafe' deletes require a permission to complete.
• Added: the product detail page now fills data out as the user selects products, and changing values is updated in the tree immediately.
• Added: there is now a "Show this product at the current plant" checkbox, which is a per-plant setting controlling whether a specific plant wishes to see the specified product in its product list.
• Added: saving products now properly updates, creates, and deletes products.
• Fixed: hitting the refresh/reset button now correctly reloads data from the database, discarding changes.
• Added: there is now a column for whether each product is in use at the current plant. This will switch automatically as the user switches plants.
• Added: The "show inactive products" now remembers the user's last choice.
• Added: permission for whether user can modify products. The user must have global permission to add/edit/delete products.
• Added: product attachments are now functional. The attachments tab now displays the number of attachments loaded for the currently selected product.
• Added: adding and removing products now works as expected.
• Added: new products inherit many options from the parent Product.
• Added: the category dropdown now shows all previously entered product categories.
• Fixed: an issue where deleting a product would delete all child products, no matter what the user chose.

CommonResources:

• Fixed: an issue where the WO screen might show the wrong analysis options if more than one analysis shared the same name.

Update 3/19/2014

Analysis:

• Fixed: (case 10522) an issue where changing plant in the analysis screen wouldn't refresh the options in the severity class dropdown for thresholds.
• Added: there are 2 new columns in the analysis list which allow the user to control how many copies of the sample tag and testing tag get printed out when printing WOs. These settings are plant-specific so each plant can have different quantities for the same analysis.
• Changed: the apply and reset buttons have been re-arranged to match the apply and cancel button order in most windows applications.
• Changed: the pop-ups that happen when the user is going to delete an analysis are now more consistent and show the number of samples and scheduled locations that will be deleted always.

CommonResources:

• Added: (case 10609) the user can now print a quantity of tags other than 1. The last reprint quantity is remembered, so reprinting the same number of tags in the future is easy.

Database:

• Removed: some (now) unused fields from the analysis table.
• Fixed: the version of f_get_next_day_of_week that was released previously was out of date.
• Added: a new permission for allowing access to the product management screen.
• Added: (case 10551) table for storing product information.

Product:

• Added: (case 10551) a new 'product management' screen, wherein the user can manage products, ingredients, and recipes.
• Changed: the attachments button has been removed and replaced with an attachments page.
• Added: the plant dropdown is now filled with plants.
• Added: opening the screen now properly loads all products into the product tree, but the user cannot edit them yet.

Sampling:

• Added: (case 10187) the plant auto-complete dropdown now only shows the user options for the set of plants that are selected.
• Changed: this screen is now called "Sampling History" in the main menu.

WorkOrders:

• Fixed: an issue where new work orders were saving the date, but not the time they were created.