Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Issue resolved
the log said that it was an issue with the SQL code.
I was able to rewrite my SQL code, in a way that Joget was able to handle:
SELECT
Period,
@runningTotal := @runningTotal + totals.Outcome AS runningTotal
FROM
(Select CONCAT(MONTH(c_CDate),' ',YEAR(c_CDate))as Period,
sum(c_OutComePro) as 'Outcome',
(SELECT @runningTotal:=0)
from app_fd_trades
where c_CDate>0
GROUP BY YEAR(c_CDate), MONTH(c_CDate)) Totals
and the chart looks like this
Any server log error?
I am using this Statement for creating a line graph, but graph has no value:
SET @runningTotal = 0;
SELECT
Date,
@runningTotal := @runningTotal + totals.Outcome AS runningTotal
FROM
(Select CONCAT(MONTH(c_CDate),' ',YEAR(c_CDate))as Date,
sum(c_OutCome) as 'Outcome'
from app_fd_trades1
where c_CDate>0
GROUP BY YEAR(c_CDate), MONTH(c_CDate)) Totals
Here is the results of the query in default database:
Any idea on how to fix this?