Details
-
Type: extRequest
-
Status: Closed
-
Priority: Major
-
Resolution: Done
-
Fix Version/s: 2021
-
Component/s: FIWARE-TECH-HELP
-
Labels:None
-
Sender Email:
-
HD-Chapter:WebUI
-
HD-Enabler:POI Provider
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
-
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
- Closed
Assignee before migration = Ari Okkonen