i’m searching for a solution to filter on a column with a JSON string as value. The JSON string looks like the following:
Example 1:
[{"ID":"2","Username":"Muster Schmidt"},{"ID":"11","Username":"Michl Müller"}]
Example 2:
[{"ID":"3","Username":"Muster Max"},{"ID":"12","Username":"Meike Müller"}]
I want to filter on the “ID”. When i filter on ID 2 then only example 1 have to show up. Is this possible ?
This is not achievable through the filter menu, but you may be able to filter these JSON strings the way you require if you apply a custom filter (example).