Doing a join in the SharePoint Portal Server Search
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Doing a join in the SharePoint Portal Server Search

 
Post new topic   Reply to topic    Windows Server Forum Index -> Portal Server Development
Author Message
Eugene Katz
Guest
Posted: Sat Nov 05, 2005 1:50 am    Post subject: Doing a join in the SharePoint Portal Server Search Reply with quote
Is it possible to do a join in the SharePoint Portal Server Search? I have a
feeling it isn't because it says the it doesn't support "Relational column
comparison", which I'm guessing means joins.

What I'm trying to do is find all the latest documents authored by people in
a particular department. The portal profile contains the person-department
relationship, and I have a query to find the documents authored by a name
person.

I'm trying to do all this through the Portal Search API. I know going
directly against the database will allow me to do joins.

If my assumption about lack of join support is correct, do I have any
options other than a two-step query (get all the people in a dept and build
the gigantic query with all their names)?
Back to top
Harshawardhan Chiplonkar[
Guest
Posted: Tue Nov 08, 2005 1:50 am    Post subject: RE: Doing a join in the SharePoint Portal Server Search Reply with quote
Hi,
Perfectly correct, SPS Search SQL is a subset of the full blown SQL of SQL
Server.
There are a few considerations here,
1) Most important, even if you do attempt to query the SQL server database
to perform a search, you would most likely land up with some exception that
you cant make head or tail of. Why? Because, the database schema is not
documented(so you dont know what to query against) and most important
again, the index is not stored in the SQL server database. If you closely
go through the SDk documentation on search features, you will find this
statement (most often overlooked)

Microsoft SharePoint Portal Server Search (SharePointPSSearch) query
language is based on SQL; however, it does not search in a relational
database with user-defined tables or indexes. Because of this, many
standard SQL statements and syntax features do not apply.

2) There are still other workarounds of getting past this without getting
on the wrong side of the supportability boundaries. You can definitely go
about using the Querywebservice or the Search OM and create a custom web
part, etc.

HTH

/Harsh
Back to top
Eugene Katz
Guest
Posted: Wed Nov 09, 2005 5:51 pm    Post subject: RE: Doing a join in the SharePoint Portal Server Search Reply with quote
Quote:
2) There are still other workarounds of getting past this without getting
on the wrong side of the supportability boundaries. You can definitely go
about using the Querywebservice or the Search OM and create a custom web
part, etc.

Thank you for your response.

I would still have to do a 2-step:
1 - get all dept members
2 - search for docs by any of these members
These is no way to avoid having to pass the results of the first step to the
second one, correct?

I'll try the 2-step, and if it can't handle that many parameters or run into
performance issues, I'd probably have to resort to pulling the info out and
storing it in another format that gives me what I need.
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Portal Server Development All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB