Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-4548

FIWARE.Request.Tech.WebUI.POIDataProvider.bounding box search does not filter the results based on given category/categories

        Details

        • Type: extRequest
        • Status: Closed
        • Priority: Major
        • Resolution: Done
        • Fix Version/s: 2021
        • Component/s: FIWARE-TECH-HELP
        • Labels:
          None

          Description

          Hi,

          A user reports a bug in the POI Data Provider enabler.

          "The POI Data Provider should allow filtering the POI search results based
          on the 'category' which is an optional property in the fw_core data.

          However at the moment bounding box searches return results from any
          category. The problem is in poi_dp/bbox_search.php in this condition:

          if (isset($esc_categories))

          { $query = "SELECT uuid, category, thumbnail, st_x(location::geometry) as lon, st_y(location::geometry) as lat, st_astext(geometry) as geometry, timestamp, " . "source_name, source_website, source_id, source_licence " . "FROM $fw_core_tbl WHERE ST_Intersects(ST_Geogfromtext('POLYGON(($west $south, $east $south, $east $north, $west $north, $west $south))'), location) " . "AND category in (" . $common_params['categories'] . ") LIMIT " . $common_params['max_results']; }

          else

          { $query = "SELECT uuid, category, thumbnail, st_x(location::geometry) as lon, st_y(location::geometry) as lat, st_astext(geometry) as geometry, timestamp, " . "source_name, source_website, source_id, source_licence " . "FROM $fw_core_tbl WHERE ST_Intersects(ST_Geogfromtext('POLYGON(($west $south, $east $south, $east $north, $west $north, $west $south))'), location) LIMIT " . $common_params['max_results']; }

          The

          if (isset($esc_categories))

          should be

          if (isset($common_params['categories']))

          like it is in poi_dp/radial_search.php."

          Thanks in advance.
          Kr, Xavier Carol.

          _______________________________________________
          Fiware-creatifi-coaching mailing list
          Fiware-creatifi-coaching@lists.fi-ware.org
          https://lists.fi-ware.org/listinfo/fiware-creatifi-coaching

          [Created via e-mail received from: Xavier Carol Rossell <xavier.carol@i2cat.net>]

            Issue Links

            relates to

            extRequest - Request from external stakeholder received in the help desk HELC-796 FIWARE.Request.Coach.CreatiFI.General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories

            • Major - Major loss of function.
            • Closed

              Activity

              Descending order - Click to sort in ascending order
              Transition Time In Source Status Execution Times Last Executer Last Execution Date
              Open Open In Progress In Progress
              		18d 15h 22m 1 Manuel Escriche 19/Oct/15 9:07 AM
              In Progress In Progress Answered Answered
              		2s 1 Manuel Escriche 19/Oct/15 9:07 AM
              Answered Answered Closed Closed
              		1s 1 Manuel Escriche 19/Oct/15 9:07 AM
              fla Fernando Lopez made changes -
              Fix Version/s 2021 [ 12600 ]
              mev Manuel Escriche made changes -
              HD-Enabler POI Provider [ 10898 ]
              HD-Chapter WebUI [ 10842 ]
              mev Manuel Escriche made changes -
              Sender Email xavier.carol@i2cat.net
              mev Manuel Escriche made changes -
              Summary FIWARE.Request.Tech.WebUI.POIDataProvider..General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories FIWARE.Request.Tech.WebUI.POIDataProvider.bounding box search does not filter the results based on given category/categories
              mev Manuel Escriche made changes -
              Summary FIWARE.Request.Tech.General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories FIWARE.Request.Tech.WebUI.POIDataProvider..General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories
              mev Manuel Escriche made changes -
              Summary FIWARE.Request.Tech.WebUI.AugmentedReality..General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories FIWARE.Request.Tech.General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories
              mev Manuel Escriche made changes -
              Summary FIWARE.Request.Tech.General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories FIWARE.Request.Tech.WebUI.AugmentedReality..General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories
              mev Manuel Escriche made changes -
              Summary [Fiware-creatifi-coaching] [CreatiFI Helsinki Hub] General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories FIWARE.Request.Tech.General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories
              mev Manuel Escriche made changes -
              Summary FIWARE.Request.Lab.[Fiware-creatifi-coaching] [CreatiFI Helsinki Hub] General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories [Fiware-creatifi-coaching] [CreatiFI Helsinki Hub] General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories
              mev Manuel Escriche made changes -
              Assignee Backlog Manager [ backlogmanager ] Ari Okkonen [ ariokkon ]
              mev Manuel Escriche made changes -
              Component/s FIWARE-TECH-HELP [ 10278 ]
              Component/s X_MIGRATION [ 11403 ]
              mev Manuel Escriche made changes -
              Resolution Done [ 10000 ]
              Status Answered [ 10104 ] Closed [ 6 ]
              mev Manuel Escriche made changes -
              Status In Progress [ 3 ] Answered [ 10104 ]
              mev Manuel Escriche made changes -
              Status Open [ 1 ] In Progress [ 3 ]
              Hide
              Permalink
              backlogmanager Backlog Manager added a comment -

              Original time span = 17 days, 4:28:31

              Show
              backlogmanager Backlog Manager added a comment - Original time span = 17 days, 4:28:31
              Hide
              Permalink
              backlogmanager Backlog Manager added a comment -

              Assignee before migration = Ari Okkonen

              Show
              backlogmanager Backlog Manager added a comment - Assignee before migration = Ari Okkonen
              backlogmanager Backlog Manager made changes -
              Field Original Value New Value
              Link This issue relates to HELC-796 [ HELC-796 ]
              backlogmanager Backlog Manager created issue -

                People

                • Assignee:
                  ariokkon Ari Okkonen
                  Reporter:
                  fw.ext.user FW External User
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: