Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[Project'OR RIA v3....
 
Notifications
Clear all

[Project'OR RIA v3.4.4]Several identical rows in the CSV export on tickets

3 Posts
2 Users
0 Reactions
6,055 Views
(@campsy)
Posts: 23
Active Member
Topic starter
 
[#1733]

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 ?


 
Posted : 31 Mar 2014 11H33
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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.


 
Posted : 31 Mar 2014 15H35
(@campsy)
Posts: 23
Active Member
Topic starter
 

Hello,

With the query , there actually has duplicate lines.

I will purge priority lines with realwork = 0 and done = 0 and 0 = idle

thanks


 
Posted : 31 Mar 2014 18H11
Share:

Scroll to Top