Hi, Moreover you can use a long query to execute (or a view) in the LAYER->DATA parameter. And then specify only the geometric table (it requires all fields that are used for drawing : attributes binding, label, ...) in LAYER->METADATA->PM_RESULT_DATASUBSTITUTION.
This one will be used for drawing, graphical queries, etc... by replacing on the fly the DATA string. Whereas the "normal" DATA string will be used to retrieve attributes values for selections results, attribute queries, ... Thomas Le 26/04/2013 09:26, Suman a écrit : > 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 > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > ------------------------------------------------------------------------------ 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
