[Bug]: Dropdown containing `null` will not load about evidence

[archiewood]

what's the intended behaviour here?

throw an error?

or allow the user to have null as a pickable option?

[hughess]

I could see both being helpful for different situations:

1. legitimate nulls - you want to filter a chart to see a null series, where a value was not set for some group of data
   • In this case want nulls to appear (ideally without having to convert to string)
2. Illegitimate nulls - null sneaks into your dropdown
   • In this case would want an error
   • Or would want the dropdown to automatically exclude nulls

I think including nulls is probably not possible with the current inputs setup - if it was in a string column, you’d have to wrap the input in single quotes in your sql, and then the nulls wouldn’t match

[andrejohansson]

I just had troubles with null, and we have a legitimate case where I want null to be one of the selectable options. I also stubled on some issues with the query but AI explained very well to me why I was wrong.

I would want to be able to have null as a value in a combobox (preferable with a human readable label) and that the filter gets created in the correct way:

WHERE (field is null OR field IN (1,2,3,4))