Andrew,

The 5000 record can you open it up in Luke and paste back how that value is stored in the index. Are using gathering node and storing a d6 value? If not then this maybe the issue.

Regards

Ismail

Thanks for coming back to sorry but can you advise how to do those things please I can't even seem to find a way install like please help.

Thank you once again so I now have luke running see screenshot attached:

See the highlighted value is included and shouldnt be, in regards gathering node event to format the field im searching how do I do this please?

I am using ez Search package https://our.umbraco.org/projects/website-utilities/ezsearch/ this installs a class ezSearchBoostrapper.cs this implements the IApplicationEventHandler interface

#region Application Event Handlers

public void OnApplicationInitialized(UmbracoApplicationBase umbracoApplication, 
    ApplicationContext applicationContext)
{ }

public void OnApplicationStarting(UmbracoApplicationBase umbracoApplication, 
    ApplicationContext applicationContext)
{ }

public void OnApplicationStarted(UmbracoApplicationBase umbracoApplication, 
    ApplicationContext applicationContext)
{
    ExamineManager.Instance.IndexProviderCollection["ExternalIndexer"]
        .GatheringNodeData += OnGatheringNodeData;
}

I have tried implementing the below is this anywhere near close?

private void OnGatheringNodeData(object sender, IndexingNodeDataEventArgs e)
{

    Node theNode = new Node(e.NodeId);
    //check if this is 'Content' (as opposed to media, etc...)
    if (e.IndexType == IndexTypes.Content)
    {
        if (theNode.NodeTypeAlias == "umbPropertyDetails")
        {
            var node = new Node(e.NodeId);

            var propertyValue = TpayneandCo.App_Code.ExamineEventsHelper.GetPropertyValue(theNode, "price");

            if (propertyValue != string.Empty)
            {

                e.Fields.Add("__" + "price", GetFieldValue(e, propertyValue, "price"));

            }

        }

        AddToContentsField(e);

    }

}

private void AddToContentsField(IndexingNodeDataEventArgs e)
{

    Dictionary<string, string> fields = e.Fields;

    var combinedFields = new StringBuilder();

    foreach (KeyValuePair<string, string> keyValuePair in fields)
    {

        combinedFields.AppendLine(keyValuePair.Value);

    }

    e.Fields.Add("contents", combinedFields.ToString());

}

private string GetFieldValue(IndexingNodeDataEventArgs e, string propertyValue, string luceneFieldAlias)
{

    int nodeId = 0;

    int.TryParse(propertyValue, out nodeId);

    var n = new Node(nodeId);

    //node does not exist but we have numeric value

    if (n.Id != 0)
    {

        //have to pad out to get lucene range queries to work

        int i = 0;

        int.TryParse(n.Name, out i);

        return i.ToString("00000000");

    }

    return nodeId.ToString("00000000");

}

So that's the part I seem to be missing can you please advise how I format the price field to D6 then hopefully problem solved.

Ismail

I have tried this following:

https://our.umbraco.org/forum/using/ui-questions/16888-Examine-Search-Range-Values

The padded value appears to be getting added but I cant see it in Luke or in developer section on umbraco examine managment tab.

public class ExamineEvents : ApplicationBase
{
    public ExamineEvents()
    {
        //Add event handler for 'GatheringNodeData' 
        ExamineManager.Instance.IndexProviderCollection["ExternalIndexer"].GatheringNodeData += ExamineEvents_GatheringNodeData;

    }

    void ExamineEvents_GatheringNodeData(object sender, IndexingNodeDataEventArgs e)
    {
        Node theNode = new Node(e.NodeId);
        //check if this is 'Content' (as opposed to media, etc...)
        if (e.IndexType == IndexTypes.Content)
        {

            if (theNode.NodeTypeAlias == "Patient")
            {
                //var node = new Node(e.NodeId);
                var propertyValue = ExamineEventsHelper.GetPropertyValue(theNode, "price");

                if (propertyValue != string.Empty)
                {
                    e.Fields.Add("__" + "paddedPrice", GetFieldValue(e, propertyValue, "price"));
                }

            }

            AddToContentsField(e);

        }

    }

    private void AddToContentsField(IndexingNodeDataEventArgs e)
    {

        Dictionary<string, string> fields = e.Fields;

        var combinedFields = new StringBuilder();

        foreach (KeyValuePair<string, string> keyValuePair in fields)
        {

            combinedFields.AppendLine(keyValuePair.Value);

        }

        e.Fields.Add("contents", combinedFields.ToString());

    }

    private string GetFieldValue(IndexingNodeDataEventArgs e, string propertyValue, string luceneFieldAlias)
    {

        int nodeId = e.NodeId;

        //int.TryParse(propertyValue, out nodeId);

        var n = new Node(nodeId);

        //node does not exist but we have numeric value
        if (n.Id != 0)
        {
            //have to pad out to get lucene range queries to work
            int i = 0;

            //int.TryParse(n.Name, out i);
            int.TryParse(propertyValue, out i);

            return i.ToString("D6");
        }
        return nodeId.ToString("D6");
    }

}

