I would like to be able to create project types and milestones that can be accesses by all, is there a trick to do this ? perhapse some mods to the db contents at the sql level ?
many thanks
Julian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, you can do it via SQL. First create the milestones and project types via UI. Then go into database via command line interface, issue these queries:
1) select MILESTONE_SET_ID from FDDPMA_MILESTONE_SET where MILESTONE_SET_NAME = 'My milestones'
This will give you the identifier of your milestone set
2) update FDDPMA_MILESTONE_SET set CREATOR_ID = null where MILESTONE_SET_ID = ?
Here replace ? with the identifier from step 1.
3) select PROJECT_TYPE_ID from FDDPMA_PROJECT_TYPE where PROJECT_TYPE_NAME = 'My type'
This will give you the identifier of your project type
4) update FDDPMA_PROJECT_TYPE set USER_ID = null where PROJECT_TYPE_ID = 190999786
Here replace ? with the identifier from step 3.
Restart FDDPMA and the above milestones and project type will become public and read-only.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I would like to be able to create project types and milestones that can be accesses by all, is there a trick to do this ? perhapse some mods to the db contents at the sql level ?
many thanks
Julian
Yes, you can do it via SQL. First create the milestones and project types via UI. Then go into database via command line interface, issue these queries:
1) select MILESTONE_SET_ID from FDDPMA_MILESTONE_SET where MILESTONE_SET_NAME = 'My milestones'
This will give you the identifier of your milestone set
2) update FDDPMA_MILESTONE_SET set CREATOR_ID = null where MILESTONE_SET_ID = ?
Here replace ? with the identifier from step 1.
3) select PROJECT_TYPE_ID from FDDPMA_PROJECT_TYPE where PROJECT_TYPE_NAME = 'My type'
This will give you the identifier of your project type
4) update FDDPMA_PROJECT_TYPE set USER_ID = null where PROJECT_TYPE_ID = 190999786
Here replace ? with the identifier from step 3.
Restart FDDPMA and the above milestones and project type will become public and read-only.
Great that worked :)