1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Report
</base>
5 <class>ReportInstance
</class>
6 <name>civicrm_report_instance
</name>
7 <comment>Users can save their report instance and put in a cron tab etc.
</comment>
11 <title>Report Instance ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Report Instance ID
</comment>
19 <autoincrement>false
</autoincrement>
22 <name>domain_id
</name>
23 <title>Report Instance Domain ID
</title>
24 <type>int unsigned
</type>
26 <table>civicrm_domain
</table>
27 <keyColumn>id
</keyColumn>
28 <labelColumn>name
</labelColumn>
30 <required>true
</required>
31 <comment>Which Domain is this instance for
</comment>
35 <name>domain_id
</name>
36 <table>civicrm_domain
</table>
42 <title>Report Instance Title
</title>
45 <comment>Report Instance Title.
</comment>
52 <name>report_id
</name>
53 <title>Report template ID
</title>
56 <required>true
</required>
57 <comment>FK to civicrm_option_value for the report template
</comment>
65 <title>Report instance Name
</title>
68 <comment>when combined with report_id/template uniquely identifies the instance
</comment>
76 <title>Report Instance Arguments
</title>
79 <comment>arguments that are passed in the url when invoking the instance
</comment>
86 <name>description
</name>
87 <title>Report Instance description
</title>
90 <comment>Report Instance description.
</comment>
97 <name>permission
</name>
98 <title>Report Instance Permissions
</title>
101 <comment>permission required to be able to run this instance
</comment>
108 <name>grouprole
</name>
109 <title>Report Instance Assigned to Roles
</title>
111 <length>1024</length>
112 <comment>role required to be able to run this instance
</comment>
119 <name>form_values
</name>
120 <title>Submitted Form Values
</title>
122 <import>true
</import>
123 <comment>Submitted form values for this report
</comment>
127 <name>is_active
</name>
128 <title>Report Instance is Active
</title>
130 <comment>Is this entry active?
</comment>
132 <type>CheckBox
</type>
137 <name>created_id
</name>
138 <type>int unsigned
</type>
139 <title>Report Instance Created By
</title>
140 <comment>FK to contact table.
</comment>
144 <name>created_id
</name>
145 <table>civicrm_contact
</table>
148 <onDelete>SET NULL
</onDelete>
151 <name>owner_id
</name>
152 <type>int unsigned
</type>
153 <title>Report Instance Owned By
</title>
154 <comment>FK to contact table.
</comment>
158 <name>owner_id
</name>
159 <table>civicrm_contact
</table>
162 <onDelete>SET NULL
</onDelete>
165 <name>email_subject
</name>
166 <title>Report Instance email Subject
</title>
169 <comment>Subject of email
</comment>
175 <name>email_to
</name>
176 <title>Email Report Instance To
</title>
178 <comment>comma-separated list of email addresses to send the report to
</comment>
185 <name>email_cc
</name>
186 <title>cc Email Report Instance To
</title>
188 <comment>comma-separated list of email addresses to send the report to
</comment>
196 <title>Report Instance Header
</title>
198 <comment>comma-separated list of email addresses to send the report to
</comment>
200 <type>TextArea
</type>
208 <title>Report Instance Footer
</title>
210 <comment>comma-separated list of email addresses to send the report to
</comment>
212 <type>TextArea
</type>
219 <name>navigation_id
</name>
220 <title>Navigation ID
</title>
221 <type>int unsigned
</type>
222 <import>true
</import>
223 <comment>FK to navigation ID
</comment>
227 <name>navigation_id
</name>
228 <table>civicrm_navigation
</table>
231 <onDelete>SET NULL
</onDelete>
234 <name>drilldown_id
</name>
235 <title>Drilldown Report ID
</title>
236 <type>int unsigned
</type>
237 <import>true
</import>
238 <comment>FK to instance ID drilldown to
</comment>
242 <name>drilldown_id
</name>
243 <table>civicrm_report_instance
</table>
246 <onDelete>SET NULL
</onDelete>
249 <name>is_reserved
</name>
250 <title>Instance is Reserved
</title>
254 <type>CheckBox
</type>