Calendar custom view SQL FILTER bug?

  • Thread starter Thread starter Doug
  • Start date Start date
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%')))
 
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%')))

.
 
Back
Top