Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Jin Botol 134 posts 287 karma points
    Aug 22, 2018 @ 07:39
    Jin Botol
    0

    ExamineIndexes not working properly

    Hi all,

    I got a problem regarding returning TotalProducts.

    This is my code :

    var machineName = Environment.MachineName;
string indexPath = string.Format($"~/App_Data/TEMP/ExamineIndexes/{machineName}/External/Index");

var indexDirectory = FSDirectory.Open(new DirectoryInfo(HttpContext.Current.Server.MapPath(indexPath)));

var searcher = new IndexSearcher(indexDirectory, true);

var masterQuery = new BooleanQuery();

var bed = string.IsNullOrEmpty(model.Bed) ? 0 : Convert.ToInt32(model.Bed);
var bedQuery = ConstructIntRangeQuery("intBeds", 0, bed, bed);
masterQuery.Add(bedQuery, BooleanClause.Occur.MUST);

TopDocs resp = searcher.Search(masterQuery, null, searcher.MaxDoc());
Debug.WriteLine(resp.TotalHits, "Total Products");

    resp.TotalHits is always returning 79 products, even if I have 71 total products.

    This code is working before in my previous version in Umbraco which is 7.5.6, but when I upgrade it into 7.11.1 is not properly working anymore. It's always returning 79 results, even if I add/delete products.

    Any ideas?

    Thanks,

    Jin

    Copy Link
  • Dave Woestenborghs 3504 posts 12135 karma points MVP 9x admin c-trib
    Aug 22, 2018 @ 08:01
    Dave Woestenborghs
    0

    Hi Jin,

    I see you are using your own code. Maybe you can try using the Examine API to do this

    https://our.umbraco.com/Documentation/Reference/Searching/Examine/examine-manager

    Have you tried rebuilding your index ?

    Dave

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 22, 2018 @ 08:08
    Jin Botol
    0

    Hi Dave,

    Yes, it's own code, but I am not the one who code it because I am the second developer who handle this site.

    I posted about Examine HERE.

    Yes, I already rebuilding my indexes in Developer sections, both internal & external, but still not working.

    Thanks,

    Jin

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 22, 2018 @ 09:48
    Jin Botol
    0

    I've already get it.

    I get the nodeId, now how can I get the nodeName and the other fields like title, price, body, etc...

    CODE :

    var bed = string.IsNullOrEmpty(model.Bed) ? "0" : model.Bed;
var searchQuery = searchCriteria.NodeTypeAlias("Product").And().Field("bedrooms", bed);
var searchResults = searcher.Search(searchQuery.Compile());

foreach (var searchResult in searchResults)
{
    Debug.WriteLine(searchResult.Id, "Search ID");
}

    Cheers,

    Jin

    Copy Link
  • Dave Woestenborghs 3504 posts 12135 karma points MVP 9x admin c-trib
    Aug 22, 2018 @ 09:50
    Dave Woestenborghs
    100

    Hi Jin,

    To retrieve other fields from the result you can do this ;

    searchResult.Fields["title"]

    Dave

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 22, 2018 @ 09:52
    Jin Botol
    0

    Hi Dave,

    Success!!!!

    Thanks for your help. Problem solved.

    You save my day!

    Thanks,

    Jin

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 22, 2018 @ 10:00
    Jin Botol
    0

    Hi Dave,

    Another problem regarding when user not selected a bedrooms.

    var bed = string.IsNullOrEmpty(model.Bed) ? "0" : model.Bed;
var searchQuery = searchCriteria.NodeTypeAlias("Product").And().Field("bedrooms", bed);

    This code will return 0, and there is no display.

    How can I set the value of model.Bed if users didn't select a bedrooms?

    Thanks,

    Jin

    Copy Link
  • Dave Woestenborghs 3504 posts 12135 karma points MVP 9x admin c-trib
    Aug 22, 2018 @ 10:04
    Dave Woestenborghs
    0

    Maybe don't include the bed "filter" in your search criteria when it's not set by the user.

    Dave

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 22, 2018 @ 10:05
    Jin Botol
    0

    Hi Dave,

    You mean in my Angular?

    Thanks,

    Jin

    Copy Link
  • Dave Woestenborghs 3504 posts 12135 karma points MVP 9x admin c-trib
    Aug 22, 2018 @ 10:11
    Dave Woestenborghs
    1

    Nope in your c# code. Something like this

    var bed = string.IsNullOrEmpty(model.Bed) ? "0" : model.Bed;
var searchCriteria = ExamineManager.Instance.DefaultSearchProvider.CreateSearchCriteria(IndexTypes.Content);

                var searchQuery = search.NodeTypeAlias("Product");

                if (bed != "0")
                {
                    searchQuery .And().Field("bed", Models.bed)
                }

    Dave

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 23, 2018 @ 03:10
    Jin Botol
    0

    Hi Dave,

    Oh,

    Thanks to your code, what I did is :

    var bed = string.IsNullOrEmpty(model.Bed) ? "" : model.Bed;

    It works well.

    Thanks again, for the help!

    Cheers,

    Jin

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 23, 2018 @ 03:41
    Jin Botol
    0

    Hi Dave,

    If users selects 5+ Bedrooms.

    How can I query and display all products with more than 5 Bedrooms?

    Thanks,

    Jin

    Copy Link
  • Jin Botol 134 posts 287 karma points
    Aug 23, 2018 @ 06:52
    Jin Botol
    0

    Hi,

    I've tried this code, but it's not working...

    var bed = string.IsNullOrEmpty(model.Bed) ? "" : model.Bed;
if (bed == "5")
{
    searchQuery.And().Range("bedrooms", 0, Convert.ToInt32(bed), true, true);
    // This code is no display.
}
else
{
    searchQuery.And().Field("bedrooms", bed);
}

    Any ideas, for this.

    Thanks,

    Jin

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies