Staffing: API-1016 Invalid Sort direction when expanding the grouped by field

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Since the upgrade we can not expand the grouped by column on the MUX Staffing > Staff grid

When expanding we get an API-1016 Invalid Sort direction error

When looking at developer tools trace, the API call that fails is passing the following fields

resource,startDate,finishDate,investmentRole,bookingStatus,allocation,requestStatus,allocationCurve,allocationCurve,hasConversations,resources____manager,investments_____internalId,investments____investmentType,_invApiAlias,resources____isTeam,_isFavorite
filter: ((((investments____scheduleFinish > '@@CURRENTDATE@@') and (investments____investmentType in ('project')) and (resources____isRole = true) and (resources____isActive = true)) and ((investments____isActive = true) and (investments____isTemplate = false))) and (investments____name = 'mytest'))
limit: 100
sort: investments____name asc,resource asc,investments____name 1,investments____name 1,investments____name 1
tsvParams: (periods=(allocationCurve,months,11,2023-09-01T00:00:00,fiscal)),(workEffortUnit=fte)

Cause

The view has stored a multicolumn sorting that got corrupted

Resolution

Click on a column name to reset the view ordering to the desired column and resave the view