<labelField>title</labelField>
<paths>
<add>civicrm/group/add?reset=1</add>
+ <view>civicrm/group/search?force=1&context=smog&gid=[id]&component_mode=1</view>
+ <update>civicrm/group?reset=1&action=update&id=[id]</update>
+ <delete>civicrm/group?reset=1&action=delete&id=[id]</delete>
</paths>
<field>
<name>id</name>
<table>civicrm_saved_search</table>
<key>id</key>
<add>1.1</add>
- <onDelete>SET NULL</onDelete>
+ <onDelete>CASCADE</onDelete>
</foreignKey>
<field>
<name>is_active</name>
<type>text</type>
<title>Group Where Clause</title>
<comment>the sql where clause if a saved search acl</comment>
+ <readonly>true</readonly>
<add>1.6</add>
</field>
<field>
<type>text</type>
<title>Tables For Select Clause</title>
<comment>the tables to be included in a select data</comment>
+ <readonly>true</readonly>
<serialize>PHP</serialize>
<add>1.6</add>
</field>
<type>text</type>
<title>Tables For Where Clause</title>
<comment>the tables to be included in the count statement</comment>
+ <readonly>true</readonly>
<serialize>PHP</serialize>
<add>1.6</add>
</field>
<type>timestamp</type>
<title>Group Cache Date</title>
<required>false</required>
+ <readonly>true</readonly>
<comment>Date when we created the cache for a smart group</comment>
<add>2.1</add>
</field>
<type>timestamp</type>
<title>Next Group Refresh Time</title>
<required>false</required>
+ <readonly>true</readonly>
<comment>Date and time when we need to refresh the cache next.</comment>
<add>4.3</add>
</field>