Standard parameters in reports¶
The standard parameters feature built into Indicia’s reporting engine provides a flexible set of reporting parameters that can be applied to any report that runs against the cache_occurrences_functional table or cache_samples_functional. By having a consistent, standard set of parameters that can run against a wide variety of reports it facilitates developing functionality that benefits from the assumption that the parameters it understands will be supported. For example, the filter panel used on iRecord allows filters to be created and saved them used for a wide variety of purposes using different underlying reports.
In order to support standard parameter functionality the report must:
standard_params="samples"in the attributes of the
queryelement in the report definition.
include the table
cache_occurrences_functionalwith an alias of
ofor occurrence based reports, or
cache_samples_functionalwith an alias of
sfor sample based reports.
include the full set of tags for sharing and filtering as shown in the template below:SELECT ... FROM ... #agreements_join# #joins# WHERE #sharing_filter# #idlist# .. more filters
The list of parameters made available for occurrence reports which support standard parameters is described in the next section.