- Issue created by @ptmkenny
- ๐ฉ๐ชGermany sharique
For me it will be useful if we can export certain attribute in json as exposed filter.
- First commit to issue fork.
- ๐ซ๐ฎFinland sokru
With help of AI, I made proof-of-concept for this, works only with MariaDB/MySQL.
Would require more work for sqlite and postgresql. - ๐จ๐ฆCanada Charlie ChX Negyesi ๐Canada
Thanks for the PoC.
I left you a couple nits in Slack but I wanted to note: as far as I can tell user supplied jsonpath goes into the query unescaped, that looks like
a problem to me.Also, , this is what backend overridable services were invented for. I would put the mysql specific logic into one such making eventual postgresql and sqlite implentations seemlessly integrate.
services: json_field.query: class: this could be an abstract class tags: - { name: backend_overridable } mysql.json_field.query: class: Some\Helper\Containing\The\MySQL\Logic
Check the views.date_sql service and friends for an example.