Solved

INDEX SERVER SEARCH ON MULTI DOC TYPES

Posted on 2003-11-14
1
196 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
C# onclick function to call another form with parameter 10 44
Syntax Help on SP 4 52
Update field in order 21 109
JSON error 4 38
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
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/…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 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

15 Experts available now in Live!

Get 1:1 Help Now