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>
10 <icon>fa-bar-chart
</icon>
13 <title>Report Instance ID
</title>
14 <type>int unsigned
</type>
15 <required>true
</required>
16 <comment>Report Instance ID
</comment>
21 <autoincrement>false
</autoincrement>
24 <name>domain_id
</name>
25 <title>Report Instance Domain ID
</title>
26 <type>int unsigned
</type>
28 <table>civicrm_domain
</table>
29 <keyColumn>id
</keyColumn>
30 <labelColumn>name
</labelColumn>
32 <required>true
</required>
33 <comment>Which Domain is this instance for
</comment>
37 <name>domain_id
</name>
38 <table>civicrm_domain
</table>
44 <title>Report Instance Title
</title>
47 <comment>Report Instance Title.
</comment>
54 <name>report_id
</name>
55 <title>Report template ID
</title>
58 <required>true
</required>
59 <comment>FK to civicrm_option_value for the report template
</comment>
67 <title>Report instance Name
</title>
70 <comment>when combined with report_id/template uniquely identifies the instance
</comment>
78 <title>Report Instance Arguments
</title>
81 <comment>arguments that are passed in the url when invoking the instance
</comment>
88 <name>description
</name>
89 <title>Report Instance description
</title>
92 <comment>Report Instance description.
</comment>
99 <name>permission
</name>
100 <title>Report Instance Permissions
</title>
103 <comment>permission required to be able to run this instance
</comment>
110 <name>grouprole
</name>
111 <title>Report Instance Assigned to Roles
</title>
113 <length>1024</length>
114 <comment>role required to be able to run this instance
</comment>
121 <name>form_values
</name>
122 <title>Submitted Form Values
</title>
123 <type>longtext
</type>
124 <import>true
</import>
125 <comment>Submitted form values for this report
</comment>
126 <serialize>PHP
</serialize>
130 <name>is_active
</name>
131 <title>Report Instance is Active
</title>
133 <comment>Is this entry active?
</comment>
135 <type>CheckBox
</type>
140 <name>created_id
</name>
141 <type>int unsigned
</type>
142 <title>Report Instance Created By
</title>
143 <comment>FK to contact table.
</comment>
147 <name>created_id
</name>
148 <table>civicrm_contact
</table>
151 <onDelete>SET NULL
</onDelete>
154 <name>owner_id
</name>
155 <type>int unsigned
</type>
156 <title>Report Instance Owned By
</title>
157 <comment>FK to contact table.
</comment>
161 <name>owner_id
</name>
162 <table>civicrm_contact
</table>
165 <onDelete>SET NULL
</onDelete>
168 <name>email_subject
</name>
169 <title>Report Instance email Subject
</title>
172 <comment>Subject of email
</comment>
178 <name>email_to
</name>
179 <title>Email Report Instance To
</title>
181 <comment>comma-separated list of email addresses to send the report to
</comment>
188 <name>email_cc
</name>
189 <title>cc Email Report Instance To
</title>
191 <comment>comma-separated list of email addresses to send the report to
</comment>
199 <title>Report Instance Header
</title>
201 <comment>comma-separated list of email addresses to send the report to
</comment>
203 <type>TextArea
</type>
211 <title>Report Instance Footer
</title>
213 <comment>comma-separated list of email addresses to send the report to
</comment>
215 <type>TextArea
</type>
222 <name>navigation_id
</name>
223 <title>Navigation ID
</title>
224 <type>int unsigned
</type>
225 <import>true
</import>
226 <comment>FK to navigation ID
</comment>
230 <name>navigation_id
</name>
231 <table>civicrm_navigation
</table>
234 <onDelete>SET NULL
</onDelete>
237 <name>drilldown_id
</name>
238 <title>Drilldown Report ID
</title>
239 <type>int unsigned
</type>
240 <import>true
</import>
241 <comment>FK to instance ID drilldown to
</comment>
245 <name>drilldown_id
</name>
246 <table>civicrm_report_instance
</table>
249 <onDelete>SET NULL
</onDelete>
252 <name>is_reserved
</name>
253 <title>Instance is Reserved
</title>
257 <type>CheckBox
</type>