View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - remaining workload changes - ProjeQtOr
 

remaining workload changes

More
29 Aug 2025 11:35 #1 by pdecloedt
Hello,
I'd like to be able to send an event notification when the remaining workload changes. This will alert the project manager of any potential deviations and, if necessary, require validation.
How can this be achieved?

Please Log in or Create an account to join the conversation.

More
01 Sep 2025 13:54 #2 by babynus
Replied by babynus on topic remaining workload changes
I guess you don't want an alerts on remaining workload changes, but on revised workload changes.

Left work (remaining workload) changes every time someone enters real work, so this is very (yes very very) often.
So I think you are interesting on reevaluation of left work that changes the total work (real + left = revised)

There is no alert on all changes.
All you have is an indicator on revised compared to assigned (or compared to validated)
If you use revised compared to assigned and set alert at 110%, you'll get a message when revised = 110% of assigned.
So if you set the indicator at 101%, you'll get an alert when resised is over assigned (of 1%).
But you'll get the alert only once, not on all changes.
You can just set to values : warning (for instance at 1% to highlight any increase) and alert (for instance à 20% when over use becomes unbearable.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
12 Sep 2025 09:07 #3 by pdecloedt
hello thanks you for these explanations.
I would try to create a definition of notification, but  apparently, the notification rule is not understood by ProjeQtor

 
Attachments:

Please Log in or Create an account to join the conversation.

More
14 Sep 2025 14:54 #4 by babynus
Replied by babynus on topic remaining workload changes
Hi,

Notifications are triggered on Date
So in your case, when "Dade de début demandée" is passed.
This date is rarely defined.
So you show try another date as trigger : why not use real start date ? or validated start date( if always defined)
 

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
15 Sep 2025 08:39 #5 by pdecloedt
Hello, I tried to change the trigger date to the actual start date, but apparently the problem comes from the notification rule...


Attachments:

Please Log in or Create an account to join the conversation.

More
15 Sep 2025 08:40 #6 by pdecloedt
logfile:

2025-09-15 08:36:51.713 ***** ERROR ***** [V12.2.2] [3] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<activityplanningelement.plannedWorkplannedWork' at line 1
2025-09-15 08:36:51.713 ***** ERROR ***** [V12.2.2] [3] For query : SELECT planningelement.id AS ActivityPlanningElement_id,planningelement.realStartDate AS ActivityPlanningElement_realStartDate,planningelement.plannedWork AS ActivityPlanningElement_plannedWork,project.name AS Project_name,planningelement.validatedWork AS ActivityPlanningElement_validatedWork,planningelement.leftWork AS ActivityPlanningElement_leftWork,project.idResource AS Project_idResource FROM planningelement LEFT JOIN project ON project.id=planningelement.idProject WHERE activityplanningelement.<activityplanningelement.plannedWorkplannedWork
2025-09-15 08:36:51.713 ***** ERROR ***** [V12.2.2] [3] Strack trace :
2025-09-15 08:36:51.713 ***** ERROR ***** [V12.2.2] [3] #0 Sql->query called at [/var/www/hosted/biouv_group/model/NotificationDefinition.php:997]
2025-09-15 08:36:51.713 ***** ERROR ***** [V12.2.2] [3] #1 NotificationDefinition->getLines called at [/var/www/hosted/biouv_group/model/NotificationDefinition.php:1305]
2025-09-15 08:36:51.713 ***** ERROR ***** [V12.2.2] [3] #2 NotificationDefinition->generateNotifications called at [/var/www/hosted/biouv_group/model/NotificationDefinition.php:441]
2025-09-15 08:36:51.713 ***** ERROR ***** [V12.2.2] [3] #3 NotificationDefinition->save called at [/var/www/hosted/biouv_group/tool/saveObject.php:127]

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.465 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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