[imp] name expansion / IMP composition window Address Book
Liam Hoekenga
liamr at umich.edu
Tue Sep 16 20:21:25 PDT 2003
Ok, here's the deal..
We want name expansion to be based on the object_alias field in our sql
addressbook so, we did this...
from imp/prefs.php:
$_prefs['search_fields'] = array(
'value' => "personal_sql\talias",
'locked' => false,
'shared' => false,
'type' => 'implicit'
);
but that also results in the composition window address book only displaying
entries that have a nickname set...
Sep 16 22:40:39 HORDE [debug] [turba] SQL search by liamr: table =
turba_objects; query = "SELECT object_id, owner_id, object_type,
object_members, object_name, object_email, object_alias, object_homeaddress,
object_workaddress, object_homephone, object_workphone, object_cellphone,
object_fax, object_title, object_company, object_notes FROM turba_objects WHERE
(owner_id = 'liamr') AND (LOWER(object_alias) LIKE LOWER('%%'))" [on line 120
of "/usr/local/projects/webmail/html-ssl/horde/turba/lib/Driver/sql.php"]
Is it possible in Horde 2.2.4 / IMP 3.2.2 / Turba 1.2.1 to get this working like
we want?
Actually, we'd prefer a strict match on object_alias, but then the SQL query
looks like...
Sep 16 23:13:31 HORDE [debug] [turba] SQL search by liamr: table =
turba_objects; query = "SELECT object_id, owner_id, object_type,
object_members, object_name, object_email, object_alias, object_homeaddress,
object_workaddress, object_homephone, object_workphone, object_cellphone,
object_fax, object_title, object_company, object_notes FROM turba_objects WHERE
(object_alias = '' AND owner_id = 'liamr')" [on line 120 of
"/usr/local/projects/webmail/html-ssl/horde-2.2.4UM/turba-1.2.1UM/lib/Driver/sql.php"]
which works for name expansion, but then *NO* addresses show up in the
composition window address book.
Liam
More information about the imp
mailing list