Filter is correct.
But you don't take into account priority of AND and OR.
It is like priority of * and +.
Operations are executing depending on precedence, not on order you place them
a + b + c * d = a + b + (c * d) (a + b + c) * b
It's the same for AND and OR
a or b or c and d = a or b or (c and d) (a or b or c) and d
You expect the last part, and it's not what you get when you concatanate thje conditions
you must write
a and d or b and d or c and d
I know it's a bit weird and long, but without penrenthesis of conditions, it's the only way to get what you expect.

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]

Hi,

I could not reproduce such issue.
Can you explain which filter you tried and apply ?

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