Hi Bo,
GeoPackage has support for JSON fields, meaning that text fields can be
of JSON type.
When you add a new JSON field (e.g via the field calculator) this type
can be chosen and then the key/value widget should work.
I just realized, that the JSON field type is missing from the create new
geopackage layer dialog.
Matthias
On 12/7/19 7:08 PM, Bo Victor Thomsen wrote:
Hi list -
I'm trying to create a attribute form that would show json key/value
pairs in an attribute form. The json data is stored in a text field
like this : '{ "one":"1", "two":"2",... }'. The dataaprovider is a
GeoPackage
I would like to show the json text field using a key/value widget.
However this option is always greyed out and can't be activated for
the text field.
I've tried creating a virtual field (type blob) where the value in the
virtual field was populated using a expression like: from_json
("my_json_text_field") and other similar methods. However the
key/value widtget is always greyed out.
I'm aware, that I could create a Postgres database and put my data in
postgres table and getting it to work. However, that's not an option
in this case.
Is there a solution to this problem ?
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
