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?
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.
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)
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]
OK,
Notification on Activity-Progress has some issues.
Ticket #10550 recorded