See the return of the script, running mysql by sqlYog:
ButwhenIruninVisualStudio,thereturnisdifferent:
Serializedresult:
"TotalMesAMes": [
{
"mes": "January",
"status": "Fechado",
"valor_negocio": 1500
},
{
"mes": "February",
"status": "Fechado",
"valor_negocio": 1260
},
{
"mes": "March",
"status": "Fechado",
"valor_negocio": 500
},
{
"mes": "May",
"status": "Fechado",
"valor_negocio": 1300
},
{
"mes": "June",
"status": "Fechado",
"valor_negocio": 1500
},
{
"mes": "July",
"status": "Fechado",
"valor_negocio": 1000
},
{
"mes": "August",
"status": "Fechado",
"valor_negocio": 3800
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "October",
"status": "Em andamento",
"valor_negocio": 5500
},
{
"mes": "October",
"status": "Em andamento",
"valor_negocio": 5500
},
{
"mes": "November",
"status": "Em andamento",
"valor_negocio": 500
},
{
"mes": "November",
"status": "Em andamento",
"valor_negocio": 500
}
]
Strange, I need the return to be equal to the one executed in sqlyog. for example, in the month of November, it is returning twice the same value, but the correct one is novbembro 500 and November 400