View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Problem with excel export on sorted wbs - ProjeQtOr
 
 

[SOLVED] Problem with excel export on sorted wbs

More
27 Jan 2016 10:21 #1 by El Wallos
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.

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

More
27 Jan 2016 18:03 #2 by babynus
Cannot reproduce on V5.2.2.
Try with this version.

Babynus
Administrator of ProjeQtOr web site

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

More
29 Jan 2016 13:33 #3 by El Wallos
I tried with version 5.2.2 and it works fine.

Thanks

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

Moderators: babynusprotion
Time to create page: 0.030 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.