Redmine

Forgot to mention that we have 1.0.1 Redmine

The projects are ordered in the DB in a nested set and read according to this nested set so that the tree can be rebuilt "easily", that amounts to projects of the same branch at the same level are roughly ordered in creation date order (well, last move time to be precise).

I found such fields in "Projects" table of Redmine database: "lft" and "rgt". So I suppose that these values influence to the order of Projects, but I dont understand the logic of it, because I didn't find any relation to the creation date as u said. And it seems like these values "lft" and "rgt" are modified every time new project is created...

Is there any solution to manage the view of projects without working with database directly?

The lft, rgt and root_id columns are for the already mentioned nested set, there's a good explanation on wikipedia you can read if you want more information on that. The projects are then loaded ordered by the lft column and the tree is rebuilt from there.

Ok, but the question is still open - how to modify the tree of projects? The modification of database everytime new project is created is not the solution...

As you already have discovered there is no way in stock redmine to rearrange them. If you really need it, it could probably be done by a plugin though.

Which one plugin?

I said one could be made, not that one existed.

Hello!

I have same "Problem".

If change on database lft order ? this is dangerous ?
What will be the consequence ?

Sorry for my very bad English ^^

Thank you,

Stéphane Atlani wrote:

If change on database lft order ? this is dangerous ?
What will be the consequence ?

If not done properly, it will make the nested set the projects are in inconsistent, effectively destroying your project hierarchy.

By "not done properly", I mean "without a proper understanding of what a nested set is", which seems to be your case as changing the order in the nested set would require changing the lft and rgt fields of a project, as well as those of all the projects underneath it.

Ok thank you.

I'll wait ;)

Hi guys,

I'm using Redmine 1.0.1.stable.70 with MySQL, and I'm having some problems with the Projects view. The projects are not correctly nested (see attached image).

I checked lft and rgt, and they seems right:

mysql> SELECT name,id,lft,rgt FROM `projects` WHERE (projects.status=1);
-----------------------+------+------+ | name | id | lft | rgt |
-----------------------+------+------+ | Proyecto 1 | 7 | 13 | 26 | | Proyecto 111 | 18 | 15 | 16 | | Proyecto 12 | 17 | 20 | 25 | | Proyecto 11 | 16 | 14 | 19 | | Proyecto 112 | 19 | 17 | 18 | | Proyecto 121 | 20 | 21 | 22 | | Proyecto 122 | 21 | 23 | 24 |
-----------------------+------+------+
15 rows in set (0.00 sec)

I didn't see in the Redmine 1.0.2 changelog any related and fixed issue, so I have not yet updated Redmine.

Any help would be appreciated. Thanks

Juan Álvarez

Sorry, that happened to me for not using the preview...

mysql> SELECT name,id,lft,rgt FROM `projects` WHERE (projects.status=1);

Thanks again

Juan Álvarez

Please open a new bug report for that, I can't seem to find anything bad with the data you have provided, and if it really is a bug, it should be on the tracker.

Solved. It was a plugin related problem.

Thanks for your support.

Juan Álvarez