Implementer's SQL Guide
To write Custom Reports an implementer should be good with SQL statements. Most reports require you to pull database from MySQL / Postgres DB, and having a good grasp on SQL will help.
Given below a set of common SQL clauses an implementer should learn to master custom reports.
SELECT
WHERE clause
HAVING clause
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
GROUP BY
ORDER BY
SUM
IF
DATEDIFF
DATEADD
CREATE VIEW
UNION
INTERESECT
Sql Functions
Some resources are given below:
The Bahmni documentation is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)