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>
23 <title>SQL Query
</title>
26 <comment>SQL query for this search
</comment>
31 <name>form_values
</name>
32 <title>Submitted Form Values
</title>
35 <comment>Submitted form values for this search
</comment>
39 <name>is_active
</name>
41 <title>Saved Search Enabled
</title>
42 <comment>Is this entry active?
</comment>
47 <name>mapping_id
</name>
48 <type>int unsigned
</type>
49 <title>Mapping ID
</title>
50 <comment>Foreign key to civicrm_mapping used for saved search-builder searches.
</comment>
54 <name>mapping_id
</name>
55 <table>civicrm_mapping
</table>
60 <name>search_custom_id
</name>
61 <type>int unsigned
</type>
62 <title>Option Value ID
</title>
63 <comment>Foreign key to civicrm_option value table used for saved custom searches.
</comment>
67 <name>where_clause
</name>
69 <title>Where Clause
</title>
70 <comment>the sql where clause if a saved search acl
</comment>
74 <name>select_tables
</name>
76 <title>Select Tables
</title>
77 <comment>the tables to be included in a select data
</comment>
81 <name>where_tables
</name>
83 <title>Where Tables
</title>
84 <comment>the tables to be included in the count statement
</comment>