View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Problem with fields Priority and Progress - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Problem with fields Priority and Progress

More
27 Oct 2017 08:06 #1 by kobetsu
In activity form there is section called "Progress" looking more and less like this: [attachement1]

but as you see, in our installation fields "progress" and "priorty" are boolean type (normally they are integer(3)).

What we did... in customization we tried to change int(3) to int(1) and in result field automatically starts to be boolean and we loose any possibility to turn it back.

Please tell me how can we restore int(3) ?


Another questions to this point are:
- can we customize field priority to have not int(3) but just values 0, 1, 2, 3... or even P0, P1, P2, P3 ? How can we do that ?
- can we define 'progress' manually ?

Let me explain our case... we have some tasks which are necessary to monitor on the planing but this tasks are attached to machines (for example converter cluster).
Project is one-shot, means there will be no similar project in a future so we do not want declare garbages like another resourse "VirtualCoverter1" to declare time of the task.

So idea was that we do not report time of this task but from time to time we update field 'progress' to see planing updated.

Problem is, field 'progress' is read-only.

Can you tell me how can we solve this issue in projeqtor ?
Attachments:

Please Connexion or Create an account to join the conversation.

More
27 Oct 2017 09:45 #2 by babynus
Hi,

What we did... in customization we tried to change int(3) to int(1) and in result field automatically starts to be boolean and we loose any possibility to turn it back.

This is an issue we did not see : int(1) should be set only for booleans
We should have locked the possibility to change from int(3) to int(1).
This will be fixed on patch of plugin.
To revert, only possibility is to act directly on the database :
ALTER TABLE `planningelement` CHANGE `priority` `priority` INT(3) UNSIGNED NULL DEFAULT NULL;
You may change to INT(2) but may face an issue as defaut value is 500 : you'll have to define defaut value on every activity type.

- can we customize field priority to have not int(3) but just values 0, 1, 2, 3... or even P0, P1, P2, P3 ? How can we do that ?

This is not possible without coding a restriction.

- can we define 'progress' manually ?

No, not possible on activity : manual progress could not be consolidated on top level to get Project progress.
Only possibility to get the "weight" and "consilidable" progress of activity is work driven management.
Manual progress can be defined on project only (in completion to real progress, work driven)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
27 Oct 2017 17:50 #3 by kobetsu
Thanks for query.

Regarding:

- can we customize field priority to have not int(3) but just values 0, 1, 2, 3... or even P0, P1, P2, P3 ? How can we do that ?

This is not possible without coding a restriction.


You mean, projeqtor code must be changed or using customization/plugins we can achieve this ?

Please Connexion or Create an account to join the conversation.

More
27 Oct 2017 17:53 #4 by babynus

You mean, projeqtor code must be changed or using customization/plugins we can achieve this ?

Needs some coding

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
12 Avr 2018 15:33 #5 by kobetsu
Hello,

I found one issue more which can refers to problem described above.
Of course we appliyed scripts you listed and all practically is working fine except one issue.

When I'm not ADMINISTRATOR and open Activity view column PRIORITY is display as checkboxes:



Similar we had in other placed before we applied your scripts.

Can you tell me how to solve this issue ? (on Administrator account all looks fine).
Attachments:

Please Connexion or Create an account to join the conversation.

More
12 Avr 2018 18:44 #6 by babynus
Each user must clear / refresh the column description for activities : in the column selector, check refresh.
Another way to globally refresh for everyone is to execute Sql Script :
Delete from columnselector where objectClass='Activity'

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.911 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.