SELECT enumlabel
FROM pg_enum
WHERE enumtypid = 'contract_type'::regtype;
Then, I have a selector that gets populated with the enum values as options to choose from.
Below the selector is a table that pulls records from another query. When you select an enum value in the upper selector, the table data gets filtered and only the the records whose contract type matches the enum value get displayed.
The problem:
One enum value is "Gebühr" and the umlaut character makes the filtering fail. Instead of seeing the records whose contract type matches "Gebühr", I see an empty table.
How can I fix this so that the data gets displayed correctly?
Thanks for reporting this. Looks like we need to add support for these characters. I made a feature request and will get back to you with any updates on this. Thank you!
So, even if the user writes using the special characters, this will be replaced with normal characters and it will find a match in the new column you created, which can be hidden from user view.