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)