From: KH Lau Date: Wed, 31 Jan 2018 07:48:56 +0000 (+0800) Subject: DataObjects/Core_email.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=2256fe811941e640ec9e637f3a701b1d189d444e DataObjects/Core_email.php --- diff --git a/DataObjects/Core_email.php b/DataObjects/Core_email.php index de91473d..8fd76394 100644 --- a/DataObjects/Core_email.php +++ b/DataObjects/Core_email.php @@ -41,6 +41,18 @@ class Pman_Core_DataObjects_Core_email extends DB_DataObject $tn.subject LIKE '%{$this->escape($q['search']['nameortitle'])}%' "); } + + $this->selectAdd(" + ( + SELECT + count(user_id) + FROM + core_group_member + WHERE + to_group_id = core_group_member.group_id + ) + AS group_member_count + "); } function beforeDelete($dependants_array, $roo)