date:20140711

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

2014-07-11 Thread Pedro Venâncio

Hi Armin,

Thank you very much for your help!

My goal is to have only one search form field, and use the value inserted there 
to do the search in two columns at the same time. That is, search the same 
value in both columns.

For example, this table

id | col1 | col2
1 | 2001 | 2005
2 | 2006 | 2008
3 | 2007 | 2011
4 | 2008 | 2013
...

I want to something like this query

SELECT id, col_1, col2 FROM table 
WHERE col_1 ilike '%2008%' OR col_2 ilike '%2008%' 
ORDER BY col_1

to obtain this result

id | col1 | col2
2 | 2006 | 2008
4 | 2008 | 2013


Do you think this is possible?


Thanks!

Best regards,
Pedro

--
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

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

2014-07-11 Thread Armin Burger

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


   
 
 
 cmeu01
 (cmbname ~* '[cmbname]' OR cminame ~* '[cmbname]') AND 
id = [id]
   



If the  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:
>>
>> 
>>  
>>  > alias="nomes" description="Nome" wildcard="0"
>> operator="OR">
>>  > connectiontype="db" minlength="0" sort="asc">
>>  > encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia
>>  SELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~*
>> '[search]' ORDER BY col1
>>  
>>  
>>  > alias="nomes" operator="OR">
>>  > connectiontype="db" minlength="0" sort="asc">
>>  > encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia
>>  SELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~*
>> '[search]' ORDER BY col2
>>  
>>  
>>  
>> 
>>
>>
>> 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

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

2014-07-11 Thread Pedro Venâncio

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:
> 
> 
>     
>          alias="nomes" description="Nome" wildcard="0" 
> operator="OR">
>              connectiontype="db" minlength="0" sort="asc">
>                  encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia
>                 SELECT DISTINCT col1 FROM xxx.casas WHERE col1 ~* 
> '[search]' ORDER BY col1
>             
>          
>          alias="nomes" operator="OR">
>              connectiontype="db" minlength="0" sort="asc">
>                  encoding="UTF-8">pgsql://xxx:xxx@localhost/cartografia
>                 SELECT DISTINCT col2 FROM xxx.casas WHERE col2 ~* 
> '[search]' ORDER BY col2
>             
>          
>     
> 
> 
> 
> 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

Re: [pmapper-users] No Legend Wanted

2014-07-11 Thread Armin Burger

use this setting in the configuration XML:

swap



On 07/11/2014 06:23 PM, bean wrote:
> Is it possible to prevent the creation of a legend?
>
> I've found a few ways to prevent the creation but they all throw
> errors in the log. I'd like to do this cleanly but I'm not great at
> PHP. Can someone point me in the right direction?
>
> bean
>
> --
> ___
> 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

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

2014-07-11 Thread Armin Burger

now also committed to pm 4 trunk

http://svn.pmapper.net/trac/changeset/1338



On 07/11/2014 07:23 PM, Armin Burger wrote:
> the layout samples *.phtml files have not been updated to reflect some
> changes a while ago for allowing custom orders of JS files.
>
> In your map_plainlayout*.phtml files search for the line (around line 66)
>   echo $jsConfigReference;
>
> and add afterwards the additional line:
>   echo $jsCustomReference;
>
> Then the custom.js from the config directories should be loaded. The
> "map_default.phtml" already has that correctly set.
>
> armin
>
>
> On 07/11/2014 06:16 PM, nando_gcia wrote:
>> Works perfectly with the "default" folder. I modified the file
>> \pmapper\pmapper_demodata\countries.shp adding a new column called
>> "pdf_files" with the value "data1.pdf" in the country of Spain, after I
>> edited \pmapper-4.3.2\config\default\pmapper_demo.map
>>
>>   "RESULT_FIELDS"
>> "ISOCODE,@default:NAME_EN@de:NAME_DE@it:NAME_IT@fr:NAME_FR@br:NAME_BR@es:NAME_ES,@default:CAPITAL_EN@de:CAPITAL_DE@it:CAPITAL_IT@fr:CAPITAL_FR@br:CAPITAL_BR@es:CAPITAL_ES,AREA_KM2,POPULATION,pdf_files"
>>   "RESULT_HEADERS" "ISO Code,Name,Capital,Area,Population,Pdf Files"
>>   "RESULT_HYPERLINK" "pdf_files||Link to detail"
>>
>> And it works perfectly, so the problem is that the template plainlayout3.
>> Also js_config.php file is different than exists in the "default" folder.
>>
>> Can anyone help me fix it?
>>
>>
>>
>> --
>> View this message in context: 
>> http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025523.html
>> Sent from the pmapper-users -- p.mapper users mailing list mailing list 
>> archive at Nabble.com.
>>
>> --
>> ___
>> 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
>

