Null values using elasticsearch


#1

Hey community i have some problems filtering values with nulls, i have some null values in mi data but when i try to filter by that value i’m getting a NO DATA message.


#2

Hey @dani can i see your code, i need that for give you a better response, but, just in case, when constructing a filter object to filter null values, you should construct it as the example below:

let filter183= cf.Filter('pickup_census_tract')
	.label('pickup_census_tract')
	.operation('IN')
	.value([null]);

Using the null as a null not in strings like 'null' or 'NULL'


#3

Hey @emoya you have the reason, after take a look at filter generation code an put some breakpoint there i saw that the filters are coming with a String 'null' but this is coming with the data, the data have that format with a string