Request Roles Query use case mentioned based on customproperty39

[Israr]

Hello Team,

Need help in preparing the query based on the customproperty39 if the customproperty39 is null then it should display all the enterprises roles.

Below sample query i have tried.

The query is working fine if the customproperty39 has some value but it is not working if customproperty39 is null please help in below query it should work if customproperty39 is null.

and rl.customproperty1 = ((select users.customproperty39 from Users users where ((users.id={currentUser} and users.customproperty39='XXXXXX') or (users.id={currentUser} and users.customproperty39='XXXXXX'))) or (select users.customproperty39 from Users users where users.id={currentUser} and users.customproperty39 is null))

Thanks!

Regards,

Israr Ahmed M

[rushikeshvartak]

AND (rl.customproperty1 = (SELECT users.customproperty39 FROM Users users WHERE users.id = {currentUser} AND users.customproperty39 IS NOT NULL) OR (SELECT users.customproperty39 FROM Users users WHERE users.id = {currentUser} AND users.customproperty39 IS NULL) IS NULL)