Solved

INDEX SERVER SEARCH ON MULTI DOC TYPES

Posted on 2003-11-14
1
199 Views
Last Modified: 2012-06-27
I need to create an index search for a site that will return everything in the site directory.

This means indexing all types of documents and all asp and htm(l) files (i'll also need to access data in a SQL DB but can handle this on a separate search if not possible with index searching.)

I have created a search for a specific folder containing ONLY .pdf docs that works OK but need advice on how to extend this to the rest of the site.
0
Comment
Question by:jfriel
1 Comment
 
LVL 1

Accepted Solution

by:
subtext101 earned 150 total points
ID: 9749011
If you're using ADO to do the query, then the answer will be in the select statement, which might be along the lines of:

SELECT DocTitle,Filename,VPath,Rank,Characterization,Write FROM SCOPE()
WHERE CONTAINS(Contents, 'SomeKeyword AND SomeOtherKeyword')
ORDER BY RANK DESC

The key thing's "Scope()" which should give you results from the whole catalogue.  In the Index Server MMC, you want to make sure that the catalog is set to track files from a specified virtual server, rather than explicitly adding a directory.  You may also want to check the boxes that say something like Index Files with Unknown Extensions.

In practice, you don't really want every file - especially if there are frontpage extensions on the website.  You can be more specific with the query, e.g.

SELECT DocTitle,Filename,VPath,Rank,Characterization,Write
FROM SCOPE('"D:\Somefolder\Webfolder"') WHERE
NOT CONTAINS(VPath, '"_vti" OR ".xml"') AND
(CONTAINS (Contents, 'SomeKeyword AND SomeOtherKeyword') OR " & _
CONTAINS (DocKeywords, 'Contents, 'SomeKeyword AND SomeOtherKeyword') OR      
CONTAINS (DocSubject, 'SomeKeyword AND SomeOtherKeyword') OR        
CONTAINS (DocTitle, 'SomeKeyword AND SomeOtherKeyword'))
ORDER BY RANK DESC

If a catalog's not returning the correct results then it more often than not seems to be the catalog configuration which is screwy.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now