Hi guys,

I have an interesting search requirement which I'm not sure how to tackle. Basically, I have a large amount of data (lets say books, for example) and each book could must be written by at least one author, possibly more. Both books and authors are represented as nodes and authors are associated with a book via a multi-node picker which stores the values as a CSV (it must be csv and not xml because of the import method...). The site will allow you to see all books written by (or co-written by) an author and this currently happens by looking at all book nodes where the author field contains the id of the author. This is painfully slow so we were hoping to use an examine search to speed this along. However, although my index is good (checked in Luke) I'm not seeing any results. Below is the config I'm using - hopefully one of the gurus here can help me solve this.

<IndexSet SetName="BookFilterIndexSet"
    IndexPath="~/App_Data/TEMP/ExamineIndexes/BookFilter/"
    IndexParentId="-1">
    <IndexAttributeFields>
        <add Name="id" EnableSorting="true" Type="Number" />
        <add Name="nodeName" EnableSorting="true" />
    </IndexAttributeFields>
    <IndexUserFields>
        <add Name="title" />
        <add Name="authors" />
    </IndexUserFields>
    <IncludeNodeTypes>
        <add Name="BookItem" />
    </IncludeNodeTypes>
    <ExcludeNodeTypes />
</IndexSet>

"authors" is the property that holds the csv of authors.

<Examine>
  <ExamineIndexProviders>
    <providers>
      <add name="AuthorFilterIndexer" type="UmbracoExamine.UmbracoContentIndexer, UmbracoExamine"
             indexSet="AuthorFilterIndexSet"
             supportUnpublished="false"
             supportProtected="false"
             analyzer="Lucene.Net.Analysis.Standard.StandardAnalyzer, Lucene.Net"
             enableDefaultEventHandler="true"/>
    </providers>
  </ExamineIndexProviders>

  <ExamineSearchProviders defaultProvider="InternalSearcher">
    <providers>
      <add name="AuthorFilterSearcher"
             type="UmbracoExamine.UmbracoExamineSearcher, UmbracoExamine"
             indexSet="AuthorFilterIndexSet"
             analyzer="Lucene.Net.Analysis.Standard.StandardAnalyzer, Lucene.Net"/>
    </providers>
  </ExamineSearchProviders>
</Examine>

And below is the code I use to call the search:

@using umbraco.MacroEngines;
@using Examine;
@using Examine.SearchCriteria;
@{
    string searchTerm = umbraco.NodeFactory.Node.getCurrentNodeId().ToString();
    var Searcher = ExamineManager.Instance.SearchProviderCollection["AuthorFilterSearcher"];
    var searchCriteria = Searcher.CreateSearchCriteria(BooleanOperation.Or);
    var luceneString = "";

    luceneString += "authors:";
    luceneString += "(+" + searchTerm.Replace(" ", " +") + ")^5 ";
    luceneString += "authors:" + searchTerm;
      
    Response.Write("Lucene string:<br />" + luceneString + "<br />");

    var query = searchCriteria.RawQuery(luceneString);
    var searchResults = Searcher.Search(query).OrderByDescending(x => x.Score);

    Response.Write("Result count: " + searchResults.Count().ToString());
}

For the above, I'd tested this on a page with ID 8518 (there should be two results) and this was the output:

Lucene string:
authors:(+8518)^5 authors:8518
Result count: 0

In Luke, I can get both results using the following string but it doesn't work if there are multiple authors and the author ID you're searching for is the second author, not the first:

authors:(+8518)^5 authors:8518*

Can anyone help?

Thanks for looking

Alex