Trying to filter properly with SQL - Project Server Addin

[BAndrews]

I have a view i am trying to setup that is not working:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID" IS
NULL OR "AssignmentID" < 0) AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal')

This works to show all non-project related items:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID" IS
NULL OR "AssignmentID" < 0) )

and this works to show all items without the category "Daily Personal":

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but every time I try to combine them to show Non-Project related items and
non-personal related items nothing shows up.

It seems like the top query should work... any help is appreciated.

 

[Roady [MVP]]

Wrong newsgroup?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

 

[BAndrews]

No, this is the outlook newsgroup right? This is regarding an outlook
filtered view...

Wrong newsgroup?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----

I have a view i am trying to setup that is not working:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal')

This works to show all non-project related items:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) )

and this works to show all items without the category "Daily Personal":

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but every time I try to combine them to show Non-Project related items and
non-personal related items nothing shows up.

It seems like the top query should work... any help is appreciated.

 

[BAndrews]

So actually (this is wierd) when i setup something simple in the advanced
section of the filter -

Field Category <> 'Daily Personal'

When i click over to the SQL tab that is greyed out, i click edit these
criteria directly and this is in the text area:

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but when i click ok my filter that was working properly now removes
everything from the view. It's like the outlook is no showing me properly
what the query should look like based on the rules.

When i type in the SQL directly is there anything else i need to be typing
in there? Thanks!

No, this is the outlook newsgroup right? This is regarding an outlook
filtered view...

message news:[email protected]...

Wrong newsgroup?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----

I have a view i am trying to setup that is not working:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal')

This works to show all non-project related items:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) )

and this works to show all items without the category "Daily Personal":

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but every time I try to combine them to show Non-Project related items and
non-personal related items nothing shows up.

It seems like the top query should work... any help is appreciated.

 

[Roady [MVP]]

When you use SQL queries for a view all other tabs will be disabled.

I'm not really familiar in creating views like this. I'll forward this
message to the other MVP's and will post back if I get results.

Before I do this could you post your version of Outlook?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----

So actually (this is wierd) when i setup something simple in the advanced
section of the filter -

Field Category <> 'Daily Personal'

When i click over to the SQL tab that is greyed out, i click edit these
criteria directly and this is in the text area:

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but when i click ok my filter that was working properly now removes
everything from the view. It's like the outlook is no showing me properly
what the query should look like based on the rules.

When i type in the SQL directly is there anything else i need to be typing
in there? Thanks!

No, this is the outlook newsgroup right? This is regarding an outlook
filtered view...

message news:[email protected]...

Wrong newsgroup?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----
I have a view i am trying to setup that is not working:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal')

This works to show all non-project related items:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) )

and this works to show all items without the category "Daily Personal":

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily
Personal'

but every time I try to combine them to show Non-Project related
items and
non-personal related items nothing shows up.

It seems like the top query should work... any help is appreciated.

 

[BAndrews]

Well, I am almost over this:

It seems that even though outlook will prepopulate the SQL field for you, it
doesn't account for nulls so you have to add this (along with the folder and
hidden check):

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal') OR
("urn:schemas-microsoft-comfficeffice#Keywords" IS NULL))

Now that i know outlook is misleading me i can add these manually, but
everytime i save the new view with this filter and then switch to inbox and
come back, the filter has been removed from this view! This is a brand new
view that is modified and saved (with a name)...

Can someone tell me why outlook thinks its ok to remove this?

So actually (this is wierd) when i setup something simple in the advanced
section of the filter -

Field Category <> 'Daily Personal'

When i click over to the SQL tab that is greyed out, i click edit these
criteria directly and this is in the text area:

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but when i click ok my filter that was working properly now removes
everything from the view. It's like the outlook is no showing me properly
what the query should look like based on the rules.

When i type in the SQL directly is there anything else i need to be typing
in there? Thanks!

No, this is the outlook newsgroup right? This is regarding an outlook
filtered view...