ExamineIndex.config

<?xml version="1.0"?>
<!-- 
Umbraco examine is an extensible indexer and search engine.
This configuration file can be extended to create your own index sets.
Index/Search providers can be defined in the UmbracoSettings.config

More information and documentation can be found on CodePlex: http://umbracoexamine.codeplex.com
-->
<ExamineLuceneIndexSets>
  <!-- The internal index set used by Umbraco back-office - DO NOT REMOVE -->
  <IndexSet SetName="InternalIndexSet" IndexPath="~/App_Data/TEMP/ExamineIndexes/{machinename}/Internal/"/>

  <!-- The internal index set used by Umbraco back-office for indexing members - DO NOT REMOVE -->
  <IndexSet SetName="InternalMemberIndexSet" IndexPath="~/App_Data/TEMP/ExamineIndexes/{machinename}/InternalMember/">
    <IndexAttributeFields>
      <add Name="id" />
      <add Name="nodeName"/>
      <add Name="updateDate" />
      <add Name="writerName" />
      <add Name="loginName" />
      <add Name="email" />
      <add Name="nodeTypeAlias" />
    </IndexAttributeFields>
  </IndexSet>

  <!-- Default Indexset for external searches, this indexes all fields on all types of nodes-->
  <IndexSet SetName="ExternalIndexSet" IndexPath="~/App_Data/TEMP/ExamineIndexes/{machinename}/External/">
    <IndexAttributeFields>
      <add Name="id" />
      <add Name="nodeName"/>
      <add Name="nodeTypeAlias" />
      <add Name="parentID" />
    </IndexAttributeFields>
    <IndexUserFields/>
    <IncludeNodeTypes/>
    <ExcludeNodeTypes />
  </IndexSet>
</ExamineLuceneIndexSets>

ExamineSettings.config:

<?xml version="1.0"?>
<!-- 
Umbraco examine is an extensible indexer and search engine.
This configuration file can be extended to add your own search/index providers.
Index sets can be defined in the ExamineIndex.config if you're using the standard provider model.

More information and documentation can be found on CodePlex: http://umbracoexamine.codeplex.com
-->
<Examine>
  <ExamineIndexProviders>
    <providers>
      <add name="InternalIndexer" type="UmbracoExamine.UmbracoContentIndexer, UmbracoExamine"
           supportUnpublished="true"
           supportProtected="true"
           analyzer="Lucene.Net.Analysis.WhitespaceAnalyzer, Lucene.Net"/>

      <add name="InternalMemberIndexer" type="UmbracoExamine.UmbracoMemberIndexer, UmbracoExamine"
           supportUnpublished="true"
           supportProtected="true"
           analyzer="Lucene.Net.Analysis.Standard.StandardAnalyzer, Lucene.Net"/>

        <!-- default external indexer, which excludes protected and unpublished pages-->
      <add name="ExternalIndexer" type="UmbracoExamine.UmbracoContentIndexer, UmbracoExamine"
          runAsync="true"
          supportUnpublished="false"
          supportProtected="true"
          interval="10"
          analyzer="Lucene.Net.Analysis.Standard.StandardAnalyzer, Lucene.Net"
          indexSet="ExternalIndexSet"/>

    </providers>
  </ExamineIndexProviders>

  <ExamineSearchProviders defaultProvider="ExternalSearcher">
    <providers>
      <add name="InternalSearcher" type="UmbracoExamine.UmbracoExamineSearcher, UmbracoExamine"
           analyzer="Lucene.Net.Analysis.WhitespaceAnalyzer, Lucene.Net"/>

      <add name="ExternalSearcher" type="UmbracoExamine.UmbracoExamineSearcher, UmbracoExamine"
          analyzer="Lucene.Net.Analysis.Standard.StandardAnalyzer, Lucene.Net"
          indexSet="ExternalIndexSet"/>

      <add name="InternalMemberSearcher" type="UmbracoExamine.UmbracoExamineSearcher, UmbracoExamine"
           analyzer="Lucene.Net.Analysis.Standard.StandardAnalyzer, Lucene.Net" enableLeadingWildcard="true"/>

    </providers>
  </ExamineSearchProviders>

</Examine>

Yes on both counts rebuilt the index using Umbraco developer section and stepped through and I can see __paddedPrice getting added and formatted correctly but unfortunately still not appaearing in luke or index.

Seem to be getting added to the content field but im expecting another field __paddedPrice

Regards

Andrew

OMG ive got it FINALLY i can sleep at night once more:

Removing:

e.Fields.Add("__" + "paddedPrice", GetFieldValue(e, propertyValue, "price"));

And Replacing with:

e.Fields.Add("paddedPrice", GetFieldValue(e, propertyValue, "price"));

It then appeared in luke and in the index in umbraco and I am now getting the expected results when querying in Luke:

I cant thank you enough for your help massive respect. Now just to test in the app.