Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PostgreSQL json datatype doesn't works well with JSON field editor

Description

Data dictionary issue: Test.JsonData is “Json” type in current iDempiere seed but if you add a new “Json” reference type column to Test table, it will be created as “Jsonb” type.

Web UI issue: The WJonEditor field editor doesn’t works well with the “jsonb” data type as it ignore the fact that jsonb will remove most formatting white space characters before saving it to db.

Environment

None

relates to

Activity

Show:

Heng Sin Low January 26, 2025 at 3:30 AM
Edited

Test case (PostgreSQL):

  • Change Test.JsonData type to Jsonb

  • Open Test window

  • Enter json text into the Json Data field

  • Save changes but the window will still show there are changes to be saved.

  • Check DB and the changes has been saved to DB.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created January 24, 2025 at 4:06 PM
Updated 4 days ago
Resolved January 26, 2025 at 10:58 AM

Flag notifications