Major changes in functionality. Merging PsoftQL functionality that was never publicly marketed before with the version 1 SWS into one platform.
2023-09-26
Small fix for automatic prompt table lookups. If nothing was found (DESCR field found) we now look for the first non-key character fields on the prompt table and has a non-null value and return that. This is to support prompt tables that have no DESCR field but have other fields that can be used as a description.
2024-05-01
Added some missing code to the project during last build.
2026-01-21
Add support for basic Aggregate functions in PsoftQL queries.
Only One record is supported and no support for Having clause currently.
2026-01-25
Added support for sorting results in PsoftQL queries.
Sort order can be ascending or descending.
Multiple sort fields are supported.
Fixed and issue with joining parent child fields where the key field is a blank character and adding a “space” since PeopleSoft does NOT allow nulls in character fields.