[pmapper-users] Search several database columns at the same time with the same search field

[Pedro V. <ped...@ya...>]

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