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.