'Not Empty' filter still showing (empty) values

steveturley
Tera Guru

Hi. I'm try to filter in the 'Time Worked' table as I have some 'empty' values. However when I try to exclude these it still leaves some in - see screenshot below - why is this?

 

steveturley_0-1669206728723.png

 

1 ACCEPTED SOLUTION

Gunjan Kiratkar
Kilo Patron
Kilo Patron

Hi @steveturley ,

That might not be empty. just click on any empty string and show matching. You will get an sysId of that user record their. Actually users are missing here and because of that it is showing empty. but at the backend it has sysid of user record.


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

View solution in original post

4 REPLIES 4

Gunjan Kiratkar
Kilo Patron
Kilo Patron

Hi @steveturley ,

That might not be empty. just click on any empty string and show matching. You will get an sysId of that user record their. Actually users are missing here and because of that it is showing empty. but at the backend it has sysid of user record.


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

That's what it was. It's because of domain separation.Thanks

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

If you wan to exclude user who are empty please use the below:-

 

Saurav11_0-1669207573858.png

 

It should give you all the record which does not have the user as empty:-

 

Saurav11_1-1669207617834.png

 

Please mark my answer as correct based on Impact.

 

Community Alums
Not applicable

Hi @steveturley

Filter seem to be correct, so try to logout and re-login.

 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.