One of my columns is of type text/JSON:
<field key="title" dbtype="text" phptype="json" null="false" default="" />
and here's some example data:
{"de":"Deutsch","en":"English","es":"Espanol","fr":"Francais"}
For my grid columns I defined the fields "title.de", "title.en", etc. and everything works fine.
But turning on the option "Sortable" for those columns in my MIGXdb config and trying to sort results in an empty grid... So I asume it's not possible to sort on keys/values?
☆ A M B ☆