Presage/Recent Application Changes - Revision history

Dillon Sadofsky: /* Version 2.11 */

2026-02-06T23:50:39Z

Version 2.11

← Older revision		Revision as of 18:50, 6 February 2026
Line 2,514:		Line 2,514:
	* Added: (case 21738) WO internal notes, made the report landscape, and changed grouping behavior to accommodate the note changes.		* Added: (case 21738) WO internal notes, made the report landscape, and changed grouping behavior to accommodate the note changes.

	=Version 2.11=		=Version 2.1.1=
	==Database:==		==Database:==
	* Added: (case 11138) analysis options and choices/threshholds can now be marked as inactive.		* Added: (case 11138) analysis options and choices/threshholds can now be marked as inactive.

Jbonge: /* Version 6.15 (8/8/2025) */

2025-11-03T22:38:50Z

Version 6.15 (8/8/2025)

@@ Line 140: / Line 140: @@
 * Updated: (EE-922) Tooltips for when permissions are bad for saving
 * Added: (EE-922) Checks for the new permissions
 =Version 6.0 (10/17/2024)=

Dillon Sadofsky: /* v7.1.0 (10/27/2025) */

2025-10-28T21:05:23Z

v7.1.0 (10/27/2025)

← Older revision		Revision as of 16:05, 28 October 2025
Line 56:		Line 56:
	# Editable dropdowns in list controls now show the themed blue border when the user has clicked in [[Image:DropdownInList.png\|text-bottom\|none\|thumb]]		# Editable dropdowns in list controls now show the themed blue border when the user has clicked in [[Image:DropdownInList.png\|text-bottom\|none\|thumb]]
	# Multi-line text fields in list controls now do much better about 'growing' correctly to fit the text to display to the user. [[Image:MultilineEdit.png\|text-bottom\|none\|thumb\|656px]]		# Multi-line text fields in list controls now do much better about 'growing' correctly to fit the text to display to the user. [[Image:MultilineEdit.png\|text-bottom\|none\|thumb\|656px]]

			This update also includes the following fixes:

			# Web browser pages should no longer leave MSEdgeWebView2.exe processes running on the system after the application closes in some circumstances.
			# The embedded edge browser now writes its data into the windows temp directory instead of the Presage installation directory. This helps for situations where the user doesn't have write privileges to Program Files (x86).

	=Version 6.15 (8/8/2025)=		=Version 6.15 (8/8/2025)=

Dillon Sadofsky: /* PS Change log 7.0 (10/23/2025) */

2025-10-28T21:02:02Z

PS Change log 7.0 (10/23/2025)

@@ Line 43: / Line 43: @@
 * Fixed: an issue where the date range sample criterion on saved searches or new searches could result in query errors on MySQL 8 servers.
 * Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)
 =Version 6.15 (8/8/2025)=

Dillon Sadofsky at 19:59, 23 October 2025

2025-10-23T19:59:51Z

← Older revision		Revision as of 14:59, 23 October 2025
Line 10:		Line 10:
	* Fixed: an issue where the background of a property page would not be the correct style if it did not contain a static text area or a button.		* Fixed: an issue where the background of a property page would not be the correct style if it did not contain a static text area or a button.

	==Installer=		==Installer==
	* Added: (EE-1039) the version of ODBC packaged in the installer has been updated to be 8.0.27. This is the newest version that supports TLS 1.3 that still supports old TLS 1.0 and 1.1. This allows us to support a wide range of server security protocols.		* Added: (EE-1039) the version of ODBC packaged in the installer has been updated to be 8.0.27. This is the newest version that supports TLS 1.3 that still supports old TLS 1.0 and 1.1. This allows us to support a wide range of server security protocols.
	* Fixed: the uninstaller now removes ODBC entries.		* Fixed: the uninstaller now removes ODBC entries.

Dillon Sadofsky at 19:59, 23 October 2025

2025-10-23T19:59:33Z

