Cheap and easy wildcard search w moss
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

Cheap and Easy wildcard search w/ moss PowerPoint PPT Presentation


  • 51 Views
  • Uploaded on
  • Presentation posted in: General

Cheap and Easy wildcard search w/ moss. Becky Isserman, B&R Business Solutions http://www.mosslover.com. Pre-Requisites. More Pre-requisites…. Turn on Search Create an SSP Add Content Indexes Create Scopes Add Properties Add Content Crawl Content Indexes. Query Object Model.

Download Presentation

Cheap and Easy wildcard search w/ moss

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Cheap and easy wildcard search w moss

Cheap and Easy wildcard search w/ moss

Becky Isserman, B&R Business Solutions

http://www.mosslover.com


Pre requisites

Pre-Requisites


More pre requisites

More Pre-requisites…

  • Turn on Search

  • Create an SSP

  • Add Content Indexes

  • Create Scopes

  • Add Properties

  • Add Content

  • Crawl Content Indexes


Query object model

Query Object Model

  • Looks like SQL

  • Example:SELECT <columns>FROM <content source>WHERE <conditions>ORDER BY<columns>


Wildcard search options like

Wildcard Search Options (LIKE)

  • %

  • SELECT FROM ‘All Sites’WHERE Author LIKE ‘%oleman’


Wildcard search options like1

Wildcard Search Options (LIKE)

  • _

  • SELECT FROM ‘All Sites’WHERE Author LIKE ‘Jade _oleman’


Wildcard search options like2

Wildcard Search Options (LIKE)

  • [ ] or [ ^ ]

  • SELECT FROM ‘All Sites’WHERE Author LIKE ‘Jade [CcKk]olemen’

  • SELECT FROM ‘All Sites’WHERE Author LIKE ‘Jade [^C]oleman’


Wildcard search options contains

Wildcard Search Options (CONTAINS)

  • *

  • SELECT FROM ‘All Sites’WHERE CONTAINS(‘Coleman*’)


Cheap and easy wildcard search w moss

Demo

  • User Control/SMART Part

  • Webpart Conversion


Reference

Reference

  • “Inside the Index and Search Engines: Microsoft Office SharePoint Server 2007” by Patrick Tisseghem and Lars Fastrup

  • Code Samples from Book:http://www.microsoft.com/mspress/companion/9780735625358

  • SMART Part: http://www.codeplex.com/smartpart

  • STSDev: http://www.codeplex.com/stsdev


Information

Information

  • E-mail: [email protected]

  • Blog: http://www.mosslover.com

  • Comic: http://www.sharepointcomic.com


  • Login