From 9cb5385c6e64b8034f3faf5563836d25a186e30d Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 22 May 2012 10:08:14 +0800 Subject: [PATCH] DataObjects/Person.php --- DataObjects/Person.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/DataObjects/Person.php b/DataObjects/Person.php index cabf1655..fcbe2da0 100644 --- a/DataObjects/Person.php +++ b/DataObjects/Person.php @@ -574,7 +574,7 @@ class Pman_Core_DataObjects_Person extends DB_DataObject if ( $q['query']['not_in_directory'] > -1) { $tn_pd = DB_DataObject::Factory('ProjectDirectory')->tableName(); // can list current - so that it does not break!!! - $x->whereAdd("$tn_p.id NOT IN + $this->whereAdd("$tn_p.id NOT IN ( SELECT distinct person_id FROM $tn_pd WHERE project_id = " . $q['query']['not_in_directory'] . " AND company_id = " . $this->company_id . ')'); -- 2.39.2