[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

[Xavier Carol Rossell]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-creatifi-coaching/attachments/20150608/d5fec8ec/attachment.html>