formcreator icon indicating copy to clipboard operation
formcreator copied to clipboard

WIP: Sync issue automatic action

Open btry opened this issue 3 years ago • 0 comments

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

btry avatar Sep 04 '22 18:09 btry