[Geomoose-users] How to filter the results of the Selecting Features

[TC Haddad]

Hi Fernando,

So you want the items to show in the map, but not in the select results?
That might be difficult. I see 2 possible options:

- first option is that you can filter the empty records in the database
before display (create a database view). Only items with populated table
values will draw

- second option is to draw empty records and non-empty records as different
LAYERS (one GROUP) and only enable the select template for the LAYER that
has populated table values.

It sounds like option two might be what you need if you want to draw all
items but select only some.

Tanya


On Wed, Jun 24, 2015 at 3:36 AM, Fernando <nando_gcia at hotmail.com> wrote:

> This is the full table of my database:
>
> CREATE TABLE c2_climatizacion
> (
>   gid serial NOT NULL,
>   entity character varying(16),
>   handle character varying(16),
>   layer character varying(254),
>   lyrfrzn smallint,
>   lyrlock smallint,
>   lyron smallint,
>   lyrvpfrzn smallint,
>   lyrhandle character varying(16),
>   color smallint,
>   entcolor smallint,
>   lyrcolor smallint,
>   blkcolor smallint,
>   linetype character varying(254),
>   entlinetyp character varying(254),
>   lyrlntype character varying(254),
>   blklinetyp character varying(254),
>   elevation numeric,
>   thickness numeric,
>   linewt smallint,
>   entlinewt smallint,
>   lyrlinewt smallint,
>   blklinewt smallint,
>   refname character varying(254),
>   ltscale numeric,
>   extx numeric,
>   exty numeric,
>   extz numeric,
>   docname character varying(254),
>   docpath character varying(254),
>   doctype character varying(32),
>   docver character varying(16),
>   tipo character varying(7),
>   nombre character varying(31),
>   dimensione character varying(8),
>   dimensio_1 character varying(9),
>   calibre character varying(6),
>   indentific character varying(7),
>   diametro character varying(50),
>   the_geom geometry(MultiLineString,3857),
>   CONSTRAINT c2_climatizacion_pkey PRIMARY KEY (gid)
> )
>
> And selecting features I show the following results:
>
>   -----------------------------------
> > NOMBRE:
> > TIPO:
> > DIMENSIONES:
> > CALIBRE:
> > DIAMETRO:
>
> But I want that when these 5 columns is empty then not show in the
> results of selecting features.
>
> How I can do?
>
> There any GeoMOOSE programmer can tell me how to modify the file select.php?
> please.
>
> > > _______________________________________________
> > > Geomoose-users mailing list
> > > Geomoose-users at lists.osgeo.org
> > > http://lists.osgeo.org/mailman/listinfo/geomoose-users
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20150624/7e441351/attachment.html>