message news:[email protected]...

Wrong newsgroup?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----
I have a view i am trying to setup that is not working:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal')

This works to show all non-project related items:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) )

and this works to show all items without the category "Daily Personal":

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but every time I try to combine them to show Non-Project related

items
and

non-personal related items nothing shows up.

It seems like the top query should work... any help is appreciated.

 

[BAndrews]

This appears to be a bug that i have found all over the net. Create the
filter, switch to inbox, come back - filter is reset.

I am running outlook 2003. I have not updated to the service pack - am going
to try now.

Well, I am almost over this:

It seems that even though outlook will prepopulate the SQL field for you, it
doesn't account for nulls so you have to add this (along with the folder and
hidden check):

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal') OR
("urn:schemas-microsoft-comfficeffice#Keywords" IS NULL))

Now that i know outlook is misleading me i can add these manually, but
everytime i save the new view with this filter and then switch to inbox and
come back, the filter has been removed from this view! This is a brand new
view that is modified and saved (with a name)...

Can someone tell me why outlook thinks its ok to remove this?

So actually (this is wierd) when i setup something simple in the advanced
section of the filter -

Field Category <> 'Daily Personal'

When i click over to the SQL tab that is greyed out, i click edit these
criteria directly and this is in the text area:

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but when i click ok my filter that was working properly now removes
everything from the view. It's like the outlook is no showing me properly
what the query should look like based on the rules.

When i type in the SQL directly is there anything else i need to be typing
in there? Thanks!

No, this is the outlook newsgroup right? This is regarding an outlook
filtered view...

"Roady [MVP]" <newsgroups_DELETE_@_DELETE_sparnaaij_NO_._SPAM_net>

wrote
in

message Wrong newsgroup?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----
I have a view i am trying to setup that is not working:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal')

This works to show all non-project related items:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("AssignmentID"
IS
NULL OR "AssignmentID" < 0) )

and this works to show all items without the category "Daily Personal":

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but every time I try to combine them to show Non-Project related items
and
non-personal related items nothing shows up.

It seems like the top query should work... any help is appreciated.

 

[Roady [MVP]]

Alright, post back your results after you applied the SP1. If you still need
help I'll contact the others for you

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----

This appears to be a bug that i have found all over the net. Create the
filter, switch to inbox, come back - filter is reset.

I am running outlook 2003. I have not updated to the service pack - am
going
to try now.

Well, I am almost over this:

It seems that even though outlook will prepopulate the SQL field for you, it
doesn't account for nulls so you have to add this (along with the folder and
hidden check):

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal') OR
("urn:schemas-microsoft-comfficeffice#Keywords" IS NULL))

Now that i know outlook is misleading me i can add these manually, but
everytime i save the new view with this filter and then switch to inbox and
come back, the filter has been removed from this view! This is a brand
new
view that is modified and saved (with a name)...

Can someone tell me why outlook thinks its ok to remove this?

So actually (this is wierd) when i setup something simple in the advanced
section of the filter -

Field Category <> 'Daily Personal'

When i click over to the SQL tab that is greyed out, i click edit these
criteria directly and this is in the text area:

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but when i click ok my filter that was working properly now removes
everything from the view. It's like the outlook is no showing me properly
what the query should look like based on the rules.

When i type in the SQL directly is there anything else i need to be typing
in there? Thanks!


No, this is the outlook newsgroup right? This is regarding an outlook
filtered view...

in
message Wrong newsgroup?

--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com

Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1

-----
I have a view i am trying to setup that is not working:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("AssignmentID"
IS
NULL OR "AssignmentID" < 0) AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily
Personal')

This works to show all non-project related items:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("AssignmentID"
IS
NULL OR "AssignmentID" < 0) )

and this works to show all items without the category "Daily
Personal":

"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Daily Personal'

but every time I try to combine them to show Non-Project related items
and
non-personal related items nothing shows up.

It seems like the top query should work... any help is appreciated.