Sort data in sub level

i am doing a sorting for a column that is in sub level. The issue there is , the sub level contains an array and i want to sort the data depending on the condition.
My data looks like below
I need to do sorting on column "SubColumn.S_Text" where the Id = 2.
That means for sorting only those rows should be considered where Id is equal to 2.
I tried few ways as per documentation but could not achieve that.
Can you please help me with this query?

{
"Column1" : "XXX",
"SubColumn" : [
{
"S1" : "EA355E4B-F0A4-46AE-A7A3-E44A01ED6CAE",
"S_Text" : "A_SampleName",
"Id" : 2
},
{
"S1" : "DCC3AC3B-C7E8-4683-997A-3B12E5BB3675",
"S_Text" : "B_mpleName",
"Id" : 3
}
]
},
{
"Column1" : "YYYY",
"SubColumn" : [
{
"S1" : "BA355E4B-F0A4-46AE-A7A3-E44A01ED6CAE",
"S_Text" : "D_SampleName",
"Id" : 2
},
{
"S1" : "DCC3AC3B-C7E8-4683-997A-3B12E5BB3675",
"S_Text" : "F_SampleName",
"Id" : 3
}
]
},
........

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.