Database View Table Where Clause to contain NULL

mike_bush · ‎03-28-2016

I want to improve my DB View performance by including a null test in a where clause (rather than let hundreds more records through and have to include the condition in every report I write).

Syntax for where clause doesn't SEEM to support this - neither

field != ''

nor

field = NULL

seem to work?

Has anyone managed to get a null test into a View Table Where Clause?

tony_barratt · ‎03-28-2016

Hi Mike,

If anyone has found a way to work a null test into a database view where clause, I do not see this mentioned in the ServiceNow Community.

Adding a report on the db view has been mentioned as a workaround but you are already doing that.

The possibility of using a before query business rule is mentioned here:

http://www.snc-blog.com/2014/08/07/a-view-on-database-views/

I have not tried this, and it might or might not improve performance.

Best Regards

Tony

View solution in original post

joey_mart · ‎05-29-2020

I've created PRB1407205 in HI for this. We'll support the "ISNULL" operator starting in the Quebec release.

Maybe way too late to actually help anyone, but it'll be there.

joey_mart · ‎05-29-2020

You'll be able to do something like:

taskslatable_task = inc_sys_id && inc_assigned_to ISNULL

xitso · ‎08-12-2021

@joey.mart is there also OOtB for ISNOTNULL?