*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
- Reports that are delivered through the FOLIO Reporting App require some setup and configuration before they can be published for users. Here are some of the first steps.
- write the query as a FUNCTION
- in addition to the SQL query, set up a JSON file to configure the report display and parameters
- use naming conventions, e.g., LTS_ACQ_1_name_of_query
- make sure the report does not include sensitive data, such as patron identifiers (e.g., user_id, requester_id)
- give users permissions to view the reporting app report
Naming
- Add a prefix appropriate for the work area or function of your report, as well as a number
- Reporting App Naming Conventions
- LAW_ACQ
- LAW_CAT
- LAW_CIRC
- LTS_ACQ
- LTS_CAT
- CIRC
- ADC
- FBO
- CUCD
- Reporting App Naming Conventions
- Number the reports sequentially. For example:
- LTS_ACQ_1_sopo
- LTS_ACQ_2_orders
- FBO_1_daily_appr_inv_exported_yesterday
- FBO_2_daily_appr_inv_vendor_yesterday
...