Hi 👋 welcome to a new post!

As a wise man said (forgot the name), “Frustration is the mother of innovation”.

For one of my projects at work, I needed to query and sort some tables. The requirement was to let the user filter and sort the data on any field.

What I didn’t expect was that some fields were enum values under the hood…. how should I filter/sort these values, when the user searches using their text representation (and, even more difficult, translated in their language)?