Array of json are rendered as [[object Object]]

Help me!
1

Feature(s) impacted

Display of Array of json fields as [[object Object]]

Observed behavior

I see in the column [[object Object]]

Expected behavior

I want to see something like `[{“my-key”: “my-value”}]

Failure Logs

image
image574×300 15.7 KB

In the database I have an array of json (format in db looks good)

Context

  • Project name: Roundtable
  • Team name: -
  • Environment name: All
  • Agent technology: nodejs
  • Agent (forest package) name & version: last version
  • Database type: postgres
  • Recent changes made on your end if any: -
3

Hello @Quentin_Somerville1 ,
Indeed we have an issue with JSON of array. We will investigate the issue. I’come back very soon.

4

Hello again,
Unfortunately we doesn’t support array of json in postgresql.
But you can use the addField customization to display it as a JSON in readOnly !

.addField('myJsonColumn', {
      columnType: 'Json',
      dependencies: ['myArray'],
      getValues: records => {
        return records.map(r => {
          return r.myArray.map((a) => {
            return JSON.stringify(a);
          });
        });
      },
    });

Let me know if my proposal can help you :pray:

5

You can expect this view with my given trick
image

6

That seems good thanks @Alban_Bertolini !