> For the complete documentation index, see [llms.txt](https://help.santesuite.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.santesuite.org/knowledgebase/fixpatch/20171016-01.md).

# 20171016-01

**Summary:** Add FIRST() aggregation function \
**Details:** The OpenIZ reporting and ETL processes require the use of an aggregate function which returns the first record of a particular set. This update adds this to PostgreSQL \
**Bug / Issues:** N/A\
**Applies To:** OpenIZ Server, SanteDB Server\
**Impacted Versions:** 0.2.0.0 - 0.9.0.0\
**Status:** Released (October 10, 2017)\
**Impact:** Low\
**RDBMS:** PostgreSQL