Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Major - P3 Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5.5
    • Component/s: Geo, Querying
    • Labels:
    • Backport:
      No
    • # Replies:
      9
    • Last comment by Customer:
      true
    • Driver changes needed?:
      No driver changes needed

      Description

      In some cases it would be useful to do combinations of geospatial queries using $or, or $all, to do geospatial union or intersection.

      1. server3984.js
        1 kB
        Benety Goh

        Issue Links

          Activity

          Hide
          Alex
          added a comment -

          +1

          Show
          Alex
          added a comment - +1
          Hide
          Dawid
          added a comment -

          Example I had database witch job offers:

          Some jobs are with multi localization OK no problem i solved this

          But some are specify only to some region

          Eq:
          lat => 21,131231 , 12,43243241
          $and => province => 12

          and Question How i make this ?

          SELECT * FROM jobs WHERE province = 12 AND geo NEAR($LAT);

          Imprisbre

          Yep i can make spageti code add to LAT all city in province about 3 thousand

          A

          Show
          Dawid
          added a comment - Example I had database witch job offers: Some jobs are with multi localization OK no problem i solved this But some are specify only to some region Eq: lat => 21,131231 , 12,43243241 $and => province => 12 and Question How i make this ? SELECT * FROM jobs WHERE province = 12 AND geo NEAR($LAT); Imprisbre Yep i can make spageti code add to LAT all city in province about 3 thousand A
          Hide
          Jaakko
          added a comment -

          +1

          Meanwhile, a workaround would be much appreciated.

          Show
          Jaakko
          added a comment - +1 Meanwhile, a workaround would be much appreciated.
          Hide
          Tim Xi
          added a comment -

          I think this feature is very import for our project. We need search members who are within multiple polygons with $or

          Show
          Tim Xi
          added a comment - I think this feature is very import for our project. We need search members who are within multiple polygons with $or
          Hide
          Shuo Chang
          added a comment -

          +1 Any update on this?

          Show
          Shuo Chang
          added a comment - +1 Any update on this?
          Hide
          Daniel Kador
          added a comment -

          Kind of annoying that I can't put my geo query inside of an $and expression with my other clauses. Makes the code a bit harder to write even though it's identical to just listing the clauses without the $and.

          Show
          Daniel Kador
          added a comment - Kind of annoying that I can't put my geo query inside of an $and expression with my other clauses. Makes the code a bit harder to write even though it's identical to just listing the clauses without the $and.
          Hide
          Ryan Cino
          added a comment -

          This is strongly, and negatively, affecting our ability to get a key feature out for our app. Is there a known workaround for the time being?

          Show
          Ryan Cino
          added a comment - This is strongly, and negatively, affecting our ability to get a key feature out for our app. Is there a known workaround for the time being?
          Hide
          Robert Ignacz
          added a comment -

          It would be useful

          Show
          Robert Ignacz
          added a comment - It would be useful
          Hide
          Githook User
          added a comment -

          Author:

          {u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

          Message: SERVER-3984 added support for $or and geo queries
          Branch: master
          https://github.com/mongodb/mongo/commit/e34325d78543aca3a9f37469aee64c8a9bd23772

          Show
          Githook User
          added a comment - Author: {u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'} Message: SERVER-3984 added support for $or and geo queries Branch: master https://github.com/mongodb/mongo/commit/e34325d78543aca3a9f37469aee64c8a9bd23772

            People

            • Votes:
              34 Vote for this issue
              Watchers:
              32 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since reply:
                22 weeks ago
                Date of 1st Reply: