MOSSSearchTool v. 184.108.40.206 (a MOSS search query tool) helps you build free text SQL queries to use with MOSS Search API or MOSS Search Web Service.
How to use:
- Type the site url and hit Refresh button.
- Select the web node in the tree (either the root web or any sub subsite).
- Define the web scope (All Sites, Selected Web, Selected Web & Subsites).
- Type the search terms (e.g. CONTAINS('text_to_search') or FREETEXT(DEFAULTPROPERTIES, 'text_to_search')).
- Note that the CONTAINS predicate doesn't handle ranking wery well. Use FREETEXT instead.
- A new SearchHelper has been added that uses the KeywordQuery class.
- Select the properties returned from the query (you can use the listbox which contains the already defined managed properties - double-click the property and it will be added to view fields).
- Type any extra criteria.
- Define the content types to filter results (tip: you can copy / paste any CT defined in the current site collection, by selecting it on the treeview - expand Content Types node - and pressing CTRL+C).
- Define extra search settings:
- Trim duplicates
- Enable Stemming
- Select culture info
- Type the order by clause.
- Press Search button (the results will appear in a gridview control - tab Search Results).
- Search Web Service support
- Define alternate network credentials - press Refresh button, next to URL text box.
For a complete list of changes between versions always check the ChangeLog.txt file.
The SQL statement is visible in the corresponding text box. You can force the tool to use the free-text SQL query typed-in the appropriate text box.
The utility supports both MOSS object model and search web service. For object model to work, the tool must be run on a MOSS farm server. In order for web service calls to work, so you can use it from any Windows PC with .NET Framework 3.0 installed (no extra MOSS DLLs are needed since version 220.127.116.11).
You can send feedback regarding this tool (report bugs, request new features, ...) by using the Contact Us page and select the appropriate category.
Note: The treeview control used in this tool, is an extended version of the one used in Patrick Tisseghem's Event Handler Explorer (a free tool for registering / unregistering MOSS event handlers).
Note: The author is not responsible for any problems occured by using these utilities. Use at your own risk.
Note: If download links below don't work (e.g corrupted files), use these direct links: