I’d like to be able to store some data as a JSON column.
Does Frappe have a built-in way to allow filtered by JSON fields. For example, if there are Documents in that DocType that all have a json key of {“color”:“blue”} in the JSON field, is there a way to filter all of the ones that are blue?
You might be able to do something like this with virtual fields, but it wouldn’t give you much flexibility. On the fly, though, I can’t think of any way to do it with the existing get_list method interface or anything available as UI on the desk.
More broadly, I suspect that frappe’s query builder could be extended to use the mariadb json_extract function, but that wouldn’t provide you with any kind of interface outside of the api.