Re: Sorting ADAM-Queries in Outlook

Oh, but this only optimized the sort. It doesn't let you change what you
sort by. That's an Outlook/OE thing to ask them about.


--
Eric Fleischman [MSFT]
This post is provided "AS IS" with no warranties, and confers no rights



"Eric Fleischman [MSFT]" <efleis@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23Nz4TExEHHA.1224@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... 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: Sorting ADAM-Queries in Outlook
    ... So, FYI, you should probably drop the term "primary key" from your ... 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: Sorting address book in Outlook 2002
    ... fields to be Last/ First to sort ... the Outlook Address Book by Last/First. ... >>Russ Valentine ... >>> Thanks for the quick response. ...
    (microsoft.public.outlook.contacts)
  • Re: Save Sort order in Word 2007?
    ... I wondered if the original data source did not have the sort specified - in some circumstances, Word will not replace the original data source when you save the document, in which case you would always be opening the mail merge main document with an unsorted data source. ... when you connect to an Outlook Contacts folder in this way, Word always prompts for the name of the contacts folder/address book name. ... FWIW, I wouldn't expect the sequence in Outlook and the "unsorted sequence" in Word to be the same - although they /might be/, your sorted sequence in Outlook may be a view on an underlying sequence which you never see - perhaps sequence the items were created or another sequence altogether. ...
    (microsoft.public.word.mailmerge.fields)
Loading