Forum

remaining workload ...
 
Notifications
Retirer tout

remaining workload changes

7 Posts
2 Utilisateurs
0 Reactions
1,858 Vu
(@pdecloedt)
Posts: 165
Reputable Member
Début du sujet
 
[#9922]

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?


 
Posté : 29/08/2025 1:35 pm
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 01/09/2025 3:54 pm
(@pdecloedt)
Posts: 165
Reputable Member
Début du sujet
 

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

 


 
Posté : 12/09/2025 11:07 am
(@babynus)
Posts: 14952
Membre Admin
 

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)
 


 
Posté : 14/09/2025 4:54 pm
(@pdecloedt)
Posts: 165
Reputable Member
Début du sujet
 

Hello, I tried to change the trigger date to the actual start date, but apparently the problem comes from the notification rule...


 
Posté : 15/09/2025 10:39 am
(@pdecloedt)
Posts: 165
Reputable Member
Début du sujet
 

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.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]


 
Posté : 15/09/2025 10:40 am
(@babynus)
Posts: 14952
Membre Admin
 

OK,
Notification on Activity-Progress has some issues.
Ticket #10550 recorded


 
Posté : 16/09/2025 4:49 pm
Share:
Retour en haut