[mapserver-users] Using JOIN and FILTERITEM

[Guillaume Sueur]

>From http://mapserver.gis.umn.edu/docs/reference/mapfile/join/html2pdf :

Joins are defined within a LAYER object. It is important to understand
that JOINs are ONLY available once a
query has been processed. You cannot use joins to affect the look of a
map. The primary purpose is to enable
lookup tables for coded data (e.g. 1 => Forest) but there are other
possible uses.

Regards,

Guillaume

Nelson Soto a écrit :
> Hello,
> 
>  
> 
> Can I use FILTERITEM after I have done a JOIN?
> 
>  
> 
> I keep getting an error stating it can not find the JOINed field when
> FILTERITEM is used…
> 
>  
> 
> LAYER # Parcels Polygon Layer
> 
>           NAME 'ParcelsAvailableSearch'
> 
>           DATA 'parcels_tiles/parcels.shp'
> 
>           STATUS DEFAULT
> 
>           TYPE POLYGON
> 
>           METADATA
> 
>             qstring_validation_pattern '.'
> 
>           END
> 
>           TEMPLATE 'parcels/itemquery_parcels_flag.html'
> 
>         JOIN
> 
>             NAME extend
> 
>             TABLE 'parcels_tiles/joint.dbf'
> 
>             FROM 'LOC_ID'
> 
>             TO 'LOC_ID'
> 
>             TYPE ONE-TO-ONE
> 
>         END
> 
>  
> 
>           FILTERITEM 'FLD_INT'
> 
>           FILTER /%id4%/
> 
>           CLASS        
> 
>               SYMBOL 'plainline'        
> 
>               SIZE 3        
> 
>               COLOR -1 -1 -1        
> 
>               OUTLINECOLOR 255 255 0
> 
>         END
> 
>  
> 
>   END
> 
>  
> 
> Joint.dbf consists of two fields, LOC_ID and FLD_INT. I need FLD_INT but
> it is subject to change so I need it in a separate file. So, I want to
> generate an item query of everything that matched the FLD_INT which is
> set by another program before hand. Can this be done?
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users

-- 
Guillaume SUEUR
Gérant
Neogeo Technologies SARL
46 RUE MATABIAU
31000 TOULOUSE
Tél : +33 6 74 91 95 20
http://www.neogeo-online.net