View definition - showing only items assigned to the current user

[Tore]

Apologies if this is not the correct forum.

I'm trying to find a way of using the filter in Customize Current View ->
Filter to show only items that have been assigned to a particular user. Is
this possible using only the SQL statement in the SQL tab? So far it looks
like this:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
("http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-00000000
0046}/Arbeider" = '*****')

The asterisks is where I want it to get the current Outlook inbox user name
to filter by. (The form in question does not get the correct names from
anywhere, but I've input them in the values for the field in the form like
they appear in Outlook (and on the Exchange server)). Since I have very
little scripting knowledge at all, is there any way I can get Outlook to do
this for me in an easy and simple way just using that one SQL statement?

thanks
Toreµ

 

[Sue Mosher [MVP]]

You can't do this with a simple view filter unless you want to manually build one for each user. You would need to write code to (a) get the user's name and (b) modify the filter on the view using View.XML. Outlook 2002 SP2 or later required.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers