Presage/Recent Application Changes - Revision history

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

2026-07-02T16:08:11Z

PS Change log 7.0 (10/23/2025)

← Older revision		Revision as of 11:08, 2 July 2026
Line 46:		Line 46:
	==Reports==		==Reports==

	==SPC p chart, SPC xbar and r, & SPC xbar and s, Hour, Day, Week, Month Intervals & specified supgroup size for all (StatisticalProcessControl.rpt)===		===SPC p chart, SPC xbar and r, & SPC xbar and s, Hour, Day, Week, Month Intervals & specified supgroup size for all (StatisticalProcessControl.rpt)===
	* Changed: (case PS-1806) = Added non-functional "Language" parameter		* Changed: (case PS-1806) = Added non-functional "Language" parameter

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

2026-07-02T16:07:02Z

PS Change log 7.0 (10/23/2025)

← Older revision		Revision as of 11:07, 2 July 2026
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.		* 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)		* Updated: (case EE-222) to use the new embedded web browser. (No longer supports IE)

			==Reports==

			==SPC p chart, SPC xbar and r, & SPC xbar and s, Hour, Day, Week, Month Intervals & specified supgroup size for all (StatisticalProcessControl.rpt)===
			* Changed: (case PS-1806) = Added non-functional "Language" parameter

	==v7.1.0 (10/27/2025)==		==v7.1.0 (10/27/2025)==

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=