How to Filter a List When You Can't Correctly Build the Filter

The Issue: Sometimes you can't include the condition you want in a graphical list filter, but a (GlideRecord) encoded query is valid. An Example: On my sc\_request table I have created a field with the type Name-Value Pairs to store address informat...