Query CurrentUser from Outlook View

[fred]

Is there a way to Query the CurrentUser from an Outlook View using
SQL ?

 

[Ken Slovak - [MVP - Outlook]]

Query what? What are you trying to do?

You can use SQL syntax (actually WebDAV) for advanced find searches and for
creating search folders.

 

[fred]

Trying to Setup a View that displays only items that are assigned to
the CurrentUser. Using the Contacts field populated with the full
name of the user (from the GAL). This results in the contacts field
displaying the first and last name on any item assigned to them. We
need a view to filter only items assigned to this user. I have tried
using SQL in the view to select CurrentUser with no success. Is there
another syntax that will allow this in the query?

 

[Ken Slovak - [MVP - Outlook]]

I believe you'd have to hard-code the CurrentUser name for the DASL for the
filter if you are using the Customize View or Define View dialogs unless you
are using Outlook 2007.

In Outlook 2007 you can use the new View object model additions
(View.Filter). Then you could get CurrentUser as a string value in code
before you constructed the view filter using that value.




Trying to Setup a View that displays only items that are assigned to
the CurrentUser. Using the Contacts field populated with the full
name of the user (from the GAL). This results in the contacts field
displaying the first and last name on any item assigned to them. We
need a view to filter only items assigned to this user. I have tried
using SQL in the view to select CurrentUser with no success. Is there
another syntax that will allow this in the query?