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?
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).
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
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
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).
is working on a reply...