Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
First, your expected results do not match your defined array -- the variable LB-REGION-N is defined as "city_name" and hence will NEVER be "region_name" as you expect.
Second, there is pretty much no JSON expertise on this forum so you're probably not going to get many (if any) answers here. Your best bet is to do LOTS of debugging -- displaying the ENTIRE value you get back, then figuring out how your program is parsing it out into variables. Or you could convince your management to hire a consultant to help you figure out your issues.
Joined: 30 Sep 2016 Posts: 5 Location: south africa
Sorry for confusing with the different field labels.
But my question is related to grouping.
My table has values
province city suburb
abc jnb sub1
abc jnb sub2
All i want in my result is grouping ( province, city and suburb) as groups
but my current results are giving me all separate group for province, and separate for city and separate for suburb.
The grouping is shown by [ ], which is not generated correctly.