JSON encoded data in tables

I’m fairly new to using Revo and just getting my head round it.

I notice in some fields in tables there is JSON encoded data.( I don’t know anything about JSON)

I presume that this is normal and there are some standard ways/ methods for accessing the values via the object based on the table.( & if so what are they?)

What’s the advantage of storing data like this?

Ta
Mike

This is to allow a single column to hold any amount of structured data, which gives users the ability to define/store data for custom fields. The drawback is that it is hard to use this data for searching and sorting. In cases where you have custom data that needs to be searched and sorted on, it is better to create a custom table and scripts to access/manage the custom data. FWIW, when you use get() on fields that are stored as JSON, they are automatically returned as a PHP array for use in your scripts.

Ah ha, I see, yes that makes sense.

Thanks for responding.

Mike