[
{
“Talent”: {
“createdBy”: "aditi@yopmail.com",
“createdOn”: “2017-12-20T09:55:13.9483552+00:00”,
“document”: 4,
“email”: "aditi@yopmail.com",
“id”: “17342773-e2c0-408b-8d47-880c5ad05dc3”,
“questionAndAnswers”: [
{
“answer”: “test site”,
“createdBy”: "aditi@yopmail.com",
“createdOn”: “2017-12-20T09:58:10.3899873+00:00”,
“id”: “0bcb1305-da04-4f7d-96f7-bdd3bcb86cc1”,
“question”: “what is this”,
“status”: 1,
“tenantId”: null,
“updatedBy”: "minar.mr@sonata-software.com",
“updatedOn”: “2017-12-20T09:57:28.1484051+00:00”
},
{
“answer”: null,
“createdBy”: "aditi@yopmail.com",
“createdOn”: “2017-12-20T09:58:10.3899873+00:00”,
“id”: “c362a6ea-986d-4f2b-a36d-daf0cd9a1f38”,
“question”: “how to download”,
“status”: 0,
“tenantId”: null,
“updatedBy”: null,
“updatedOn”: “0001-01-01T00:00:00”
},
{
“answer”: null,
“createdBy”: "aditi@yopmail.com",
“createdOn”: “2017-12-20T10:57:11.7064425+00:00”,
“id”: “string”,
“question”: “asdasdasd”,
“status”: 0,
“tenantId”: “string”,
“updatedBy”: “string”,
“updatedOn”: “2017-12-18T05:00:41.439Z”
}
],
“tenantId”: null,
“updatedBy”: "aditi@yopmail.com",
“updatedOn”: “2017-12-15T09:22:10.5757915+00:00”
}
}
]
SELECT t.UpdatedOn FROM Talent t;
You can reference nested objects using dotted notation example: t.a.b.c
You can reference Specific array element with position example t. questionAndAnswers[1]. createdOn
If you want refrence array element based on condition
first element FIRST v FOR v IN t. questionAndAnswers WHEN v.status = 0 END
all elements ARRAY v FOR v IN t. questionAndAnswers WHEN v.status = 0 END