Notifications
Retirer tout
Submit issues
3
Posts
2
Utilisateurs
0
Reactions
6,037
Vu
Début du sujet
Hello,
When using the function to export a CSV in the view tickets .
The resulting file contains all the tickets but they appear several times on different lines.
Database is correct , the problem only appears on the ticket created since the update that you select one or more projects.
Could you help me to solve this issue ?
Posté : 31 Mar AM 11:033
Could you check for duplicates in table workelement ?
Try
select refType, refId, count(*) from workelement group by refType, refId having count(*) >1;
If the query returns lines, then you have duplicates you should purge.
Posté : 31 Mar PM 15:033
Début du sujet
Hello,
With the query , there actually has duplicate lines.
I will purge priority lines with realwork = 0 and done = 0 and 0 = idle
thanks
Posté : 31 Mar PM 18:033