I would guess something like that (haven't fully understood what you
want, though...) could be achieved via the "sql_where" definition in the
XML file,
I found an old sample like
<searchitem name="cmeu01" description="Communes">
<layer type="postgis" name="cmeu01">
<field type="s" name="cmbname" description="Name" wildcard="1"/>
<field type="n" name="id" description="Commune ID"/>
<sql_from>cmeu01</sql_from>
<sql_where>(cmbname ~* '[cmbname]' OR cminame ~* '[cmbname]') AND
id = [id]</sql_where>
</layer>
</searchitem>
If the <sql_from> tag is really used I don't remember any more.
armin
On 07/11/2014 09:08 PM, Pedro Venâncio wrote:
> Hi,
>
> Do you think this is possible just configuring the search in the
> config_xxx.xml? I've tried several ways, but without success.
>
>
> Thanks.
>
> Best regards,
> Pedro
>
>
>
>
>
> ----- Mensagem original -----
>> DE: Pedro
>>
>> 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
>>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
------------------------------------------------------------------------------
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
