Hi, I'm trying to create a search of type suggest, that search multiple columns of a PostGIS layer, at the same time.
For example, col1 | col2 a | b c | d e | f ... I tried this: <searchitem name="n_casas" description="Casas"> <layer type="postgis" name="tipo"> <field type="s" name="col1" alias="nomes" description="Nome" wildcard="0" operator="OR"> <definition type="suggest" connectiontype="db" minlength="0" sort="asc"> <dsn encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia</dsn> <sql>SELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~* '[search]' ORDER BY col1</sql> </definition> </field> <field type="s" name="col2" alias="nomes" operator="OR"> <definition type="suggest" connectiontype="db" minlength="0" sort="asc"> <dsn encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia</dsn> <sql>SELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~* '[search]' ORDER BY col2</sql> </definition> </field> </layer> </searchitem> This way I can search and get the correct result. However, two fields are displayed to do the search (image attached), and I want to just get one field, where it does the search for the values of the two columns (col1 and col2). Any suggestions? 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
