Forum

[SOLVED] Problem wi...
 
Notifications
Retirer tout

[SOLVED] Problem with excel export on sorted wbs

3 Posts
2 Utilisateurs
0 Reactions
3,105 Vu
Martin
(@el-wallos)
Posts: 220
Active Member
Début du sujet
 
[#2970]

Hi

When I want to export to csv with wbs as sorted column, no data is displayed on the output.

I attach the log:

2016-01-27 10:15:01.234 ** ERROR ** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'wbsSortable' in order clause is ambiguous
2016-01-27 10:15:01.234 ** ERROR ** For query : select project.id as id, project.name as name, project.idResource as idResource, project.idUser as idUser, project.idStatus as idStatus, planningelement.plannedStartDate as plannedStartDate, planningelement.validatedEndDate as validatedEndDate, planningelement.plannedEndDate as plannedEndDate, planningelement.validatedDuration as validatedDuration, planningelement.plannedDuration as plannedDuration, planningelement.validatedWork as validatedWork, planningelement.assignedWork as assignedWork, planningelement.realWork as realWork, planningelement.progress as progress from project left join planningelement as T1 on ( T1.refType='Project' and T1.refId = project.id ) left join planningelement on project.id = planningelement.refId and planningelement.refType='Project' where project.idle=0 and ( (project.id not in (0) or project.id is null ) and (project.id not in (0) or project.id is null or (project.idResource='7') ) and (project.id not in (0) or project.id is null or (project.idUser='7') ) or project.codeType='TMP' ) and (project.idProject IN (22, 181, 186, 182, 185, 183, 184, 23, 24, 108, 115, 26, 27, 28, 29, 218, 221, 223, 30, 31, 202, 32, 33, 34, 35, 36, 37, 273, 38, 39, 40, 41, 42, 43, 44, 197, 219, 45, 75)) order by wbsSortable asc, T1.wbs asc, project.sortOrder
2016-01-27 10:15:01.234 ** ERROR ** Strack trace :
2016-01-27 10:15:01.234 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonQuery.php:493]
2016-01-27 10:15:01.234 ** ERROR ** #1 include called at [/var/www/html/projeqtor/view/print.php:172]

I think it is the same problem as "is subproject of", the column is ambiguous.

Could you help me?

Thanks.


 
Posté : 27 Jan PM 12:011
(@babynus)
Posts: 14952
Membre Admin
 

Cannot reproduce on V5.2.2.
Try with this version.


 
Posté : 27 Jan PM 20:011
Martin
(@el-wallos)
Posts: 220
Active Member
Début du sujet
 

I tried with version 5.2.2 and it works fine.

Thanks


 
Posté : 29 Jan PM 15:011
Share:
Retour en haut