[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