Implement JSON Field type
Description
Environment
Attachments
relates to
testing discovered
Activity
Reopening this:
Found two issues while testing https://idempiere.atlassian.net/browse/IDEMPIERE-6223#icft=IDEMPIERE-6223:
1 - The migration script for postgresql is generated wrongly
2 - Changed the JSONData field in Test window to the following invalid JSON:
The prettifier in WJsonEditor is changing the wrong JSON to this:
But, when saving to the database, the non-prettified value is passed to the UPDATE/INSERT.
Oracle saves the wrong JSON without complaining (that's an oracle error).
PostgreSQL throws an error because the wrong JSON (because is saving the non-prettified value)
I marked it yesterday to remember that I needed to move it from NF12 to NF11 - it is done

Why is this marked as To Be Documented if it has its wiki page? https://wiki.idempiere.org/en/NF11_JSON_Field_Type
Reopening this for integration into release-11

Documented here → https://wiki.idempiere.org/en/NF12_JSON_Field_Type
we started to work with json data but idempiere doesnt support yet json so we setup field in database manually. would be nice to implement new json field type.