[SOLVED] Problem to diplay "is subproject of"

Hi all

I detected one issue when I want to display the column "is sub project of" on project tab, any project are displayed. Do you have the same behavior?

It was tested on mozilla and Chrome, same problem.

Thanks.

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.