Does anyone know how to search for null or empty values in web reports. There are several fields that have no values that we would like to remove from a report and building a query with the list of items we want to include would be tedious. Any thoughts? We have tried using the word null and but no luck.
Are the fields/properties in question custom? What are they returning back that corresponds to ‘no value’? Typically, when a property does not return any value, we see <none>
(which you can filter out fairly easily using that term), or might be an empty return, in chich case you can filter those as well with something like:
(note that there’s no actual text or value in the text box following ‘is not’).
Aram,
Thanks! That totally worked. We wanted to filter out content that had a category of blank but using the AND category is not and leaving the field blank it removed the entries with no category. Thanks so much, you just saved us a ton of paperwork.