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>
19 <autoincrement>false
</autoincrement>
24 <title>Saved Search Name
</title>
27 <default>NULL
</default>
28 <comment>Unique name of saved search
</comment>
36 <fieldName>name
</fieldName>
43 <title>Saved Search Label
</title>
46 <default>NULL
</default>
47 <comment>Administrative label for search
</comment>
55 <name>form_values
</name>
56 <title>Submitted Form Values
</title>
59 <comment>Submitted form values for this search
</comment>
60 <serialize>PHP
</serialize>
65 <name>mapping_id
</name>
66 <type>int unsigned
</type>
67 <title>Mapping ID
</title>
68 <comment>Foreign key to civicrm_mapping used for saved search-builder searches.
</comment>
72 <name>mapping_id
</name>
73 <table>civicrm_mapping
</table>
75 <onDelete>SET NULL
</onDelete>
80 <name>search_custom_id
</name>
81 <type>int unsigned
</type>
82 <title>Option Value ID
</title>
83 <comment>Foreign key to civicrm_option value table used for saved custom searches.
</comment>
88 <name>where_clause
</name>
90 <title>Where Clause
</title>
91 <comment>the sql where clause if a saved search acl
</comment>
97 <name>select_tables
</name>
99 <title>Select Tables
</title>
100 <comment>the tables to be included in a select data
</comment>
101 <serialize>PHP
</serialize>
107 <name>where_tables
</name>
109 <title>Where Tables
</title>
110 <comment>the tables to be included in the count statement
</comment>
111 <serialize>PHP
</serialize>
117 <name>api_entity
</name>
119 <title>Entity Name
</title>
121 <comment>Entity name for API based search
</comment>
126 <name>api_params
</name>
128 <title>API Parameters
</title>
129 <comment>Parameters for API based search
</comment>
130 <serialize>JSON
</serialize>