← Older revision		Revision as of 14:59, 23 October 2025
Line 1:		Line 1:

			=PS Change log 7.0 (10/23/2025)=
			Revisions 25118-25317
			==General==
			* Fixed: an issue where looping across reports to update had a bug in release mode, causing a query error.
			* Changed: the application is now explicitly not High-DPI aware. On some systems this helps to ensure that ITrack looks correct when windows scaling is above 100%.
			* Fixed: audited every file for dialog font settings and standardized on MS Shell Dlg, which seems to be an alias for the operating system's dialog font, which seems to resolve to Microsoft Sans Serif(8). This was previously mixed with MS Sans Serif, which resolved correctly on some machines but not others, resulting in missing fonts, leading to some inconsistent looks on some windows 11 machines.
			* Fixed: minor improvements to the choose folder dialog and some error reporting messages.
			* Added: propert pages (tabs) now automatically change the font any multi-line edit controls when it initializes, overwriting the operating system preference for ClearType and turning it off. This is because a recent windows update now causes weird blurring to occur in multi-line edit boxes inside of property pages. Its still unclear why Microsoft did this.
			* Fixed: an issue where the background of a property page would not be the correct style if it did not contain a static text area or a button.

			==Installer=
			* Added: (EE-1039) the version of ODBC packaged in the installer has been updated to be 8.0.27. This is the newest version that supports TLS 1.3 that still supports old TLS 1.0 and 1.1. This allows us to support a wide range of server security protocols.
			* Fixed: the uninstaller now removes ODBC entries.
			* Fixed: an issue where the ODBC registry entries were written to "SOFTWARE\WOW6432Node\WOW6432Node\ODBC" instead of "SOFTWARE\WOW6432Node\ODBC". This didn't seem to interfere with operation, but it isn't technically correct. This seems to be because it was a 32 bit installer.
			* Removed: the (now) unused Microsoft redistributable package 2013, which was only included for ODBC 5. The new version uses the shared 2015-2022 package.

			==Database==
			* Added: The total unit conversion factor between two products is now inclusive of the start product's unit conversion factor. This allows a single product to have conversion factor to an imaginary parent unit, simplifying configuration.
			* Fixed: an issue where a logging trigger was logging twice.
			* Added: supplierid column to sample table (With FK and related logging)
			* Added: showsupplier column to workordertype table (With related logging)
			* Changed: PS-740: the defaults for all graphing URLs have been updated to match the current configuration expectations.
			* Changed: (PA-778) for the newly added showsupplier field, existing workordertypes should now default to off, but new workordertypes will default to on.
			* Changed: (PA-775) adds support for supplier tag based option restrictions to f_test_option_restrictions
			* Added: Version 702 - Add CONFIGURATION_CAN_CONFIGURE_PRINTERS permission
			* Added: Grant printer config permission to all users who can use report viewer

			==Graphing==
			* Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

			==Home==
			* Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

			==ITrack Online==
			* Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

			==ITMySQLConnection==
			* Added: support for some more specific SSL configuration errors when the user has a SSL path set, but it is incorrect. The user is prompted to go into the configure connection settings page to fix this.
			* Added: the configure database connection popup now lets the user configure the "Use SSL" checkbox along with the directory to find the SSL certs and the (optional) prefix for the cert and key.

			==Sampling==
			* Fixed: an issue where the date range sample criterion on saved searches or new searches could result in query errors on MySQL 8 servers.
			* Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

	=Version 6.15 (8/8/2025)=		=Version 6.15 (8/8/2025)=
	Revision 24603-25117		Revision 24603-25117

Dillon Sadofsky at 23:29, 8 August 2025

2025-08-08T23:29:39Z

