Custom Reporting -- Creating Reports: Difference between revisions

From IHRIS Wiki
No edit summary
Line 1: Line 1:
This documentation applies specifically to iHRIS 4.0, although much of it applies to version 3.1.
==Intended User==
==Intended User==
This step is intended who has a moderated understanding of how the data is related in the system.
This step is intended who has a moderated understanding of how the data is related in the system.
Line 7: Line 8:


==Adding Links==
==Adding Links==
==Database Tables==
A Report named '''XXXXX''' will cause a table named 'zebra_XXXXX' in the database.  These tables are contain the data of the report and are built from the [[Form Caches|form caches]]. 
These tables are generated by a background process once a report is consider stale.  The background process is spawned by default every 10 minutes.  This can be specified by setting the value in magic data at:
*/modules/CustomReports/times/background
The stale time for a report defaults to 10 minutes.  This can be over-ridden by the following setting values in magic data:
*/modules/CustomReports/times/stale
*/modules/CustomReports/times/stale_by_report/XXXXX 
[[Category: Technical Overview]]
[[Category: Technical Overview]]

Revision as of 13:21, 27 August 2009

This documentation applies specifically to iHRIS 4.0, although much of it applies to version 3.1.

Intended User

This step is intended who has a moderated understanding of how the data is related in the system.

Select Fields

Selecting Limits

Adding Links

Database Tables

A Report named XXXXX will cause a table named 'zebra_XXXXX' in the database. These tables are contain the data of the report and are built from the form caches.

These tables are generated by a background process once a report is consider stale. The background process is spawned by default every 10 minutes. This can be specified by setting the value in magic data at:

  • /modules/CustomReports/times/background

The stale time for a report defaults to 10 minutes. This can be over-ridden by the following setting values in magic data:

  • /modules/CustomReports/times/stale
  • /modules/CustomReports/times/stale_by_report/XXXXX