Prev: Do Deleted Sites Show in Recycle Bin?
Next: MOSS SharePoint List Filter
From: Cole on 14 Feb 2007 16:43
I'm at my wits end! Need help. Hopefully someone out there have a
solution.

I have program that query's portals profile and get the subject error
when searching for personnel that have middle initials. Same program
works on a development machine, but when it's executed on the
production it returns "unspecified error".

FYI. The production have over 600K profiles and about 100K are
inactive.

The following are the queries:

1. Queries that work:
SELECT "urn:schemas-microsoft-
com:sharepoint:portal:profile:FirstName","urn:schemas-microsoft-
com:sharepoint:portal:profile:LastName","urn:schemas-microsoft-
com:sharepoint:portal:profile:AccountName","urn:schemas-microsoft-
com:sharepoint:portal:profile:PreferredName","urn:schemas-microsoft-
com:sharepoint:portal:profile:Manager","urn:schemas-microsoft-
com:sharepoint:portal:profile:WorkPhone","urn:schemas-microsoft-
com:sharepoint:portal:profile:WorkEmail","urn:schemas-microsoft-
com:sharepoint:portal:profile:Title","urn:schemas-microsoft-
com:sharepoint:portal:profile:Department","urn:schemas-microsoft-
com:sharepoint:portal:profile:SID","urn:schemas.microsoft.com:fulltextqueryinfo:sdid","urn:schemas-
microsoft-com:sharepoint:portal:objectid" FROM ( TABLE
Portal_Content..Scope() UNION ALL TABLE Non_Portal_Content..Scope() )
WHERE CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:FirstName", '"cole ruiz*"') OR
CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:LastName", '"cole ruiz*"') OR
CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:WorkEmail", '"cole ruiz*"') OR
CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:PreferredName", '"cole ruiz*"') OR
CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:AccountName", '"cole ruiz*"') ORDER BY
"urn:schemas-microsoft-com:sharepoint:portal:profile:FirstName" ,
"urn:schemas-microsoft-com:sharepoint:portal:profile:LastName"

2. Query that does NOT work.
SELECT "urn:schemas-microsoft-
com:sharepoint:portal:profile:FirstName","urn:schemas-microsoft-
com:sharepoint:portal:profile:LastName","urn:schemas-microsoft-
com:sharepoint:portal:profile:AccountName","urn:schemas-microsoft-
com:sharepoint:portal:profile:PreferredName","urn:schemas-microsoft-
com:sharepoint:portal:profile:Manager","urn:schemas-microsoft-
com:sharepoint:portal:profile:WorkPhone","urn:schemas-microsoft-
com:sharepoint:portal:profile:WorkEmail","urn:schemas-microsoft-
com:sharepoint:portal:profile:Title","urn:schemas-microsoft-
com:sharepoint:portal:profile:Department","urn:schemas-microsoft-
com:sharepoint:portal:profile:SID","urn:schemas.microsoft.com:fulltextqueryinfo:sdid","urn:schemas-
microsoft-com:sharepoint:portal:objectid" FROM ( TABLE
Portal_Content..Scope() UNION ALL TABLE Non_Portal_Content..Scope() )
WHERE CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:FirstName", '"david.m.anderson*"') OR
CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:LastName", '"david.m.anderson*"') OR
CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:WorkEmail", '"david.m.anderson*"') OR
CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:PreferredName", '"david.m.anderson*"')
OR CONTAINS("urn:schemas-microsoft-
com:sharepoint:portal:profile:AccountName", '"david.m.anderson*"')
ORDER BY "urn:schemas-microsoft-
com:sharepoint:portal:profile:FirstName" , "urn:schemas-microsoft-
com:sharepoint:portal:profile:LastName"

 | 
Pages: 1
Prev: Do Deleted Sites Show in Recycle Bin?
Next: MOSS SharePoint List Filter