Indicia
stable
Indicia Manual
Indicia Quick Start
Supporters of Indicia’s code development
Introduction
Building your site
Administering and maintaining Indicia
Contributing to Indicia
Developing
Architecture Overview
Coding standards
GitHub and version control
Developing client website code
Data Model Introduction
Locality data
Extending Indicia to support new spatial systems
Example queries for report writers
Developing Reports
Tutorial: Writing a report
Report File Format
Standard parameters in reports
Occurrence report standard parameters
Web services
RESTful web services
Developing for the Warehouse
Getting help
Indicia
Docs
»
Developing
»
Developing Reports
Edit on GitHub
Developing Reports
¶
Tutorial: Writing a report
Our baseline query
Converting the query to a report
Controlling the column output
Using the advanced pagination facility
Setting up column filtering
Integrating with website permissions
Parameterising the report
Standard parameters
Integrating with custom attributes
Images and maps
Including photos in report grids
Outputting your records onto a map
Aggregate functions in reports
Report File Format
Element <report>
Attributes of <report>
Child elements of <report>
Example of <report>
Element <query>
Attributes of <query>
Replacements Tokens
Example of <query>
Element <count_query>
Element <order_bys>
Child elements of <order_bys>
Element <order_by>
Element <field_sql>
Example of <field_sql>
Element <params>
Child elements of <params>
Element <param>
Attributes of <param>
More information on the idlist datatype
Parameters which require additional filters in the WHERE section
Parameters which require additional joins
Optional custom attributes
Element <columns>
Child elements of <columns>
Element <column>
Attributes of <column>
Declaring SQL for each column
Element <vagueDate>
Standard Report Parameters
Standard parameters in reports
Occurrence report standard parameters
Read the Docs
v: stable
Versions
latest
stable
Downloads
pdf
html
epub
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.