View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [Project'OR RIA v3.4.4]Several identical rows in the CSV export on tickets - ProjeQtOr
 
 

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

More
31 Mar 2014 09:33 #1 by campsy
[Project'OR RIA v3.4.4]Several identical rows in the CSV export on tickets was created by campsy
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 ?

Please Log in or Create an account to join the conversation.

More
31 Mar 2014 13:35 #2 by babynus
Replied by babynus on topic [Project'OR RIA v3.4.4]Several identical rows in the CSV export on tickets
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.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
31 Mar 2014 16:11 #3 by campsy
Replied by campsy on topic [Project'OR RIA v3.4.4]Several identical rows in the CSV export on tickets
Hello,

With the query , there actually has duplicate lines.

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

thanks

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.034 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form