hello Valerio,
sorry for late reply, if you r still searching the answer and anybody
searching for this answer. then here is solution.
As you asked for to display joined records from external table in query
identify div window, you need to query from DATA tag in map file. like this.
LAYER
NAME "Building Footprint"
TYPE polygon
CONNECTIONTYPE postgis
CONNECTION "dbname=databasename host=localhost port=5432 user=postgres
password=xxxxxxx"
DATA "geom FROM (SELECT a.geom as geom, a.gid as gid, b.tole as tole_b1,
b.houseid as houseid, b.photono as photono FROM tbl_building a,
tbl_socio_economic b WHERE a.join_id = b.join_id) AS building_socio USING
UNIQUE gid"
TRANSPARENCY 30
PROCESSING "CLOSE_CONNECTION=DEFER"
TEMPLATE void
METADATA
"DESCRIPTION" "Building Footprint"
## ADAPTED TO MULTILINGUAL SHAPEFILE
"RESULT_FIELDS" "tole_b1,houseid,photono,area,funct_use"
"RESULT_HEADERS" "tole_b1,houseid,photono,AREA,funct_use"
"ows_title" "Ward"
END # Metadata
CLASS
Name 'All'
COLOR 223 219 212
OUTLINECOLOR 223 219 212
END # Class
END # Layer
And i am using pmapper 4.2.0...
and you can query as more field as you can specifying in DATA query.
cheers,
suman
--
View this message in context:
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.com/pmapper-users-join-to-postgresql-table-problem-tp3822408p4025160.html
Sent from the pmapper-users -- p.mapper users mailing list mailing list archive
at Nabble.com.
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
