formcreator
formcreator copied to clipboard
WIP: Sync issue automatic action
if a ticket has several valodators, the sync issue fails to recreate the row the HAVING COUNT() clause finds 2 rows instead of 1 The solution is to drop the validator user and validator group and find them dynamically with JOIN. this also allows to find all ticket validators
Changes description
Remove users_id_validator and groups_id_validator from the issues table. As side effect, this allows to get several validators from a ticket, and (starting from GLPI 10.1) several validator groups from a ticket.
Checklist
Please check if your PR fulfills the following specifications:
- [ ] Tests for the changes have been added
- [ ] Docs have been added/updated
References
Closes #N/A