Version 9.1.151 (17 March 2025)

Imports

PaySpace Signify discrepancy script (#129254)

Problem

• A user cannot validate all the received data from PaySpace or Powershell with the data currently in the system

 

Solution

• Add staging of the received data in the pull processes for Powershell and Payroll
• Include the import types on the front end for the allowed types to export the report
• Extend the allowed export period to 7 days

 

Signify Assistance (#128700)

Issue 1

Problem

When dapper batched has more than 2000 entries in the list it Ands multiple in statements together which returns no result

e.g AND( mu.Username in ('U1',....'U2000') AND mu.Username in ('U2001',....'U3000') )

When used like

public async Task<List<(int Id, string Username)>> ListUsersIdsAsync(int rulesetId, string[] usernames)
{
    using var connection = new SqlConnection(_connectionString);
    await connection.OpenAsync();

    var sql = $@"
                    SELECT
                         muser.[Id]                                               [Id],
                         muser.[Username]                                         [Username]
                    FROM
                         [JobProfiler].[MaterialisedUsers] muser WITH(NOLOCK)
                    WHERE muser.RulesetId = @rulesetId
                    AND {usernames.DapperInBatched(GlobalConstants.MaxDapperBatchSize, "muser.Username")}";

Solution

• When in is used use the OR when not in is used use the AND
  
• When a string has accents, escape it, e.g. TS'01 will be 'TS''01' within the in statement
  

 

Issue 2

Problem

• Due to high traffic and/or other issues, the event to update the materialised users table in the job profiler is not always being consumed in time for the appointments to be created. 
• This then caused the appointment controller to search for the user in the materialized tables that did not exist.

 

Solution

• Create a fall back where when the materialized table has not been updated in time, the relevant appointment controllers fetches the required data and triggers the updates before continuing with the appointment creation.

 

---

Main Dashboard

System Error Message (#129232)

Problem

• If the fallback path does not exist and an error occurs on the Dashboard page and the Edit banner pages

 

Solution

• Introduce fallbackImagePath for default image handling. Update logic to check for fallback directory when no default background files are found

 

---

Performance Management

Unable to import VB items if the section setting is disabled to allow section items to change (#129141)

Problem

• The user could not import multiple periods at the same time, and the user could create a contract in more than one period item.

 

Solution

• Changed PM Import so you can import multiple periods at the same time, as well as excluding users from creating contracts in more than 1 item per review year

 

Issues to access performance module (#129162)

Problem

• When a user's position is set as inactive, the user is not seen as part of the people groups used to determine which review years to show on the PM dashboard.

 

Solution

• Replace the active check with not deleted to be part of the dashboard always as long as the position exists

 

Evaluation Summary not available after Final Approval (#129000)

Problem

• When users view their contract and the employee evaluation is on and has a due date, regardless of the phase, the button cannot be seen.

 

Solution

• Added the button to the check for the user approved to always display in the rating phase
  
• Add the button to the default fallback also

 

Review Period Dates & Review Year Dates - Validation Messages Include Time Erroneously (#125347)

Problem

• On the review year setup and review period setup pages, when the End Date is selected as a Date that falls before the Start Date, validation correctly occurs; however, when the message displaying the error is displayed, it includes the time (00:00:00), which should be removed. The date is also in the format YYYY-MM-DD could this be adjusted to reflect the correct Date Format in accordance with the Language Selected?

 

Solution

• Changed the dates of the translations to short date string, with the correct timezone and culture

 

Unable to include the Value Survey score (#128772)

Problem

• Saving a contract survey gave SQL Dapper an error because of new columns added to the query object used on an unrelated query, causing it to break here.
   
  

Solution

• Made the query model used by the Survey creation distinct from the other usages.

 

---

Data Warehouse

PAS report: Overall Final score not correct (#129134)

Problem

• The Overall Final Score are not being calculated correctly within the Datawarehouse
  
  

Solution

• Adjusted the calculation of the Overall Final Score to consider excluded Review Items

 

Additional fields for the Group / Classes Report (#120152)

Added the additional fields

• Subject Setup: Setup and Config > Ruleset Setup > Product Setup > Learning Management > Product Setup > *subject*
• Marksheet: LMS > [OPEN] Category > [OPEN] Pathway > Class/Group Step > Marksheet
• Attendance History:  LMS > [OPEN] Category > [OPEN] Pathway > Class/Group Step > Attendance History
• Training Interventions (linked to subject setup): Administration > Training Interventions > Type: Certification Point
• Training Interventions (subject assessments): Administration > Training Interventions > Type: Assignment

---

People Management

Error when deleting a user (#128917)

Problem

User Error (#128950)

Problem

• When multiple processes materialise the same people group at the same time, the people group calculation fails due to duplicate insert
  The performance management consumer for the reporting line consumes other reporting line types than LM and PM, resulting in unnecessary errors

 

Solution

• When inserting, confirm that the entry is not part of the people group
  Filter the reporting line types used in the consumer and do not process the other types

---

Notifications

SMS Notifications Not Being Sent (#128562)

Problem

• An SMS cannot be sent by event or process.

 

Solution

• Correct test SMS sending from the template
  
• Correct test SMS sending from the SMS setup
  
• Implement mock sending of SMSs from both the SMS setup and the template
  
• Correct the actual sending of an SMS via Zoom

 

All Tenant Subscription mails to come from Global Ruleset (#125943)

Problem

• The Tenant Subscription process (Fee overdue, system close warnings, etc) must use the Global Ruleset templates.

 

Solution

• The above template is set to be active only on the default ruleset.

 

---

Report Builder

Auto scroll when dragging and dropping columns (#123392)

Problem

---

Ruleset Management

Uptime Indicator not shown on the Login page when the Uptime URL is empty (#128373)

Problem

---

Job Profiler

Support user shown on Org when ruleset is copied (#128500)

Problem

• Support users included in people groups and org structure
  
• Users linked to inactive or deleted appointments after termination cannot be found on people management

 

Solution

• Add check to only include system users
  
• Removed active and deleted position filter checks for people management queries.

 

I want to be able to find the terminated person (#122809)

Problem

• Support users included in people groups and org structure
  
• Users linked to inactive or deleted appointments after termination cannot be found in people management

 

Solution

• Add check to only include system users
  
• Removed active and deleted position filter checks for people management queries.

 

---