I'm new in adonis.js. and i can't find any examples how to get data from json field. i have destination table and in it i have translations json field. and in that field i have data like this.
{
"status": "success",
"destinations": {
"type": "outgoing",
"slug": "destionation-1",
"translations": {
"ge": {
"name": "ge-name"
},
"en": {
"name": "en-name"
}
},
"createdAt": "2022-03-30T13:26:54.590+04:00",
"updatedAt": "2022-03-30T13:26:54.590+04:00",
"id": 1
}
}
i need something like this
return await Destination.query()
.where('translations', 'ge').orderBy('created_at', 'asc')
i need to get data
{
"name": "ge-name"
}
sorry for my bad english.