How Does Modern Project Task Board (Kanban) View Sort Work?

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

What is the default sort order in the Board views of the Modern UX?
Was there a change in 16.1.1?

Resolution

This has been resolved in 16.1.2.

 

Prior to 16.1.1, the sorting is done by "position" value.

A sample REST Call that is made while fetching a Board view is as below. Bolded text is the relevant part about the sorting question.

http://some_server/ppm/rest/v1/private/views/5124831?expand=(listColumns=(limit=500,sort=(position+asc),fields=(name,position,isSelected,metadataURL,pinned,sortOrder,sortPosition,width,groupType,isGrouped,layout)),viewSettings=(limit=200,fields=(layout,name,value,classifier)),viewTargets=(limit=500,fields=(attribute,position)))

The position value is determined from the odf_item_position table. You can determine which columns are in which position by running a query like the one below. The name of the attribute being used to form the columns of the Board will have to be provided.

SELECT
    ii.name item_name,
    ii.id item_id,
    oip.position item_position,
    cl.lookup_code board_columns,
    opd.name board_column_attributes
FROM
    odf_item_positions oip
    JOIN inv_investments ii ON ii.id = oip.instance_id
    JOIN odf_picklist_contexts opc ON opc.id = oip.context_id
    JOIN odf_picklist_defs opd ON opd.id = oip.picklist_def_id
    JOIN cmn_lookups cl ON cl.id = oip.lookup_id
WHERE
        oip.object_code = 'project'
    AND
        opd.name = 'Status'
ORDER BY
    cl.lookup_code,
    oip.position;

Additional Information

Starting in 16.1.1, the sorting has changed.

STEPS TO REPRODUCE:

1. Enable browser Developer Tools

2.Go to Modern Workspace> Projects > Project > Tasks > Board View

3.Check Developer Tools >Payload

4.Compare Payload info with what appears in the Board View.

Expected: The Sorting selected in View Options should work.

Actual: The Sorting is not obvious and does not match the Developer Tools > Payload

Although the browser developer tool shows the sort, it does not reflect in the Board view

This is reported as DE69232 and is working by design.
The sorting column selected will place nulls first.