Calendar custom view SQL FILTER bug?

D

Doug

I've published a calendar in the public folders. I set
up a custom view using SQL (DASL) filter. It works fine
as long as I do not leave the current view on the
screen. As soon as I click another folder in the "folder
list" pane and go back to the public calendar, the SQL
filter information is lost and I have to start over. How
do I save the custom view filter permanently without
losing it?

Procedure:
Go to calendar view. In the menu,
Select Custom View/Define Views..
Click "Modify" button to modify one of the views.
Click "Filter"
Choose "SQL" tab and put in the SQL code.
Publish the view.

Here is my DASL filter, which works fine:
("DAV:isfolder" = false OR "DAV:ishidden" = false) OR
((("http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Vendor" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven2" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven3" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven4" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven5" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven6" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven7" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven8" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven9" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven10" LIKE '%All%' OR
"http://schemas.microsoft.com/mapi/string/{00020329-0000-
0000-C000-000000000046}/Vendor" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven2" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven3" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven4" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven5" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven6" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven7" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven8" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven9" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven10" LIKE '%L%') AND
("http://schemas.microsoft.com/mapi/string/{00020329-0000-
0000-C000-000000000046}/Region" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg2" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg3" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg4" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg5" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg6" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg7" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg8" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg9" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg10" LIKE '%All%' OR
"http://schemas.microsoft.com/mapi/string/{00020329-0000-
0000-C000-000000000046}/Region" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg2" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg3" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg4" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg5" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg6" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg7" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg8" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg9" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg10" LIKE '%W%')))
 
D

Doug

Same problem occurs in Outlook 2002 or 2003.
-----Original Message-----
I've published a calendar in the public folders. I set
up a custom view using SQL (DASL) filter. It works fine
as long as I do not leave the current view on the
screen. As soon as I click another folder in the "folder
list" pane and go back to the public calendar, the SQL
filter information is lost and I have to start over. How
do I save the custom view filter permanently without
losing it?

Procedure:
Go to calendar view. In the menu,
Select Custom View/Define Views..
Click "Modify" button to modify one of the views.
Click "Filter"
Choose "SQL" tab and put in the SQL code.
Publish the view.

Here is my DASL filter, which works fine:
("DAV:isfolder" = false OR "DAV:ishidden" = false) OR
((("http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Vendor" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven2" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven3" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven4" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven5" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven6" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven7" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven8" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven9" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven10" LIKE '%All%' OR
"http://schemas.microsoft.com/mapi/string/{00020329-0000-
0000-C000-000000000046}/Vendor" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven2" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven3" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven4" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven5" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven6" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven7" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven8" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven9" LIKE '%L%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Ven10" LIKE '%L%') AND
("http://schemas.microsoft.com/mapi/string/{00020329- 0000-
0000-C000-000000000046}/Region" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg2" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg3" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg4" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg5" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg6" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg7" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg8" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg9" LIKE '%All%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg10" LIKE '%All%' OR
"http://schemas.microsoft.com/mapi/string/{00020329-0000-
0000-C000-000000000046}/Region" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg2" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg3" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg4" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg5" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg6" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg7" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg8" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg9" LIKE '%W%'
OR "http://schemas.microsoft.com/mapi/string/{00020329-
0000-0000-C000-000000000046}/Reg10" LIKE '%W%')))

.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WHERE without using CASE 3
view corrupt 4
Today(S) function in DASL Filter 1
Outlook 2007 SQL syntax to filter views of tasks and todo items 1
custom views 4
DASL Filter function? 3
Taskpad in Calendar View 4
DASL Filter doesn't work when defined programatically 1

Top