# Release Notes

LLMS index: [llms.txt](/llms.txt)

---

## 2020-01-02

- Version 1.0 release

## 2023-06-10

- Version 2 Release
  - 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 no `DESCR` field is found, we now look for the first non-key character field on the prompt table that has a non-null value and return that. This supports 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 an 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.

## 2026-04-20

- Added pagination support for SQL-type SWS configurations. Clients can now page through large result sets by passing the `pageNumber` and `rowLimit` URL query-string parameters. The response meta now includes `pageNumber`, `rowLimit`, and (when more rows remain) `nextPageNumber`. See [Pagination for SQL endpoints](https://sws.books.cedarhillsgroup.com/docs/config/sws-config/#pagination-for-sql-endpoints) for details.
  - This brings the SQL handler to parity with the PsoftQL handler on pagination.
  - Existing callers that send neither parameter continue to receive the same response they did before — the change is fully backward compatible.