Uploaded image for project: 'Nuxeo Documentation'
  1. Nuxeo Documentation
  2. NXDOC-2464

Fix NXQL documentation for geo_bounding_box query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: How-tos / Tutorials

      Description

      The current NXQL documentation for using an ES Hint for geo queries with geo_bounding_box instructs the following:

      -- Use ES for GeoQuery based on geo_bounding location in a bounding box; first param is top_left, followed by bottom_right point
      SELECT * FROM Document WHERE /*+ES: OPERATOR(geo_bounding_box) */ osm:location IN ('40.73, -74.1', '40.01, -71.12')
      

      This does not return the target document when tested. The format should use the left_bottom and right_top coordinates given in the form (lon, lat) as the following:

      -- Use ES for GeoQuery based on geo_bounding location in a bounding box; first param is left_bottom, followed by right_top point
      SELECT * FROM Document WHERE /*+ES: OPERATOR(geo_bounding_box) */ osm:location IN ('-74.1, 40.01', '-71.12, 40.73')
      

        Attachments

        1. 20220607_155558.jpg
          1.05 MB
          Thierry Martins
        2. 20220607_161552.jpg
          659 kB
          Thierry Martins

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: