Hi @dgrenier Maybe this plugin can help you: https://plugins.glpi-project.org/#/plugin/localeoverride.

Works with version 9.2.3 of GLPI.

https://github.com/glpi-project/glpi/issues/474

https://github.com/glpi-project/glpi/issues/570

Second part solved: https://github.com/glpi-project/glpi/issues/643#issuecomment-251321765

Right, I think that this table should be better normalized, one table of log per item maybe?

Here's a SQL to get this:

SELECT DISTINCT t.*

FROM glpi_tickets t, glpi_logs l

WHERE t.id = l.items_id and l.itemtype = 'Ticket' and id_search_option = 12 and (old_value >= 6 and new_value < 5) and MONTH(l.date_mod) = 4

The SQL returns tickets that has changed from status 6 (closed) to status <5 (waiting,plan,assign or new) (the 5 value is resolved so i don't consider re-open), in this month (4 = April)

I hope this can help you and this SQL is correctly xD

Regards!

I use this command in the crontab:

php -q -f /var/www/html/glpi/scripts/ldap_mass_sync.php action=1 ldapservers_id=3

I hope it helps you.

But I agree with you in the feature. +1

Ok, sorry, i open an issue on github.

Hi Tomolimo, i'm trying to send the notification but does not reach. Following your instructions i've configured "Can be notified" and "Users" to yes in the group and have assigned "Manager of the group in charge of the ticket" to recipients in the notification. What am I doing wrong?

And, the notification is sended when the user click the save button of the satisfaction survey?

Thank you!

"load a bookmark" must be showed in any screen not only in the filter screen