Confluence User •

19 Feb, 2021 •

confluenceUser •

•

confluenceUser •

In your SQL, try using the "SELECT .... COUNT(*) ...." function instead of "COUNT(dateCreated)", since you already done the "GROUP BY monthYear" grouping. See https://www.mysqltutorial.org/mysql-count/#:~:text=The%20COUNT(*)%20function%20returns,non%2DNULL%20and%20NULL%20rows.

Confluence User •

23 Feb, 2021 •

confluenceUser •

•

confluenceUser •

hello, I have tried the following  SQL:

select count(*), status, issueDate
from app_fd_new_invoice_form
where status = 'posted'
group by status, issueDate
order by issueDate desc

But there are errors in system logs I have field status in my form 

1

CSV | Excel | XML | PDF