F
fred
Is there a way to Query the CurrentUser from an Outlook View using
SQL ?
SQL ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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.
You can use SQL syntax (actually WebDAV) for advanced find searches and for
creating search folders.
F
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?
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?
Query what? What are you trying to do?
You can use SQL syntax (actually WebDAV) for advanced find searches and for
creating search folders.
--
Ken Slovak
[MVP - Outlook]http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Optionshttp://www.slovaktech.com/products.htm
Is there a way to Query the CurrentUser from an Outlook View using
SQL ?- Hide quoted text -
- Show quoted text -
K
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?
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?