Column filter not working

Phong_Lam1 · 01-09-2022 10:57 PM

Hi all, I could not filter on [Industry] column, It is Enumlist type. For Example if I filter It by “QSR” have no result, but when I search QSR show up the results…,Is it a bug ? thanks

WillowMobileSys

Check the Industry column and make sure its Searchable property is turned on.

Phong_Lam1

It’s turned on (can be searched), but I dont know why I could not filter it

WillowMobileSys

Is it a REF column?

Phong_Lam1

Yes, It is Enumlist ,type ref with table industry

WillowMobileSys

Unfortunately, you can’t use Label values to try to filter a REF column. REF columns actually store the Key values. You can search by those Key values but that doesn’t really doa User any good.

What I do in these cases is add another column that actually contains the Label values and give it a Display name the same as the REF column and change the table view to this Display only column. Then users can search by the Label value.

Phong_Lam1

Actually there have other columns in the same table that is ref view and can use filter function. So even if ref column store data as key value, you can still search by label value ( I tested and It’s worked)

Sorry I dont understand it ? Do you mean to create a Virtual column (use lookup fomula to label value , But when we do that, on the filter view there will have 2 industry column (one ref and one VC) ?

WillowMobileSys

Oh, then maybe this was changed or I did something wrong before.

Never mind. If REF columns are showing the Label values as expected then this approach is not needed.