Issure confirmed.
Recorded as Ticket #1942

Same pb on my installation.
If 'is subproject of' selected, no project are displayed on project screen.

Hi Babynus,

I attach the error on the log.

2016-01-20 13:39:53.743 ** ERROR ** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'codeType' in where clause is ambiguous
2016-01-20 13:39:53.743 ** ERROR ** For query : select project.id as id, project.name as name, convert(concat(T1.sortOrder,'#split#',T1.name,'#split#',COALESCE(T1.color,'')) using utf8) as colorNameStatus, projectplanningelement.progress as progress, projectplanningelement.plannedEndDate as plannedEndDate, convert(concat(T2.sortOrder,'#split#',T2.name,'#split#',COALESCE(T2.color,'')) using utf8) as colorNameProject, T3.fullName as nameResource, project.idResource, projectplanningelement.assignedWork as assignedWork, projectplanningelement.realWork as realWork, projectplanningelement.priority as priority,project.idProject as idproject from project left join status as T1 on project.idStatus = T1.id left join planningelement as projectplanningelement on (projectplanningelement.refId=project.id and projectplanningelement.refType='Project') left join project as T2 on project.idProject = T2.id left join resource as T3 on project.idResource = T3.id left join planningelement as T4 on ( T4.refType='Project' and T4.refId = project.id ) 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 codeType='TMP' ) and T4.priority '500' order by projectplanningelement.wbsSortable , project.sortOrder
2016-01-20 13:39:53.744 ** ERROR ** Strack trace :
2016-01-20 13:39:53.744 ** ERROR ** #0 Sql->query called at [/var/www/html/projeqtor/tool/jsonQuery.php:493]

Hope it helps you to solve it. 🙂

Hi

Thanks for the log.
I got it as I could reproduce.
Thanks anyway.

Fixed.
Fix is to replace in lines 143 and 170 (2 times) in /tool/jsonQuery.php

$queryWhere.= " or codeType='TMP' ";

with

$queryWhere.= " or $table.codeType='TMP' ";

Thanks Babynus, the issue was solved with this workaround.