Query From JSON data stored in CLOB Column , preserving the structure
Hi ,
If i have Json data stored in CLOB column like this for example
{
"result": [
{
"id": 1,
"name": "d",
"description": "1 نوع مستند فاتورة",
"activeFrom": "2020-01-01T00:00:00Z",
"activeTo": null,
"documentTypeVersions": [
{
"id": 2,
"typeName": "d",
"name": "invoiceversion",
"description": "فاتورة اصدار 1 وصف",
"versionNumber": "1.0",
"status": "Published",
"activeFrom": "2020-10-30T12:41:46Z",
"activeTo": null
},
{
"id": 12,
"typeName": "d",
"name": "1 فاتورة",
"description": "debit note",
"versionNumber": "6.0",
"status": "Published",
"activeFrom": "2020-10-05T17:04:42Z",
"activeTo": null
}
]
},
{
"id": 2,
"name": "c",
"description": "نوع مستند فاتورة",
"activeFrom": "2020-01-01T00:00:00Z",
"activeTo": null,
"documentTypeVersions": [
{
"id": 1,
"typeName": "c",
"name": "Credit",
"description": "فاتورة اصدار 1 وصف",
"versionNumber": "1.0",
"status": "Published",
"activeFrom": "2020-10-30T12:55:46Z",
"activeTo": null
},
{
"id": 11,
"typeName": "c",
"name": "فاتورة",
"description": "credit note",
"versionNumber": "6.0",
"status": "Published",
"activeFrom": "2020-10-05T16:57:23Z",