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
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
16d 8m | 1 | Ari Okkonen | 24/Jun/15 9:28 AM | |||||
|
1d 4h 20m | 1 | Ari Okkonen | 25/Jun/15 1:48 PM |
