CZQL Query not returning expected results

Hello,

I have a the following CZQL query

SELECT @Name
FROM PROJECT
WHERE C_SubDomain Not IN ('Val1', 'Val2')

This request doesn't return projects where C_SubDomain value in not defined. C_SubDomain is a Pick List custom field.

How can I fix the request to return all projects with C_SubDomain different from 'Val1' and 'Val2' (including empty values)?

Thank you very much

Armand BOLMONT October 17, 2017 08:12 Answered

Please sign in to leave a comment.

I found a workaround with the following request:

SELECT @Name
FROM PROJECT
WHERE C_SubDomain Not IN ('Val1', 'Val2') OR C_SubDomain=null

Is this the only way to do that?

Thank you

Armand BOLMONT October 17, 2017 08:24 0 votes