#965 – advanced search by ad_vectormap

In advanced search I can select several provinces. It seems very logical to me because you can search in your province and surroundings. But the sql that it generates does it with "LIKE".

SELECT adext. *, A.id FROM .... WHERE ... AND (a.ad_vectormap LIKE '% [{"code": "ES-M", "name": "Madrid"}, {"code" : "ES-TO", "name": "Toledo"}, {"code": "ES-GU", "name": "Guadalajara"}]% ') AND ... GROUP BY a.id
this sql should look something like this:
AND (a.ad_vectormap IN ('% {"code": "ES-M", "name": "Madrid"}%', '% {"code": "ES-TO", "name": "Toledo "}, '% {" code ":" ES-GU "," name ":" Guadalajara "}%')
to collect the three provinces.

If it is not possible, how to make the election of the provinces only be able to choose one?

Hello,

You are free to custom the code if you like, however it is not part of the support.

Regarding you message, I need to take a look at the code.
The vector map plugin hasn't needed a change in a long time, so I will run some test.

Best regards.

Thanks.
It is simply that in advanced search you can choose two or more provinces, but in the search it does not filter ads that are in those provinces, but rather it filters by ads that all the selected provinces owe. And it is impossible.

Hello,

Ok, if it does that then this is clearly an issue.

I will take a look.

Best regards.

Hello,

Ok there is a mistake in the plugin.

Open the file images/com_adsmanager/plugins/vectormap/plug.php

And replace, line 167:

//$values = json_decode($value);
$values = $value;

By

$values = json_decode($value);
//$values = $value;

Best regards.

Perfect. It works.
Thanks.