Hierarchy Ordering

Question

Hi Team,

Im using OAC and building hierarchy like below

I need to sort the above order to below

ROOM DEPARTMENT

OTHER OPERATING DEPARTMENTS(OOD)

F&B DEPARTMENT

Is it possible to sort the order or control the order of the nodes in OAC?

Regards

[Deleted User] · Accepted Answer

Hi @GTA

You have to define a Sort Order column in the RPD which holds that sequence.

In your case you'd have a sort order column which yields

0 for ROOM DEPARTMENT

1 for OTHER OPERATING DEPARTMENTS(OOD)

2 for F&B DEPARTMENT

…and so on. You can create the corresponding CASE WHEN in a new logical column as the column formula and then use said column as the sort order column for your display column.