Post

1 follower Follow
0
Avatar

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 Answered

Please sign in to leave a comment.

1 comment

0
Avatar

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 0 votes
Comment actions Permalink