--
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

2014-07-11 Thread Armin Burger

the layout samples *.phtml files have not been updated to reflect some 
changes a while ago for allowing custom orders of JS files.

In your map_plainlayout*.phtml files search for the line (around line 66)
 echo $jsConfigReference;

and add afterwards the additional line:
 echo $jsCustomReference;

Then the custom.js from the config directories should be loaded. The 
"map_default.phtml" already has that correctly set.

armin


On 07/11/2014 06:16 PM, nando_gcia wrote:
> Works perfectly with the "default" folder. I modified the file
> \pmapper\pmapper_demodata\countries.shp adding a new column called
> "pdf_files" with the value "data1.pdf" in the country of Spain, after I
> edited \pmapper-4.3.2\config\default\pmapper_demo.map
>
>  "RESULT_FIELDS"
> "ISOCODE,@default:NAME_EN@de:NAME_DE@it:NAME_IT@fr:NAME_FR@br:NAME_BR@es:NAME_ES,@default:CAPITAL_EN@de:CAPITAL_DE@it:CAPITAL_IT@fr:CAPITAL_FR@br:CAPITAL_BR@es:CAPITAL_ES,AREA_KM2,POPULATION,pdf_files"
>  "RESULT_HEADERS" "ISO Code,Name,Capital,Area,Population,Pdf Files"
>  "RESULT_HYPERLINK" "pdf_files||Link to detail"
>
> And it works perfectly, so the problem is that the template plainlayout3.
> Also js_config.php file is different than exists in the "default" folder.
>
> Can anyone help me fix it?
>
>
>
> --
> View this message in context: 
> http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025523.html
> Sent from the pmapper-users -- p.mapper users mailing list mailing list 
> archive at Nabble.com.
>
> --
> ___
> 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

[pmapper-users] No Legend Wanted

2014-07-11 Thread bean

Is it possible to prevent the creation of a legend?

I've found a few ways to prevent the creation but they all throw 
errors in the log. I'd like to do this cleanly but I'm not great at 
PHP. Can someone point me in the right direction?

bean

--
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

2014-07-11 Thread nando_gcia

Works perfectly with the "default" folder. I modified the file
\pmapper\pmapper_demodata\countries.shp adding a new column called
"pdf_files" with the value "data1.pdf" in the country of Spain, after I
edited \pmapper-4.3.2\config\default\pmapper_demo.map

"RESULT_FIELDS"
"ISOCODE,@default:NAME_EN@de:NAME_DE@it:NAME_IT@fr:NAME_FR@br:NAME_BR@es:NAME_ES,@default:CAPITAL_EN@de:CAPITAL_DE@it:CAPITAL_IT@fr:CAPITAL_FR@br:CAPITAL_BR@es:CAPITAL_ES,AREA_KM2,POPULATION,pdf_files"
"RESULT_HEADERS" "ISO Code,Name,Capital,Area,Population,Pdf Files"
"RESULT_HYPERLINK" "pdf_files||Link to detail"

And it works perfectly, so the problem is that the template plainlayout3.
Also js_config.php file is different than exists in the "default" folder.

Can anyone help me fix it? 



--
View this message in context: 
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025523.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive 
at Nabble.com.

--
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

2014-07-11 Thread nando_gcia

Raffaele, I've read the documentation pmapper, but I do not know how to fix
the "plainlayout3" template to run the Hyperlink. 



--
View this message in context: 
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025522.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive 
at Nabble.com.

--
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

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

2014-07-11 Thread Raffaele Morelli

2014-07-11 13:28 GMT+02:00 nando_gcia :

> I agree with you Raffaele.
>
> <
> http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/file/n4025520/sources_chrome2.jpg
> >
>
> But i don't know how to fix it.
>
>
http://svn.pmapper.net/trac/wiki/DocManual#DirectoryandFileStructure
--
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

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

2014-07-11 Thread nando_gcia

I agree with you Raffaele.


 

But i don't know how to fix it.



--
View this message in context: 
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-PM-Custom-open-Hyperlink-is-not-a-function-tp4025508p4025520.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive 
at Nabble.com.

--
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

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

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

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

Re: [pmapper-users] No Legend Wanted

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

[pmapper-users] No Legend Wanted

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

Re: [pmapper-users] PM.Custom.open Hyperlink is not a function

11 matches

Site Navigation

Mail list logo

Footer information