Glide list field sort by in list view

[ericgilmore]

I've added a glide list field using the Form Designer to a table/form. It references cmn_department and seems to work as expected. The only issue I can't seem to overcome is when I put the field in a report or show it in a list I can't sort by the list field.

Even though on the report side I can add a sort, and I can select the list field, it doesn't sort. On a list view of the table, I can't sort by the list field and I can't filter by it.

Is there a way to do this that I'm missing, or is this a standard thing for list fields?

[Brian Lancaster · Accepted solution]

Because it is a list field which can contain multiple departments in your case you cannot sort, group by, etc these fields.  I have run into the same situation with our incidents and locations as we have a filed called affected location as a list field.  You can do searches but you need to use the filter conditions and do [field name] contains value.

[ericgilmore]

@Brian Lancaster  I believe I have to go with this. Unless I can devise an alternate way of handling entities that need to be associated with multiple items (ala list field) that I can sort by and/or filter by using wildcards. Maybe a rethink of my logic can help.