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.

[SOLVED] Problem wi...
 
Notifications
Clear all

[SOLVED] Problem with excel export on sorted wbs

3 Posts
2 Users
0 Reactions
3,123 Views
Martin
(@el-wallos)
Posts: 220
Active Member
Topic starter
 
[#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.


 
Posted : 27 Jan 2016 12H21
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 27 Jan 2016 20H03
Martin
(@el-wallos)
Posts: 220
Active Member
Topic starter
 

I tried with version 5.2.2 and it works fine.

Thanks


 
Posted : 29 Jan 2016 15H33
Share:

Scroll to Top