Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5.5
    • Component/s: Geo, Querying
    • Labels:
    • Driver Changes:
      Not 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
          klepa Alex added a comment -

          +1

          Show
          klepa Alex added a comment - +1
          Hide
          userpassword 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
          userpassword 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
          jsalonen Jaakko added a comment -

          +1

          Meanwhile, a workaround would be much appreciated.

          Show
          jsalonen Jaakko added a comment - +1 Meanwhile, a workaround would be much appreciated.
          Hide
          timxi 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
          timxi 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
          changshuo Shuo Chang added a comment -

          +1 Any update on this?

          Show
          changshuo Shuo Chang added a comment - +1 Any update on this?
          Hide
          dkador 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
          dkador 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
          rcino 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
          rcino 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
          robber Robert Ignacz added a comment -

          It would be useful

          Show
          robber Robert Ignacz added a comment - It would be useful
          Hide
          xgen-internal-githook 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
          xgen-internal-githook 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:
                1 year, 18 weeks ago
                Date of 1st Reply: