Is there a way to represent a JSON field in EasyAdmin 3?

Question

I'm new to Symfony and still learning. I'm working currently on a Symfony application where I have a table that represents projects and every project have id, title, startDate, endDate and fields where fields is a JSON field that contains data representing differents columns that are custom to the project and can be added, updated or deleted by a user.

The data inside that field is like this:

{
  "columns": {
    "column1": "string",
    "column2": "integer"
  },
  "rows": [
    {
      "column1": "foo",
      "column2": 22
    },
    {
      "column1": "bar",
      "column2": 23
    }
  ]
}

"columns" represents custom columns added to a specific project and "rows" represents the data in every column. "string" and "integer" represent data type in every column.

My Question:

I can extract the columns and values using DoctrineJsonFunctions and I'm using EasyAdmin 3, but my question is how can I read the project columns when viewing project details knowing that every project may have different columns? Or is there any better solution than using JSON field? Thank you in advance!

score 1 · Answer 1 · answered Jul 09 '21 at 07:23

1

In easyadmin 3, you can use the ArrayField to display JSON data.

answered Jul 09 '21 at 07:23

Cephalopodius

117
1
10

1

ArrayField is not associative and cannot handle nesting. – Giso Stallenberg Jul 27 '22 at 11:57
Mapping between doctrine type and existing field types can be found at https://symfony.com/bundles/EasyAdminBundle/current/fields.html#mapping-between-doctrine-types-and-easyadmin-fields – Giso Stallenberg Jul 27 '22 at 11:58

Is there a way to represent a JSON field in EasyAdmin 3?

My Question:

1 Answers1

Linked