Hi,
I found something strange in QueryEditor plugin. By doing a search like this
[nome_1] ILIKE '%pedro%'
OR
[nome_2] ILIKE '%campos%'
it does not give the expected result of the second clause. It seems to me that
there may be a bug.
The query POST is (firebug):
&operation=query&layername=tipo&layerType=shape&query=[nome_1] ILIKE
'%25pedro%' OR [nome_2] ILIKE '%campos%'
and the pm_debug.log:
[09-Jul-2014 23:17:25] P.MAPPER debug info
Parameters for REQUEST array
file: query.php->q_execAttributeQuery
Array
(
[operation] => query
[layername] => tipo
[layerType] => postgis
[query] => [nome_1] ILIKE '%pedro%'
OR
[nome_2] ILIKE 'Êmpos%'
[externalSearchDefinition] => 1
[mode] => search
[layerName] => tipo
[firstFld] => nome_1
[qStr] => nome_1 ~* 'pedro' OR nome_2 ~* '^Êmpos'
)
[09-Jul-2014 23:17:25] P.MAPPER debug info
P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd:
SELECT id,
ST_xmin(box3d(the_geom)),
ST_ymin(box3d(the_geom)),
ST_xmax(box3d(the_geom)),
ST_ymax(box3d(the_geom)),
id,tipo,nome_1,nome_2,nome_3,comprada,observ
FROM edificios.casas
WHERE nome_1 ~* 'pedro' OR nome_2 ~* '^Êmpos'
LIMIT 301
That is, it replaces "%campos%" by "Êmpos%". In fact, it replaces the "%ca" by
"Ê" and "%ce" by "Î". And this is because this line on queryeditor.js
query = query.replace('%','%25');
apparently only works for the first "%" of the first clause of WHERE. In the
second clause, it does not replace the "%" by "%25", which will not prevent
"%ca" to be replaced by "Ê".
Anyone confirms?
Thank you very much.
Best regards,
Pedro
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
