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
“display”: “Select date”,
I’m not sure the answer to this off the top of my head. But I’m curious why
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.