1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
5 <class>SavedSearch
</class>
6 <name>civicrm_saved_search
</name>
7 <comment>Users can save their complex SQL queries and use them later.
</comment>
11 <type>int unsigned
</type>
12 <title>Saved Search ID
</title>
13 <required>true
</required>
14 <comment>Saved Search ID
</comment>
22 <autoincrement>false
</autoincrement>
27 <title>Saved Search Name
</title>
30 <default>NULL
</default>
31 <comment>Unique name of saved search
</comment>
39 <fieldName>name
</fieldName>
46 <title>Saved Search Label
</title>
49 <default>NULL
</default>
50 <comment>Administrative label for search
</comment>
59 <name>form_values
</name>
60 <title>Submitted Form Values
</title>
63 <comment>Submitted form values for this search
</comment>
64 <serialize>PHP
</serialize>
69 <name>mapping_id
</name>
70 <type>int unsigned
</type>
71 <title>Mapping ID
</title>
72 <comment>Foreign key to civicrm_mapping used for saved search-builder searches.
</comment>
74 <label>Mapping
</label>
79 <name>mapping_id
</name>
80 <table>civicrm_mapping
</table>
82 <onDelete>SET NULL
</onDelete>
87 <name>search_custom_id
</name>
88 <type>int unsigned
</type>
89 <title>Option Value ID
</title>
90 <comment>Foreign key to civicrm_option value table used for saved custom searches.
</comment>
95 <name>where_clause
</name>
97 <title>Where Clause
</title>
98 <comment>the sql where clause if a saved search acl
</comment>
104 <name>select_tables
</name>
106 <title>Select Tables
</title>
107 <comment>the tables to be included in a select data
</comment>
108 <serialize>PHP
</serialize>
114 <name>where_tables
</name>
116 <title>Where Tables
</title>
117 <comment>the tables to be included in the count statement
</comment>
118 <serialize>PHP
</serialize>
124 <name>api_entity
</name>
126 <title>Entity Name
</title>
128 <comment>Entity name for API based search
</comment>
131 <callback>CRM_Contact_BAO_SavedSearch::getApiEntityOptions
</callback>
136 <name>api_params
</name>
138 <title>API Parameters
</title>
139 <comment>Parameters for API based search
</comment>
140 <serialize>JSON
</serialize>
144 <name>created_id
</name>
145 <type>int unsigned
</type>
146 <title>Created By Contact ID
</title>
147 <comment>FK to contact table.
</comment>
149 <label>Created By
</label>
151 <readonly>true
</readonly>
155 <name>created_id
</name>
156 <table>civicrm_contact
</table>
159 <onDelete>SET NULL
</onDelete>
162 <name>modified_id
</name>
163 <type>int unsigned
</type>
164 <title>Modified By Contact ID
</title>
165 <comment>FK to contact table.
</comment>
167 <label>Modified By
</label>
169 <readonly>true
</readonly>
173 <name>modified_id
</name>
174 <table>civicrm_contact
</table>
177 <onDelete>SET NULL
</onDelete>
180 <name>expires_date
</name>
181 <type>timestamp
</type>
182 <title>Search Expiry Date
</title>
183 <required>false
</required>
184 <comment>Optional date after which the search is not needed
</comment>
188 <name>created_date
</name>
189 <type>timestamp
</type>
190 <comment>When the search was created.
</comment>
191 <required>true
</required>
192 <default>CURRENT_TIMESTAMP
</default>
193 <readonly>true
</readonly>
197 <name>modified_date
</name>
198 <type>timestamp
</type>
199 <comment>When the search was last modified.
</comment>
200 <required>true
</required>
201 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
203 <readonly>true
</readonly>
206 <name>description
</name>
208 <title>Saved Search Description
</title>
210 <type>TextArea
</type>