[Koha] Help with JSON and public reports

[Karam Qubsi]

Hi ,
First I'm very new with JSON . I'd like to ask :
as I understood from JSON documentation that the output data in JSON format
must look like something like to this :
 [ { "Name" : "Alfreds Futterkiste", "City" : "Berlin", "Country" :
"Germany" }, { "Name" : "Berglunds snabbköp", "City" : "Luleå", "Country" :
"Sweden" }, { "Name" : "Centro comercial Moctezuma", "City" : "México
D.F.", "Country" : "Mexico" }, { "Name" : "Ernst Handel", "City" : "Graz",
"Country" : "Austria" } ]

but in Koha the output for Public reports  is like this :

[["23-12-2014","maisara","6"],["23-12-2014","nadia","10"],["22-12-2014","hakkar","17"],["22-12-2014","nadia","3"],["22-12-2014","abdramaneg","21"]]

the field names is not in the output , and I realized ( & maybe I'm
wrong) that to handle JSON text you must have id for each field ) to
handle it with your script .

so is this a correct output from Koha ? and can be handled in some
advanced methods with JSON ?

or do I have to write my SQL report in a way to CONCAT the field name
with the field data in every data cell ?

thanks :) .

-- 

*Karam Qubsi <https://www.linkedin.com/in/kqubsi>*

*Shah Alam , Malaysia . *