← Older revision		Revision as of 18:29, 8 August 2025
Line 1:		Line 1:
			=Version 6.15 (8/8/2025)=
			Revision 24603-25117
			==Installer==
			* Added: if the user runs the installer in silent mode, default database credentials should now be written to the host.ini and odbc connection correctly.
			* Removed: Visual C++ 2008 redistributable package now that our application is built with newer tools.

			==General/Shared==
			* Tooling: the application is now built with newer version of visual studio and newer platform SDKs. This should mean faster and more secure applications in general, and it also means that we can drop the need for the visual c++ 2008 redistributable package that was in the installer previously.
			* Fixed: an inconsistent crash that could sometimes happen when closing a screen containing a property sheet.

			==Database==
			* Removed: some specific references to the latin1 character set in recent versions so that databases running in utf8 won't have errors.
			* Changed: logging triggers for many tables has been rebuilt to include newly added fields.
			* Removed: logging triggers for valuecalculation table, as it is mostly unused.
			* Added: logging to useraccount.apitoken for security purposes.
			* Fixed: An issue where f_get_next_schedule could throw a database error if the dayoffset or monthoffset were 0 when they should not be. Now they'll be assumed to be 1.
			* Changed: the wording of the email that is sent when we could not check if the data clone report could not be run. It is now clearer that this does not mean that the data clones failed, but instead that we couldn't check whether they failed or succeeded at all.
			* Changed: new deployment now creates plant 1 in UTC timezone instead of SYSTEM
			* Changed: new deployment now creates several default plant tags and assigns them to plant 1 by default.
			* Added: function NORMDIST which computes a normal distribution.
			* Removed: explicit latin1 in f_BIN_TO_UUID
			* Added: explicit HEX of binary columns in logging triggers for useraccount tables
			* Added: analysisoptionvalueproduct.created for tracking when an ingredient was added to a recipe batch.
			* Removed: e_archive_change_logs no longer does any actual archiving. This is because mysql 8 can't use ARCHIVE engine anyway, so moving rows from log tables to ARCHIVE_log tables just makes them harder to find and both tables are just row_format=COMPRESSED innodb tables anyway. If this ends up leading to large hard drive consumption, we should add row deletion to this event, but probably on a much longer time limit.
			* Added: (PA-502) the clone data stored procedure now supports several new settings that control whether work orders are cloned with dates relative to the current moment or the original scheduled date. The second new setting controls whether samples that would be scheduled in the past will be skipped or not. Both settings default to continuity with previous behavior.
			* Added: v650: some new fields that will allow the user to specify a secondary unit for each product and a conversion between the primary and secondary unit. These are both optional fields.
			* Added: new stored function for computing total conversion factor for product units.
			* Added: analysis option fields for controlling sections
			* Fixed: useraccount.name can no longer be NULL, any existing null values have been updated to unique values to avoid collisions.
			* Added: (v652) added f_decimal_to_fraction, a function that can turn most decimal numbers into a reduced fraction string.
			* Added: (v653) updated logging triggers to tables product, analysisoption. Added logging triggers to productbatch table.
			* Added: (PA-547) new schema for transactionalizing release date on ingredient lot usage on recipes.
			* Added: group.externalid and useraccount.externalid are now logged in the audit logging triggers
			* Fixed: (PA-558) fixed an issue where the time of day was not being properly copied when cloning work orders. This was due to the time being copied in UTC, which would not consider daylight savings time. We now copy the time of day in the local timezone, so that daylight savings time is considered.
			* Added: an update that will reset any current settings for the 4 SPC settings that enable option correlation calculations on active databases. This is computationally expensive, and it is not supposed to be on by default, but was incorrectly activating on new deployments. If a company wishes to enable this system, they will need to set calculation periods again after this update.
			* Added: (case PA-598) enum options for push notification support.
			* Added: an index to the alertqueue table to hopefully keep lookups for unread alert queue messages fast.
			* Modified: alert queue stored procedures to handle specific "Push" type alert queue messages.
			* Fixed: p_backup_table now assumes the current database instead of `backup` if none is specified. Also, ROW_COUNT() is no longer used to see how many rows were moved between tables as this seems to behave inconsistently on some systems. Instead, we run the select on the source table to figure out if we're out of rows now.
			* Added: p_archive_table_data, which uses p_backup_table internally to move rows between tables. However, it does it more performantly by going in primary key order in a specific way. In general, on very large tables, I've found it gets very expensive to do `LIMIT X, Y` with no WHERE clause on a good index to jump across millions of rows. So this version ORDERs the results by the primary key and finds ranges of the primary key to filter by and passes a WHERE clause into p_backup_table to keep each chunk constant-time across the archive process.
			* Added: archive process now adds data to an ongoing log. Also, added optional 'start from' id.
			* Added: UnArchiveLogs script, which attempts to show a series of queries that I ran against Polar to both combine some erroneous (case sensitive) versions of their archives as well as merge their archive logs back into their live logs without locking up their system. I had to monitor their hard-drive space while I was doing it, but it worked without locking things up, and did require a new stored procedure to not take exponential time for 700million rows. For them, it probably took like 10 total hours, but I had a lot of missteps and had to write new procedures and stuff, and they needed probably 46GB of free space all said, but IDK if some of that was mysql logs.
			* Added: an index for lot # lookup
			* Added: query for changes to modernize userpushsubscription
			* Added: logging triggers to the userpushsubscription table.
			* Modified many stored procedures, functions, and a couple triggers to use "NOT" instead of unary operator "!" to avoid warnings in mysql 8.
			* Added: a query to more specifically set analysis option inventory mode to 'Single Lot' for everything on a recipe to assist users updating to v6 to have data continuity with the system before the update.
			* Added: Added new script as per PA-648
			* Added: `Rejected` to productbatch.status enum
			* Added: schema for the shared dashboard system
			* Added: dashboard permissions to go with the recent dashboard schema
			* Changed: recently released database version 656 to have foreign keys on the dashboard tables that will be more likely to not have issues on customer systems.

			==Configuration==
			* Changed: SYSTEM is no longer a valid timezone for new plants by default. But if any existing plant has SYSTEM or any other unknown timezone saved, it will be shown correctly.

			==CrystalReports==
			* Fixed: (PA-562) the edit->reports page file upload dialog now shows an error box if it failed to read the file in windows.

			==Data Management==
			* Fixed: an issue where data being converted during an import could sometimes be blank string and sometimes NULL, depending on how the user mapped the field (mapped to a blank column vs mapped to a fixed blank value) which was leading to difficulty in conversion scripts.
			* Changed: when an import is being performed, if a field token is unmapped or otherwise completely invalid, it will now be replaced with NULL instead of deleted. This will allow queries to sometimes complete in a reasonable fashion instead of resulting in syntax errors.
			* Added: the auto-map process that happens when the user loads or refreshes an import CSV now considers the sub-field sources' names. This allows more specific creation of import templates for auto-mapping purposes. The auto-map process is now multi-pass where exact (case-insensitive) matching is preferred, but a second pass is performed where matches are allowed where fields/columns that 'start with' the other are matched. Any previously mapped fields are excluded from the auto-map process.

			==Investigation==
			* Fixed: an issue where the Result column on an investigation could include too many (non-failure) options/values.
			* Fixed: (PA-595) an issue where the work order type dropdown on the investigation configuration screen was not correctly showing plant specific options.

			==Login==
			* Fixed: some initialization operations were happening twice when the user would launch the application, which could cause slightly slower startups.

			==SamplingHistory==
			* Fixed: a crash that could occur when the user checked/unchecked the 'show modified values icon' option in the right click menu if they had multiple samples loaded with different numbers of options on them.

			==TransactionList==
			* Changed: (case EE-889) exporting from the transaction list now pays attention to the users sorted columns before export.
			* Updated: (EE-922) Tooltips for when permissions are bad for saving
			* Added: (EE-922) Checks for the new permissions

	=Version 6.0 (10/17/2024)=		=Version 6.0 (10/17/2024)=
	Revision 24207-24602 database version 600		Revision 24207-24602 database version 600

