Thu, 24 Sep 2026
Login

get error when using sql to display total list by department

Confluence User - 19 Jul, 2024

this is my sql,

it appears here, but when preview, it shows error:

datalists;userviews;user

2

Confluence User •
19 Jul, 2024 •
confluenceUser •
1 •
confluenceUser •

Okay, try to remove the space between the COUNT and (c_processID).

And please make sure that the processID is within the same form. ( app_fd_mrs)

Might as well that is causing the issue.
Let me know how it goes.




Confluence User •
19 Jul, 2024 •
confluenceUser •
•
confluenceUser •

hi, how to filter it by month now? is it possible?

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Joget User Visits Statistics
Limit User Approval
i am building an app, and for some reason i am not able to open it anymore. All apps --> my app --> system error
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I configure or set up 2 email addresses under 1 Joget application platform ?
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
How can I post data from custom html form (before login form) into a form in a process.
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print