you can virtually execute any SQL WHERE clause via the search using the sql_where="" definition that you can apply on the database itself via DB query tools. If you cannot create a SQL statement that gives you back the results you need, then you will also not get in it in p.mapper.
armin On Thu, Dec 17, 2009 at 12:05 AM, G. Allegri <gioha...@gmail.com> wrote: > Ok, I've read again the docs and the squery,php code. Now it's clear > how things work, and I see that the actual code doesn't permit what > I'm looking for... > I will try to code it and I will share if somthing useful comes out. > > giovanni > > 2009/12/16 G. Allegri <gioha...@gmail.com>: >> Thanks Armin for the quick reply. >> The problem is not with the join, my doubt is about how to use it :) >> >> I have the following structure: >> >> GRID >> ------------------------------------ >> | gid | the_geom | >> ------------------------------------ >> | 1 | MULTYPOLYGON..| >> | 2 | MULTYPOLYGON. | >> | 3 | MULTYPOLYGON..| >> | .... | ..... | >> >> >> RAINFALL_TS >> ------------------------------------ >> | gid | rainfall | >> ------------------------------------ >> | 1 | 5 | >> | 1 | 10.4 | >> | 1 | 1.3 | >> | .... | ..... | >> >> From the docs it's not clear to me how to query RAINFALL_TS to >> retrieve tha unique "gid" values to select/highlight the cells from >> GRID... >> >> I've read: >> http://svn.pmapper.net/trac/wiki/FaqConfiguration#Joinstoexternaldatabasetables >> http://svn.pmapper.net/trac/wiki/DocManualsearch >> >> both seem to refer on the reverse need: retrieve attributes from >> joined tables, while I need to retrieve the unique gids from them. >> >> Am I missing something? >> I'm sorry if I'm asking stupid questions... >> giovanni >> >> >> >> >> 2009/12/16 Armin Burger <armin.bur...@gmail.com>: >>> On 16/12/2009 20:04, G. Allegri wrote: >>>> >>>> Hello list. >>>> Before spending too much time on this, I would like to know if the >>>> trunk beta supports this thing: >>>> >>>> I have a big postgis table with a time series (TS) associated with a >>>> polygonal grid layer. For each polygon/cell I have multiple rows in >>>> the TS table. Let's say I have the list od daily rainfall. >>>> I need to let the user query the TS table to see if there is ANY cell >>>> where the daily rainfall have exceeded a certain threshold. >>>> (The truth is that I have many TS tables, coming from different >>>> simulations, and one single vector layer...) >>>> >>>> So, the user should be able to do a Search for Rainfall values higher >>>> then X, and receive all the cells where it happens. >>>> >>>> The actual code seems to offer many ways to deal with multiple joins, >>>> but nothing seems to respond to my need. Am I wrong? Is this already >>>> available or should I code it? >>> >>> >>> There is no special support for joins in Postgis layers in p.mapper, just >>> use the functionality of the database for all sorts of joins and be aware of >>> the special settings for this in the DATA parameter map file. I usually use >>> DB views that do all the join definitions instead of defining the join in >>> the map file. If the search does exactly what you want I cannot say, but you >>> can define the full SQL statement in the search definition. Just check the >>> docs and samples. >>> >>> armin >>> >>> >>> >> > ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
