Generated column based on JSON field

Data Service
1

Hi,

I would like to create a new generated column whose value is based on data inside a JSON column. The examples provided do not show how to do this. Could you please provide guidance ? Thanks !

NR

2

Hello @Nicolas_REMY

Could you give a simple example?

Regards

3

Sure !

Column jsonData includes data in the form of {"key": "value"}
I need to create a generated column which outputs value. So I tried to set the Expression to jsonData.key . But I get an error saying : Unknown column 'key' in 'generated column function'

4

@Nicolas_REMY

What behavior do you expect for {"key1": "value1", "key2": "value2"}?

5

@Nicolas_REMY

Some simple example

Data Browser - viewDataGrid - Backendless 🔊 2022-12-16 14-05-12
Data Browser - viewDataGrid - Backendless 🔊 2022-12-16 14-05-121142×384 13.2 KB

Table Editor - Data Schema - viewDataGrid - Backendless 🔊 2022-12-16 14-04-58
Table Editor - Data Schema - viewDataGrid - Backendless 🔊 2022-12-16 14-04-581062×346 18.5 KB

Here are more functions to work with JSON type
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html

Regards

6

Great ! Didn’t realize that MySQL functions worked. That should answer the question, thanks.