Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Andrea 24 posts 44 karma points
    Jan 14, 2011 @ 10:31
    Andrea
    0

    Newbie - Search system - Full-text index

    Hi,

    I want to use the full-text index of MS Sql Express to allow the user to search data inside the site.

    If I have understood correctly the cmsContentXml table contains the xml data of all published contents, so if I create a full-text index for that table I can get a global search.

    So what I need to know is how do I write a sql query (using umbraco API) to retrieve a set of nodes by nodeId where the nodeId is given using the full-text index?

     

    Thanks

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Jan 14, 2011 @ 11:16
    Richard Soeteman
    1

    HI Andrea,

    You don't want to use the full text. Umbraco comes with his own Seacrh mechanism called examine.. This tool is based on Lucene.net. I can't find that many resources to get you started, but some info can be found here http://examine.codeplex.com/ and here http://www.farmcode.org/page/Umbraco-Examine.aspx 

    There are also three video's you can watch http://umbraco.org/help-and-support/video-tutorials/developing-with-umbraco/examine these video's require an Umbraco TV description.

    Cheers,

    Richard

  • Aaron Powell 1708 posts 3046 karma points c-trib
    Jan 14, 2011 @ 12:52
    Aaron Powell
    0

    You can use Examine to search against any data source, see http://www.farmcode.org/post/2010/08/10/Using-Examine-to-index-search-with-ANY-data-source.aspx

    Otherwise you can either use standard MS SQL Server full text indexing, and then it's just a matter of writing SQL queries against it. I'm hardly a SQL guru so I'm not sure what kind of restrictions/ limitations you have when searching against a sql database.

    Alternatively you could use an ORM like NHibernate which comes with searching built in (NHibernate.Search, it actually uses Lucene under the hood).

Please Sign in or register to post replies

Write your reply to:

Draft