Hello,
The only way to do that with p.mapper is modify the layer definition in
your mapfile with your request.
For instance:
DATA "the_geom FROM (SELECT the_geom, name, id, age, ..... FROM ...) AS
foo USING UNQIUE gid"
Or create a view in your DB:
CREATE VIEW your_view_name AS (SELECT the_geom, name, id, age, .....
FROM ...);
Then use it in your mapfile:
DATA "the_geom FROM your_view_name USING UNQIUE gid"
With those 2 methods you will only have the specified fields in p.mapper
(graphical and attribute queries).
Thomas
Le 03/02/2011 16:16, wsbd008 a ??crit :
Hello,
I'm using the QueryEditor. But I think what it does is to change the WHERE
clause but not filter the columns. I'm not sure if p.mapper has this function.
Yuduo
At 2011-02-02 18:01:31??"Michael Gr??n"<gru...@uni-trier.de> wrote:
Hi,
with the plugin QueryEditor it's possible to make more detailed queries....
http://svn.pmapper.net/trac/wiki/PluginsQuery
Cheers, Michael
-----Urspr??ngliche Nachricht-----
Von: wsbd008 [mailto:wsbd...@163.com]
Gesendet: Dienstag, 1. Februar 2011 22:00
An: pmapper-users@lists.sourceforge.net
Betreff: [pmapper-users] Query layer for some columns
Hello to all,
I don't know if p.mapper supports the searching for some particular columns.
It looks like p.mapper just supports like " SELECT * FROM ...." but not "
SELECT name, id, age,... FROM ...".
Does anybody know how to do that? Thank you!
Yuduo
----------------------------------------------------------------------------
--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
