Issue 8249 - No query "criterion" support when OE selected from Mozilla Address Books
Summary: No query "criterion" support when OE selected from Mozilla Address Books
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: oooqa
Depends on:
Blocks: 17159
  Show dependency tree
 
Reported: 2002-10-11 16:22 UTC by john.marmion
Modified: 2006-05-31 14:29 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Patch to fix this (4.24 KB, patch)
2004-03-12 09:45 UTC, wind.li 		no flags Details | Diff
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description john.marmion 2002-10-11 16:22:12 UTC 
One of the features of the OOo Address Book integration with Mozilla is that
Outlook Express (OE) Address Book can be created as a separate DataSource or it
can also be accessed if it is available as a entry in the Mozilla Preferences
file. This latter functionality is not yet available in the mozilla UI but is
available if manually entered - see:
http://abzilla.mozdev.org

But if OE is accessed as a Mozilla Address Book, then if  a "criterion" or
"where" clause is included in the Query, then no records are returned.  

This bug was found while examining bug #8148. They are related in that we have
two ways of integrating with the same Address Book type. 

I presume this can be fixed in some similar fashion to the bug #8148, but I
would also like to raise the possibility of when a user chooses to create a
Mozilla Address Book data source, should they also get LDAP Address Books and/or
Outlook and Outlook Express Books as well.
Comment 1 Frank Schönheit 2003-02-26 10:39:00 UTC 
reassigning to the responsible developer for the Mozilla Address Book
integration
Comment 2 lohmaier 2003-03-04 23:32:20 UTC 
just confirming issue already reassigned by developer...
Comment 3 michael.bemmer 2003-03-25 08:08:05 UTC 
Target this to beta2 now, maybe something happens then.
Comment 4 seangao 2003-04-02 07:23:36 UTC 
Fangfang, reassign this bug to you. 
-Sean
Comment 5 Frank Schönheit 2003-04-02 14:47:48 UTC 
I retarget this to 2.0. Given that currently no possibility exists in
the user interface to enable the Outlook address book, and that the
easy workaround in OOo is to access the address book as "Outlook
Address Book", instead of as "Mozilla Address Book", I consider this
not important enough for 1.1.
The more as I suppose that in opposite to bug 8148, it will be much
harder to determine that a MozAB is a "masked" OutlookAB (while it was
very easy to determine that it's a masked LDAP-AB).
Comment 6 Unknown 2003-08-14 07:59:29 UTC 
re-assign to wind.
Comment 7 wind.li 2003-10-29 07:17:47 UTC 
fixed in http://www.openoffice.org/issues/show_bug.cgi?id=9160 .
Comment 8 hans_werner67 2004-02-02 12:49:58 UTC 
change subcomponent to 'none'
Comment 9 wind.li 2004-02-10 06:14:21 UTC 
Migrate to a new account for security reasons.
Comment 10 wind.li 2004-03-04 11:22:46 UTC 
fixed in cws mozab03
Comment 11 wind.li 2004-03-09 11:20:04 UTC 
verified in mozab03
Comment 12 marc.neumann 2004-03-11 08:35:14 UTC 
not fixed in CWS mozab3
What I have done:

-add 
   user_pref("ldap_2.servers.mapitest.description", "mapitest");
   user_pref("ldap_2.servers.mapitest.dirType", 3);
   user_pref("ldap_2.servers.mapitest.position", 4);
   user_pref("ldap_2.servers.mapitest.uri", "moz-aboutlookdirectory://oe/");
 to my prefs.js file
- create new mozilla addressbook in the Office
- display the Table OE Contacts
==>> the record is displayed
- create a new query like this:
Select "First Name" from "OE Contacts" "OE Contacts" where ( ( "First Name" =
'first' ) )
- execute the query
==>> no data displayed.
Comment 13 marc.neumann 2004-03-11 08:35:37 UTC 
remove fixed
Comment 14 wind.li 2004-03-12 09:45:23 UTC 
Created attachment 13743 [details]
Patch to fix this
Comment 15 wind.li 2004-03-12 09:50:53 UTC 
fixed now
Comment 16 Frank Schönheit 2004-03-12 13:30:15 UTC 
fs (on behalf of windly)->msc: please verify in cws mozab03
Comment 17 marc.neumann 2004-03-17 08:52:51 UTC 
set to fixed
Comment 18 marc.neumann 2004-03-17 08:53:10 UTC 
verify in CWS mozab03
Comment 19 marc.neumann 2005-01-06 09:33:29 UTC 
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc