MySQL Forums
Forum List  »  Newbie

Re: Grouping Not Working
Posted by: Lance Scott
Date: September 20, 2017 11:15PM

That might not show properly, here are the results in JSON format (there are 3 production units, 8,9,11):

[
{
"Month": "11",
"Week Ready": "48",
"Production Unit": "BV",
"Total Bunches": "4",
"Total Weight (KGs)": "124",
"Farm Budget": "1",
"Revised Budget": "1",
"Forcast Local Loads": "2",
"Forcast Mutare Loads": "3",
"Forcast Export Loads": "2"
},
{
"Month": "11",
"Week Ready": "46",
"Production Unit": "CBC",
"Total Bunches": "8",
"Total Weight (KGs)": "185",
"Farm Budget": "200000",
"Revised Budget": "100000",
"Forcast Local Loads": "5",
"Forcast Mutare Loads": null,
"Forcast Export Loads": "2"
},
{
"Month": "11",
"Week Ready": "47",
"Production Unit": "CBC",
"Total Bunches": "38",
"Total Weight (KGs)": "1447",
"Farm Budget": "200000",
"Revised Budget": "100000",
"Forcast Local Loads": "5",
"Forcast Mutare Loads": null,
"Forcast Export Loads": "2"
},
{
"Month": "11",
"Week Ready": "46",
"Production Unit": "CBC",
"Total Bunches": "27",
"Total Weight (KGs)": "907",
"Farm Budget": "200000",
"Revised Budget": "100000",
"Forcast Local Loads": "5",
"Forcast Mutare Loads": null,
"Forcast Export Loads": "2"
}
]

Options: ReplyQuote


Subject
Written By
Posted
September 20, 2017 12:39AM
September 20, 2017 09:50AM
September 20, 2017 10:52PM
Re: Grouping Not Working
September 20, 2017 11:15PM
September 21, 2017 09:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.