Question & Answer > View Question

Chart based on SQL statement don't show results (or any error)

Confluence User - 13 Aug, 2021

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?

chart;sql

2

Confluence User •

15 Aug, 2021 •

confluenceUser •

•

confluenceUser •

Any server log error?

Confluence User •

17 Aug, 2021 •

confluenceUser •

•

confluenceUser •

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

Chart based on SQL statement don't show results (or any error)

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-d4075d2c-426a-41dd-8d62-b69aeef09960{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-2fa7d8ec-5ff6-4239-a045-c362dcddccd6{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer