Re: Sorting ADAM-Queries in Outlook
- From: "Eric Fleischman [MSFT]" <efleis@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 09:17:25 -0800
Ah ok.
So, FYI, you should probably drop the term "primary key" from your
vocabulary in the context of ADAM. While we certainly have such a concept in
the db itself, it doesn't map well to what you're asking.
Anyway, you're VLVing which means you need an index we can use for this. You
are specifically VLVing on CN.
So, my suggestions:
- install ADAM SP1 (aka the R2 version or the latest from
microsoft.com/adam)
- set the bit to create indexes which can be used for VLV on the CN
attribute in the schema. This is defined with a searchFlags value of 64
- wait a few mins (we catch the change in ~5 mins, then build the index
which takes a little while)
- try again
~Eric
--
Eric Fleischman [MSFT]
This post is provided "AS IS" with no warranties, and confers no rights
"Jochen" <Jochen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4DC6AC4E-5D69-4DF3-A172-41A641CB7785@xxxxxxxxxxxxxxxx
Thanks for your answer, Eric! Let me clarifiy a litte bit:
We are populating ADAM from a database via a Windows service where the
primary key of the table is used as the common name in ldap, e. g.
DirectoryEntry objADAM = new DirectoryEntry(LDAP_PATH,.)
DirectoryEntry objNewContact =
objADAMPath.Children.Add(row["ID"].ToString(), "Contact")
objNewContact.Properties["sn"].Add(strSN);
.
This works just fine, but if you open the address book in Outlook, the
entries will be ordered by CN - which in our case was the primary key, f.
e.
CN=1, CN=1000=, CN=10014. Not only are the displayed results not arranged
alphabetically, but it's also not possible to search by name. If you
switch
to the search page in outlook, the results are o.k. We'd like to somehow
show
the entries in the address book ordered by givenname, sn or displayName,
which in our case is composed of givenname and sn. Can this be somehow
achieved in ADAM, f. e. via VLV?
Thanks for your help!
Jochen
"Eric Fleischman [MSFT]" wrote:
I'm not sure I fully grok what you are referring to re: primary key. We
define this stuff. What have you changed in this regard, and how?
I assume the problem you are having is that the sort fails. Is this
correct?
If so how does it fail?
Thx.
~Eric
--
Eric Fleischman [MSFT]
This post is provided "AS IS" with no warranties, and confers no rights
"Jochen" <Jochen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5D989E8C-A7AB-49F5-9B17-65860548D798@xxxxxxxxxxxxxxxx
Hi,
we're using ADAM as an Ldap-Server for our Outlook-2003-Clients.
Outlook
issues (&(mail=*)(cn=*)) as query if the users just browse their
address
books. Unfortunatelly, the sort order is based on CN - which in our
case
is a
database primary key - the results therefore are not searchable. Cant
the
sort oder of this query be changed somehow, e. g. to sn, givenName,
either
in
ADAM or in Outlook?
Thanks for your help!
Jochen
.
- Follow-Ups:
- Re: Sorting ADAM-Queries in Outlook
- From: Eric Fleischman [MSFT]
- Re: Sorting ADAM-Queries in Outlook
- Prev by Date: Re: FSMO - can I turn on a DC after its PDCe role has been seized?
- Next by Date: Re: FSMO - can I turn on a DC after its PDCe role has been seized?
- Previous by thread: Re: DCPROMO error with Win2003 server std R2 (not adprep /forestprep)
- Next by thread: Re: Sorting ADAM-Queries in Outlook
- Index(es):
Relevant Pages
|