query return a list

[shavitpren]

hi, i want to return a result as a filed  with list of raw

my data is:

Product : A, SubProcut: A1, Status :1

Product : A, SubProcut: A2, Status :1

Product : A, SubProcut: A3, Status :2

Product : B, SubProcut: B1, Status :1

I want to query that result will be:

prodduct A, Status 2, subProducts: [A1,A2,A3], Status: 2

prodduct A, Status 2, subProducts: [B1], Status: 1

[ITWhisperer]

Your query results are not consistent with your data. What are you trying to get from your data?