Laravel Nova - Map database json column to field

Question

I have a database model with json column type called attributes. This column will contain additional details of the model.

For example: attributes : {'desc' : 'test', 'width' : '500'}.

I would like to display individual attribute (desc & width) in attributes column as a html field in Laravel admin resource.

I checked supported field types and doesn't seem supports.

Any suggestions how I can do this?

user_11903635 · Answer

Here's how I was able to accomplish this in Nova 2.0. In my case I have a JSON column called fields. In the model, fields is cast to an array.

protected $casts = [
    'fields' => 'array'
];

Then in the resource, the column is mapped using the -> operator.

Text::make('Name', 'fields->name')

user_2227182 · Answer

I'm not sure if it's the recommended answer but i've found a way that should work for you.

Use an Eloquent Mutator: Eloquent Mutators

Then you define a getDescAttribute and a setDescAttribute and pass it in nova like a property on the model like so:

Text::make('Desc', 'desc')

Hope this helps.

user_6932792 · Answer

For example the value for 'desc' column is something like :

"{attributes : {'desc' : 'test', 'width' : '500'}}"

You can directly put it in table format :

KeyValue::make('Desc', 'desc**.attributes**')

Hope this helps

user_1951465 · Answer

There is a package that allows you to achieve what you want to without any unnecessary changes to the behaviour of your model.

This would allow you to define each key of JSON array as actual fields that can be modified.