Details
-
Type:
extRequest
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Component/s: CreatiFI
-
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
-
HELP-4548
FIWARE.Request.Tech.WebUI.POIDataProvider.bounding box search does not filter the results based on given category/categories
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Component/s | CreatiFI [ 10357 ] |
| Assignee | Ari Okkonen [ ariokkon ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Link | This issue is cloned by HELC-822 [ HELC-822 ] |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
| Assignee | Ari Okkonen [ ariokkon ] | Silvio Cretti [ silvio.cretti ] |
| 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.Coach.CreatiFI.General Support #308: Bug: POI Data Provider bounding box search does not filter the results based on given category/categories |