How to search for a property that is *not* null

Help
1

What I’m trying to do

Find properties with a value ie not empty.

Things I have tried

regex, plain. It treats null as a word so it matches ["Property":nu] !

2

I think it’s like that :
-["Property":null] ["Property"]
The first indicate that the property must not be empty, and the second that the property exist. This combination should show what you’re looking for.

2 Likes
3

I think to find properties that have values (i.e., not empty), use filters that exclude null or empty entries. Ensure your method or tool checks for properties that are not blank or null. This will help you focus only on properties with actual content. Adjust the filter based on the specific platform or tool you are using.

4

Hi @johnsteve111

Can you give an alternative to Anwen’s suggestion above?

5

Thanks everyone.

6

An alternative to Anwen’s suggestion is to use default values or placeholders when properties are empty or null. This way, even if a property doesn’t have a value, it won’t be empty or blank.

You can set a default value that makes sense for your context, and later filter out these defaults if needed. This method ensures that all properties are filled and makes it easier to handle missing data.