Hi,

Thanks for your encouraging comments.

Your visibility issue is linked to several access right controls :

- by default 'administrator' has visibility to all projects
- by default 'project leader' has visibility to 'own projects' : this means he only sees data of projects he is affected to.
=> in most cases, users must be affected to a project to see Gantt Chart for this projets

- when selecting a project in the 'Project' select combo box (on top left of the screen), all the data is filtered on this project : only data on this project is visible
- the selection on this 'Project' does not affect Reports : on reports all projects are displayed (if visible by user), and can be filtered on projects thanks to Report parameter (if available)
=> Gantt visibility on reports and planning may be different

- testing your cases, I noticed a bug : for new users "all projects" is displayed by defaut, but in fact it is not correctly selected, and no project is displayed.
- Ticket #445 registered
=> just manually select "all projects" and visibility will become correct.

Regards.
Babynus.

Hi Babynus,

Thanks a lot for your quick response.
But here are some details :

I have a login as 'administrator' (different as 'admin/admin'), using to set parameters and create users...
I have another login as 'project leader', using to work daily on my projects.
As project leader, I created 8 projects, 0 activities, 2 tickets, 3 milestones, all assigned to myself as resource, since 1st of october.

Login as 'administrator', it's work fine now when select 'all projects' in the 'Project' select combo box.
Reports works also fine.

Login as 'project leader' :
1) on planning view, nothing displayed, even when selecting a project or 'all projects' in the 'Project' select combo box.

2) on report view, 2 reports don't work :
- Reports > Planning > Gantt => 'No data to display on this report' will appears, even selecting a project.
- Reports > Planning > Work synthesis per activity => 'No data to display on this report' will appears.
- all of others reports works fine.

Is something wrong or missing in my data ?

Regards,
Fred

Is your "Project Leader" affected to Projects ?
(see affectation screen)

The project Leader should only have visibility to data of projects he is affected to.

Yes, the project leader is affected to all 8 projects. He has visibility on all projects, and activities depending of these projects.

All reports are working fine, except these 2 (gantt and work synthesis) and planning view

The project leader is also a resource, because he works on activities.
1) he creates the activities of the projects,
2) then, he works to complete these activities, created by himself (as project leader).

Is that process allowed ? correct ?

All seems correct.
I will investigate.
Maybe I'll return to you if I need precisions.

Hi,

First, as a new member, I want to congratulate you for Project'Or !

I've got the same problem as "fredparis", so if you've got an answer, I'm very interesting...

I use Project'Or V1.7.2.

Hi,

Really, I cannot reproduce your issue.
I've tried several databases and all is ok for me : project leader can access to Gantt planning.

I also tried to reproduce your case :
- started from empty database
- connect with admin
- create 1 user : projectleader, profile Project Leader, also a resource called "Project Leader"
- updated data access so that projectleader can create project : defined right as creator+ to Project screen for profile Project Leader
- updated data access so that projectleader can create affectations to projects he is not affected to (to be able to self affect) : define right as manager+ to Affectation screen for profile Project Leader
- disconnect
- connect as projectleader
- create 8 projects Project1 to Project8
- affect Project Leader to the 8 projects
- disconnect and reconnect projectleader to retrieve correct acces rights to the new projects
- see gannt chant : 8 projects are displayed
- create 2 tickets (ticket1 and ticket2) and 3 milestones : milestone1 to milestone3 on project project1
- see gannt chant : 8 projects and 3 milestones are displayed

All is OK for me.
I uploaded some databases exports so that you can test :
- http://projectorria.toolware.fr/files/projectorria_v17.sql : some existing default data I use to generate manual screenshots
- http://projectorria.toolware.fr/files/projectorria_test.sql : result of upper tests
Maybe you can try and import it to test :
- use phpmyadmin
- create emty database
- import file into this new database
- change pamareters.php file to point out to this database

If you still reproduce the issue on your database, please profide as much data as possible :
- print screen for gantt view, affectations, users, activities
- maybe, if your database does not include confidential data, you can send an export of the databse
Send this to support@toolware.fr

Thanks.

Hi,

the problem seems to come from the sql request. Here is the log :

Erreur SQL : Champ 'PlanningElement.idProject' inconnu dans where clause

select planningelement.* from planningelement where planningelement.idle=0 and PlanningElement.idProject in (6, 7, 9, 10) and planningelement.idProject in (0, 2, 3, 4, 5, 6, 7, 9, 8, 10) order by planningelement.wbsSortable

The name of the table is "PlanningElement" instead of "planningelement".

The same request works on windows platform but not on linux platform cause the tables names are case sensitive on Linux and not on windows ( http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html )

Regards,
Jul

Many thanks Jul for your accurate analysis.

Issue is now fixed an will soon be deployed.

For information, to fix it, just replace :

$queryWhere.=getAccesResctictionClause('Activity',$objectClass);

with

$queryWhere.=getAccesResctictionClause('Activity',$table);

in
/tool/jsonPlanning.php
/report/costPlan.php
/report/workPlan.php

Regards.

thanks for your quick answer ! Now, everything works...

Best regards

Hi Babynus, hi Jul,

I have juste uploaded the 1.8.3 version on my laptop under WAMP with Win XP.

It works fine now :
- all profiles (admin, project leader, user) can see the Gantt planning.
- before, it was just allowed to admin profile.

I will test this new version on my web hosting space (under Linux), but I'm shure it is now fixed !
=> yes, it is ! (verified a few hours later, at home)

Thanks to Jul for his analysis.
Thanks to you, Babynus, for this new version.

Regards,