hello,
From "Work" / "Activities" screen, I'm using Excel export. The export seems ordered by Id.
I would like having it ordered as displayed on the screen, which means by WBS (it's a more "logical" order, as far as I'm concerned).
Maybe you could do that in a future version if you find it useful ? But if you have time to look at it and know where I could add something like " ORDER BY WBS" in an SQL request in a PHP file, it would be great ! (if not, I will write tomorrow a macro-command in Excel to reorder in Excel like it is ordered in ProjeQtOr window).
Sincerely.
(I hope all my questions today were not too boring ;))
Just define a Filter with attribute=WBS and operator=order...
This will sort list on WBS.
CSV Export respect order in the list...
Hello,
Thank you for your answer. I didn't know about filters and moreover it was not clear for me that the export takes it into account.
But my need seems still there : ordering "WBS ascending" make activities sorted in "numerical" order (like would do an automatic filter in Excel) and not "hierarchical numeric" order (which is the natural order for displaying ProjeQtOr activities, and which would lead me to build a macro in Excel for reordering).
In other words if I'm not clear : my need is that activity 1.10 is between 1.9 and 1.11 and not between 1.1 and 1.2
Another idea ? 😉
Sincerely.
It's righ that sort on WBS on filter is Wrong. 🙁
Issue recorded as Ticket #2537.
A workaround : don't use filter.
Just display the WBS column in the list and click on column header to sort on WBS : this time, order is correct.
And when you export, this order is preserved 👿 👿
Hello,
Great : with the workaround, it does exactly what I expect : WBS "naturally" sorted 🙂
Thank you.