Version 9.1.206 (19 January 2026)

People Management

Change people groups query to use dynamic parameters to avoid parameter sniffing (#143512)

Problem

• The dapper query to fetch the list of people group users can, at times, take extremely long.
• This is due to the query plan caching and the parameter sniffing that is required with the current implementation.

Solution

• Added OPTION RECOMPILE to the temp table insert query, additionally changed the Dapper parameters to be dynamic to allow specifying the exact types, which enables SQL to create a better execution plan. 
• Date values are submitted through as datetime parameters and not as varchar

System Access

Resolved system access not saving, throwing a sorry page (#143531)

Problem

• Url changes implemented for validation, and a new object is stored as JSON. Within the JSON conversion, it could not deserialise correctly 

Solution

• Add implementation to navigate and correctly add items to a new list