Clarity

Hi all,

we have a GEL script that go to another system and get new tasks and then create them in Clarity.  Everything is sorted in order but when we get to the GANT chart, they are not in the order specified.

we've tried the orderID in XML but that seem to changed after XOG out a few projects.

Anyone ran into the same issue and have a solution? We're on 14.2.

Thanks,

TaiN

Not sure ; but does outlineLevel perhaps also need to be populated?

Also some discussion here ; RE: Loading WBS via XOG

The orderId can change for sure, the important part is that the order for all tasks in the project are ranked in order (lowest values at the top, highest values at the bottom) and values are not reused.  Think of it like a 'row number' in the project.

Gaps can appear in the sequence, and you shouldn't assume that once a value is assigned it will retain that same value (so you have to be flexible to deal with that), but otherwise I wouldn't expect any issues with how the tasks appear on the gantt - it would use that same value in the database (prtask.prwbssequence and it's corresponding depth value from prtask.prwbslevel) to position and indent the tasks accordingly.

Hi Nick,

Can I sort my task by setting the prtask.prwbssequence to the order that I want is this a unique ID being set by Clarity?  If I set it to a random number according to my liking is Clarity going to throw an error if the number already exists?

Thanks,

Tai

If you mean directly make those changes in the database, then no you cannot just set that.  Also I don't get why you would want to randomize it (unless you wanted to randomize the order of tasks in the project).  It isn't a unique ID but a row number (however you don't want more than one thing on the same row, so the numbers should be unique from that standpoint).

Changing them directly will probably break things though, as in the database side of things there is more to it than that.  You can just query these values to make sure the order that they are being brought in or updated via XOG does result in the correct outcome.

The query in the GEL script parsed out the right order, but once the tasks goes to GANT it is re-sorted by “WBS Sort” either Ascending or Descending order which doesn’t help much.

Thanks,

Tai

the tasks that we are trying to re-order has the same outlineLevel.

xog xml file order:

outlineLevel6- task canc

outlineLevel6 - task disc

outlineLevel 6 -task call

order we want:

outlineLevel 6 -task call

outlineLevel6- task canc

outlineLevel6 - task disc

beside the level and sequence is there anything else that can be used to order tasks in the same level?

Just an update.  We were able to order tasks in the GANT chart with the combination of orderID and nextSiblingOf.

Thanks for the input as always folks.

Tai