Filter (empty) not work on the EnumList in the table view

[ronniew]

I have an App with a column that contains a nullable EnumList. When I attempt to filter the data in the table view based on the EnumList column, it does not seem to work properly. However, filtering on a nullable Enum column works correctly.

Note: The data source of My App is RDS for Maria, and both the columns are nullable varchar.

### EnumList and Enum columns have the same configuration：

- searchable & editable, plus

### Filter result 

[WillowMobileSys]

---

@ronniew wrote:

When I attempt to filter the data in the table view based on the EnumList column, it does not seem to work properly

---

What is the problem?  Describe your use case and what it is you are seeing that is not correct.  It will help to shoe the data. show what you are applying as the filter  as well as the result.

I just tried filtering in one of my apps and I am not seeing an issue.

[ronniew]

Apologies for my delayed response. I have an EnumList column in my app that contains empty values. I am currently attempting to locate all the rows with empty values in the table view, based on that column.

Here are some examples:

The column in the table view that contains some empty values:

The filter that I have set:

and the result is no item（however, that column actually contains empty values）:

[WillowMobileSys]

Ah,  I see!   I believe this to be a bug.  Please report it to AppSheet support.

[SkrOYC]

I'm having this same issue, so it's a long standing bug, it happens in both mobile and desktop mode

@devingu @lizlynch 

[541joehill]

I am trying figure out how to HIDE the (empty) option from my app's filtering and this is the only thread I can find related to this. Any updates?

[WillowMobileSys]

You cannot hide values from the AppSheet provided Search filtering.  The list shown is based on ACTUAL values saved across all the rows.   Empty is a VALID value for filtering and omitting it, when there are rows with that value, will cause confusion among the users as there will be rows missed/never shown should they start filtering on that column.

Typically, hiding it means that you wish to always have a value in that column for each row.  If that is the case, then you need to either apply a default value OR make the column entry required.  If you choose to implement one of these these, then also remember to go back to EXISTING rows and update the column with the appropriate value.  Once you do that, then the "empty" value option will disappear from the filtering options.

[JMVF]

This is an important bug which needs to be addressed. The end user doesn't know the difference between an Enum and an Enumlist, so explaining why some table/deck filters work for them and others don't is a pain placed on us by the AppSheet developers.

Additionally, for managers doing quality checks on the database, seeing a returned list of empties in table or deck views is an important part of reviewing if data entry is being skipped or missed.

What makes this worse is there is a "checkbox (empty)" option in the filter window that slides open for enumlist implying to the end user it should be an allowable option to be selected. Terrible UX.

[SkrOYC]

---

@JMVF wrote:

What makes this worse is there is a "checkbox (empty)" option in the filter window that slides open for enumlist implying to the end user it should be an allowable option to be selected

---

Forcing it to be a "Required" field doesn't solve this?

[JMVF]

Thanks for the reply, but not really the point - I shouldn't have to solve this (there's enough workarounds I need to do with chicken wire and duct tape already). 

 If checkbox (empty) is supposed to be a viable filter option for Enumlists in table/deck view, then they should solve the bug - and if it's not, they should solve it by removing it as an option for a user to select.