Advanced filter : delete one entry

Hello,

i would like to submit you one issue (projeqtor 8.5.5) with the advanced filter. I created one in the project menu :



When i click to delete the row "ET type parmi 'Getion d\'un pôle','Maintenance','Projet' ", the result is :



the row "OU nom commence par '20'" has been deleted instead the one chosen. If i click one more time to delete "ET type parmi 'Getion d\'un pôle','Maintenance','Projet' ", the result is fine :

Ok i understand better. I wasn't sure of how it was working, thanks for your answer.

Hi,

just to let you know that i had this error when making another - bad- test with the filter function. In case it could be useful, here it is :

2020-10-08 09:00:30.870 ***** ERROR ***** [V8.5.5] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') order by projectplanningelement.wbsSortable , project.sortOrder' at line 1
2020-10-08 09:00:30.870 ***** ERROR ***** [V8.5.5] For query : select project.id as id, project.name as name, T1.name as nameProjectType, project.projectCode as projectCode, T2.fullName as nameResource, project.idResource as idResource, projectplanningelement.priority as priority,project.idProject as idproject from project left join type as T1 on project.idProjectType = T1.id left join resource as T2 on project.idResource = T2.id left join planningelement as projectplanningelement on (projectplanningelement.refId=project.id and projectplanningelement.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='96') ) and (project.id not in (0) or project.id is null or (project.idUser='96') )) or project.codeType='TMP' ) or (project.idProjectType IN (169, 172, 171))) order by projectplanningelement.wbsSortable , project.sortOrder
2020-10-08 09:00:30.870 ***** ERROR ***** [V8.5.5] Strack trace :
2020-10-08 09:00:30.870 ***** ERROR ***** [V8.5.5] #0 Sql->query called at [/var/www/projeqtor/tool/jsonQuery.php:715]
2020-10-08 09:00:39.835 ***** ERROR ***** [V8.5.5] Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') order by projectplanningelement.wbsSortable , project.sortOrder' at line 1
2020-10-08 09:00:39.835 ***** ERROR ***** [V8.5.5] For query : select project.id as id, project.name as name, T1.name as nameProjectType, project.projectCode as projectCode, T2.fullName as nameResource, project.idResource as idResource, projectplanningelement.priority as priority,project.idProject as idproject from project left join type as T1 on project.idProjectType = T1.id left join resource as T2 on project.idResource = T2.id left join planningelement as projectplanningelement on (projectplanningelement.refId=project.id and projectplanningelement.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='96') ) and (project.id not in (0) or project.id is null or (project.idUser='96') )) or project.codeType='TMP' ) or (project.idProjectType IN (169, 172, 171))) order by projectplanningelement.wbsSortable , project.sortOrder
2020-10-08 09:00:39.835 ***** ERROR ***** [V8.5.5] Strack trace :
2020-10-08 09:00:39.835 ***** ERROR ***** [V8.5.5] #0 Sql->query called at [/var/www/projeqtor/tool/jsonQuery.php:715]

I'm sorry, i don't remember exactly the test. I could try to reproduce it but not sure when