Re: Sorting ADAM-Queries in Outlook



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





.



Relevant Pages

  • Re: Sorting ADAM-Queries in Outlook
    ... but this only optimized the sort. ... Eric Fleischman [MSFT] ... We are populating ADAM from a database via a Windows service where the ... This works just fine, but if you open the address book in Outlook, the ...
    (microsoft.public.windows.server.active_directory)
  • Re: Sorting ADAM-Queries in Outlook
    ... I'm not sure I fully grok what you are referring to re: primary key. ... I assume the problem you are having is that the sort fails. ... ADAM or in Outlook? ...
    (microsoft.public.windows.server.active_directory)
  • Re: Virtual List View functionality in ADAM and Outlook
    ... The general problem with patching Outlook is that they have too many ... >>> Dmitri- we do currently use MIIS to bring all of our entries into ADAM ...
    (microsoft.public.windows.server.active_directory)
  • Re: Sorting ADAM-Queries in Outlook
    ... ADAM can output its data in many different ways, however your problem is getting Outlook to request it in the way you want it. ... 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. ... I assume the problem you are having is that the sort fails. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Virtual List View functionality in ADAM and Outlook
    ... What's the reason they would want to know the ... Outlook for users that need to find all users on a base? ... The reason to check out the ADAM ideas are to scale to the millions without ... > setting up multiple LDAP sources, each with a different search base, like ...
    (microsoft.public.windows.server.active_directory)