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>
124 <serialize>PHP
</serialize>
128 <name>is_active
</name>
129 <title>Report Instance is Active
</title>
131 <comment>Is this entry active?
</comment>
133 <type>CheckBox
</type>
138 <name>created_id
</name>
139 <type>int unsigned
</type>
140 <title>Report Instance Created By
</title>
141 <comment>FK to contact table.
</comment>
145 <name>created_id
</name>
146 <table>civicrm_contact
</table>
149 <onDelete>SET NULL
</onDelete>
152 <name>owner_id
</name>
153 <type>int unsigned
</type>
154 <title>Report Instance Owned By
</title>
155 <comment>FK to contact table.
</comment>
159 <name>owner_id
</name>
160 <table>civicrm_contact
</table>
163 <onDelete>SET NULL
</onDelete>
166 <name>email_subject
</name>
167 <title>Report Instance email Subject
</title>
170 <comment>Subject of email
</comment>
176 <name>email_to
</name>
177 <title>Email Report Instance To
</title>
179 <comment>comma-separated list of email addresses to send the report to
</comment>
186 <name>email_cc
</name>
187 <title>cc Email Report Instance To
</title>
189 <comment>comma-separated list of email addresses to send the report to
</comment>
197 <title>Report Instance Header
</title>
199 <comment>comma-separated list of email addresses to send the report to
</comment>
201 <type>TextArea
</type>
209 <title>Report Instance Footer
</title>
211 <comment>comma-separated list of email addresses to send the report to
</comment>
213 <type>TextArea
</type>
220 <name>navigation_id
</name>
221 <title>Navigation ID
</title>
222 <type>int unsigned
</type>
223 <import>true
</import>
224 <comment>FK to navigation ID
</comment>
228 <name>navigation_id
</name>
229 <table>civicrm_navigation
</table>
232 <onDelete>SET NULL
</onDelete>
235 <name>drilldown_id
</name>
236 <title>Drilldown Report ID
</title>
237 <type>int unsigned
</type>
238 <import>true
</import>
239 <comment>FK to instance ID drilldown to
</comment>
243 <name>drilldown_id
</name>
244 <table>civicrm_report_instance
</table>
247 <onDelete>SET NULL
</onDelete>
250 <name>is_reserved
</name>
251 <title>Instance is Reserved
</title>
255 <type>CheckBox
</type>