Jbonge: /* Version 6.0 (10/17/2024) */

2024-10-29T17:05:39Z

Version 6.0 (10/17/2024)

@@ Line 91: / Line 91: @@
 * Fixed: (FB-39027) if a recipe has its production volume changed, all options/steps will have their acceptability recalculated.  This avoids an issue where per-batch thresholds were not recomputing after the batch volume changed.
 * Changed: sample sequence ID will now save as NULL instead of 0 when it is not a scheduled sample.
 =Version 5.0=

Dillon Sadofsky at 21:25, 17 October 2024

2024-10-17T21:25:00Z

← Older revision		Revision as of 16:25, 17 October 2024
Line 1:		Line 1:
			=Version 6.0 (10/17/2024)=
			Revision 24207-24602 database version 600

			==Breaking Changes==
			* Presage 6.0 no longer relies on a special MySQL plugin for sending alerts to the client. This is now handled exclusively by the Presage API. This means this functionality requires the Presage API to be running for a client. If you do not receive alerts after this update, please contact Presage support.

			==Installer==
			* The installer has been rebuilt and modernized. Unnecessary dependencies have been removed, and some components updated to newer versions.
			* Added uninstaller
			* Uninstallation now removes install/release key
			* Removed instantVNC
			* Fixed: downloading TSC_Lastest tag printer installer now works again

			==Controls/Tools==
			* Fixed: a potential crash that could occur when modifying visibility of a button.
			* Added: support for easily toggling sorting and/or drag and drop on and off on a list control since in some places, sort order can be saved, and therefore must be disabled when the list is read only.
			* Added: stored procedures that should be able to accurately restore records for any table from audit logs.
			* Fixed: (EE-237) a subtle and rare bug that could cause a tree control with a footer to sometimes be shorter than it was supposed to be. Changes from the list control from 2018 have been adapted to the tree control to bring the two in line for their behavior.
			* Fixed: an issue where some popups would not be tied to the application correctly. This meant that the user could sometimes use alt+tab to access the application still even though a popup was present. This also fixes an issue where auto-refresh timers were not being halted while these popups were visible. Now they will pause correctly.
			* Changed: the way popups center on their parent window now works in a way that doesn't require breaking how popups are tied to the application.

			==Database==
			* Added: an index to the analysisoptionvalue table on the date a value was filled out to make some dashboard queries faster.
			* Added p_restore_table_from_logs a generalized version of restoring a table from the logs.
			* Added some handling of temporal columns default functions like NOW or CURRENT_TIMESTAMP
			* Migrated all previous p_restore_xx procs to use p_restore_table_from_logs
			* Added p_restore_every_row_in_table_from_logs, which makes easy a rarely performed function where every historical record in a table will be restored from logs. This can be useful if a table was accidentally emptied.
			* Removed: It was noted that Presage had foreign keys on the table reportprinter (which is shared between products) unlike the other systems. These foreign keys were preventing the use of the value of 0 for userid or siteid to denote 'global' so they had to be removed
			* Deprecating: a couple of unused tables as part of an effort to make deployment size smaller.
			* Added: some enhancements and formatting to p_run_for_each_table that was introduced in another product
			* Changed: numbers table is now innodb to match all other schema
			* Fixed: an issue where the overnight option correlation calculator was failing.
			* Fixed: an issue where the expire sessions event could fail during daylight savings changeover.
			* Fixed: an issue where the event that ensures that data clones ran successfully would incorrectly email an error when running 2 hours after a daylight savings changeover.
			* Added: new tables keyvaluepair and userpushsubscription, used for push notifications
			* Fixed: when the scheduleinstance table had startdate changed from DATETIME to TIMESTAMP, mysql automatically added 'on update' to it so that the datetime would be set to NOW whenever anything changed, which is not desirable
			* Fixed: misspellings of occurrence in p_schedule_instance_populate
			* Fixed: an issue where a schedule with an end date would not stop at the passed in end date for instance generation
			* Fixed: added three different protections against infinite loops in p_schedule_instance_populate to protect against runaway schedules
			* Added: sample.due, sample.scheduled, analysisoptionchoice.productbatchid, and workorder.productbatchid were all not being logged and now are
			* Added: table/column comments to some tables that didn't have them.
			* Minor change to an unreleased index to assist both dashboards and reports
			* Added: (PA-332) several indices to improve the speed of common load operations and reports for large clients.
			* Added: database index for workorder.scheduled to improve load speed for some mobile applications.
			* Added: a couple more indices to the workordertype and sample tables to help speed up some common operations.
			* Added: (PA-351) changes to many tables to add the multiple lot tracking/inventory subsystem.
			* Added: e_process_alert now checks a setting to see if the API is configured to send alerts. This allows us to transition alert emailing from the database UDF to the API.
			* Added: field for supplier item number on sample value inventory.

			==Analyses==
			* Added: (FB-48673) a prompt to delete the current analysis option rule if all tags have been removed from it.
			* Fixed: typo
			* Fixed: an issue with analysis option choices/thresholds where deactivated products or products that were not in use at a plant would stop showing on historical choices/thresholds.

			==Configuration==
			* Added: The settings page now refreshes global and site level settings when the user visits this page. This should help avoid issues where the user sees 'old' information in this popup that was changed by another user or in the database directly.
			* Added: (EE-141) the system will now close all historical user sessions if a user is locked or deactivated.

			==Crystal Reports Printing==
			* Added: print jobs now have a title set based on the user friendly name of the report, plus a file extension. Testing revealed that this causes some PDF printers to name the default file equal to this title, making printing to PDF slightly easier.

			==ITMySQLConnection==
			* Fixed: a minor issue where, if ca-cert.pem is completely missing, requiring SSL might not throw an error when connecting.
			* Added: comment /RECONNECT QUERIES CHANGED FOR CONNECTION "X", RUNNING NOW:/ to the start of the queries run by mysql every time we reconnect to the database.

			==Locations==
			* Fixed: an issue where adding an image and switching maps without saving might stop showing the image.
			* Fixed: an issue where top-level images, text, and boxes wouldn't save in some scenarios.

			==Login==
			* Added: when the user logs out and back in, global settings are now refreshed from the database to avoid situations where they have out of date information until they restart the application.

			==Master==
			* Changed: suppressed a database error that could be thrown from help->about if the database did not have a version in it.

			==Products==
			* Fixed: an issue where address lookups on the supplier address area were throwing a query error when doing a city/zip lookup.
			* Fixed: an issue where the user could experience crashing or other random behavior if they hit the reset/refresh button before adding new product specifications.
			* Fixed: an issue where deactivated products/ingredients (or those not in use at the plant) no longer showing in dropdowns on recipes/steps that reference those products/ingredients.

			==Report Viewer==
			* Added: (EE-164) the user can now see the "Delayed until" column in the print queue history tab. In addition, there are now filters for all job statuses and a filter to display only jobs with a delay until date.

			==Sampling==
			* Added: (PA-226) the approved on column now shows the time as well as date.
			* Added: when loading thousands of samples, the sample values are loaded for 1000 samples at a time. This is to avoid issues in the database from loading too many samples' values at once. (Technical note: It was noted that MySQL didn't like to use an index anymore when the sampleid IN clause grew greater than 13313)

			==Work Orders==
			* Fixed: (PA-274) a crash that could occur if the user viewed a change log of a WO where the product batch had changed.
			* Fixed: an issue where the testing WOs page would show a bunch of "N/A" columns if there were only recipes on the WO. Now, only displayable samples will factor into computing what columns to show.
			* Fixed: (FB-39027) if a recipe has its production volume changed, all options/steps will have their acceptability recalculated. This avoids an issue where per-batch thresholds were not recomputing after the batch volume changed.
			* Changed: sample sequence ID will now save as NULL instead of 0 when it is not a scheduled sample.

	=Version 5.0=		=Version 5.0=
	Revision 23919-24206 database version 500		Revision 23919-24206 database version 500

Jbonge: /* Version 5.0 */

2023-12-19T20:58:24Z

Version 5.0

Show changes