Is it possible to include the "none" entries from the datasource while using date filter

while working on a report I wanted to include data source entries using received_on field that is selected using filter date type.
In the result I wanted to include the None Entries from received_on field from this data source too.

Here is the filter
{
“compare_as_string”: false,
“datatype”: “date”,
“required”: false,
“display”: “Select date”,
“field”: “received_on”,
“type”: “date”,
“slug”: “date_selector”
}

I’m not sure the answer to this off the top of my head. But I’m curious why received_on is None? That should not generally ever happen.

hi @czue , I shouldn’t have named a date field in the data source received_on.It is not the form`s default (received_on) field .This field is populated by date data if a form mate a condition, if not its null.

Here is more clarification.

How can I add a filter for a date type data source column, that will filter from a selected date range and also include the None fields on the result returned?

@andyasne Are you looking for a filter that would be equivalent to the following SQL:

select * from ucr_table
where date_column BETWEEN begin_date AND end_date OR date_column IS NULL

That is not currently possible with report configurations.

1 Like