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

[Armin B. <arm...@gm...>]

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
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>