MongoDB Search embeddedScoped-facet and sort

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Component/s: None
    • None
    • Builder Changes Needed
    • Hide

      Summary of necessary driver changes

      •  

      Commits for syncing spec/prose tests
      (and/or refer to an existing language POC if needed)

      •  

      Context for other referenced/linked tickets

      •  
      Show
      Summary of necessary driver changes   Commits for syncing spec/prose tests (and/or refer to an existing language POC if needed)   Context for other referenced/linked tickets  
    • $i18n.getText("admin.common.words.hide")
      Key Status/Resolution FixVersion
      CSHARP-6152 Blocked
      JAVA-6270 Blocked
      INTPYTHON-1036 Needs Triage
      PHPLIB-1924 Blocked
      $i18n.getText("admin.common.words.show")
      #scriptField, #scriptField *{ border: 1px solid black; } #scriptField{ border-collapse: collapse; } #scriptField td { text-align: center; /* Center-align text in table cells */ } #scriptField td.key { text-align: left; /* Left-align text in the Key column */ } #scriptField a { text-decoration: none; /* Remove underlines from links */ border: none; /* Remove border from links */ } /* Add green background color to cells with FixVersion */ #scriptField td.hasFixVersion { background-color: #00FF00; /* Green color code */ } #scriptField td.willNotDo { background-color: #FF0000; /* Red color code */ } /* Center-align the first row headers */ #scriptField th { text-align: center; } Key Status/Resolution FixVersion CSHARP-6152 Blocked JAVA-6270 Blocked INTPYTHON-1036 Needs Triage PHPLIB-1924 Blocked

      Summary

      What is the problem or use case, what are we trying to achieve?

      Customers use embeddedDocuments to model one-to-many relationships, however, this results in functionality gaps with $search.facet and $search.sort, which results in facet counts and sort order being inaccurate because Search doesn't consider which embeddedDocuments are matching.

      New Syntax for $search and $searchMeta: https://docs.google.com/document/d/1urn6HL-StfIjdRRX0pdDvcVJGQcvg-AVFL9zpMcY2TA/edit?tab=t.0 

      Motivation

      Who is the affected end user? Search developer

      Who are the stakeholders?

      How does this affect the end user?

      Blocked from using MongoDB Search, or poor performance using $group or $sort with $filter workaround.

      How likely is it that this problem or use case will occur?

      Common when using embeddedDocuments in Search.

      If the problem does occur, what are the consequences and how severe are they?

      Poor performance, functional gaps in customer application. 

      Is this issue urgent?

      No

      Is this ticket required by a downstream team?

      No

      Is this ticket only for tests?

      Unsure

      Acceptance Criteria

      Within all builders, introduce the ability to:

      • use new parameter within $search.facet.facets.[i].embeddedDocument
      • use new parameter within $search.sort.[i].embeddedDocument

      Launch timeline: Sept 1, 2026. Builder support can be fast follow.

       

            Assignee:
            Unassigned
            Reporter:
            Amy Jian
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: