Question

How do you get the records of a specified fields which are not null in servicenow?

Answer 1

addNotNullQuery(String fieldName) can be used.
Example: To get all the records where ‘name’ is not null.
addNotNullQuery(‘name’);