Null Field as a Report Condition

JBrians · ‎12-11-2023

I'm trying to create a report that shows tasks when a certain field is blank. However, when I use the operator "is", it's not allowing me to leave the Value field blank. It's making me choose the four options we have.

I tried using the operator "is not one of" and selecting all four options, but it still did not work.

I know there are two tasks where this field is blank and should be showing up on the report, but am confused as to why they are not when using those conditions.

When I filter for these in the normal List view, right click and select Bar Graph, it creates the Bar Graph. Then I changed the report Type to List view, and the condition operator shows "is" and the value field is blank. Why is the Value field blank when I create it this way, but not manually creating the report?

Thanks,

Jim

AndersBGS · ‎12-13-2023

Hi @JBrians ,

According to the table dmn_demand is it the the field type your looking at? If yes, then the blank option should not be avilable OOTB, hence it will neither be available to say that it should be blank:

Below is from the sys_choice table where choice option is gathered:

Also, according to your statement "I also tried using "is not one of", then it will not work. this is due to when mention in a report "is not on of", ServiceNow will say that then it should be something else (NOT blank).

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

AshishKM · ‎12-11-2023

Hi @JBrians ,

Can you please share the screen shot of report with filter condition.

-Thanks,

AshishKMishra

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

JBrians · ‎12-12-2023

AndersBGS · ‎12-11-2023

HI @JBrians ,

Please notice that you should utilize the condition:

If you select the operator e.g.

Then ServiceNow sees it as it should be filled with something else than you have mentioned.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

JBrians · ‎12-12-2023

Hi Anders, I don't have the "is empty" option to choose from.

I also tried using "is not one of" and selecting all available options assuming that the report would show the items with blank fields.