#
# Test of OGR SQL JOIN support via MapServer.  
#
# A joined field is used for the EXPRESSION used to classify the returned 
# polygons.
#   
# REQUIRES: INPUT=OGR OUTPUT=PNG INPUT=SDE
#
# RUN_PARMS: sde_join_getinfo.xml [MAPSERV] QUERY_STRING="service=WMS&request=GetFeatureInfo&layers=shppoly&version=1.1.1&styles=&map=[MAPFILE]&query_layers=shppoly&x=300&y=300&info_format=application/vnd.ogc.gml&srs=EPSG:4326&bbox=1283364.000001,457670.968990,1330430.374999,495313.843989&format=image/png&width=600&height=600" > [RESULT_DEVERSION]
#
#
MAP

STATUS ON
#EXTENT 478300 4762880 481650 4765610
EXTENT 1283364.000001 457670.968990 1330430.374999 495313.843989

SIZE 600 600
PROJECTION
  "init=epsg:4326"
END
IMAGETYPE png

DEBUG ON
   WEB
    IMAGEPATH "/tmp"
    METADATA
     "ows_title"            "ArcSDE MapServer Test"  
     "ows_onlineresource"   "http://127.0.0.1:8888/cgi-bin/mapserv.fcgi" 
     "wfs_srs" "EPSG:4326"
    END
   END  

LAYER
  NAME shppoly
  TYPE polygon
  CONNECTIONTYPE SDE
  CONNECTION "smoke.hobu.net,5151,sde,sde,osgeo"
  DATA "SDE.JOINTESTLAYER,SHAPE,SDE.DEFAULT"
  STATUS on
  TEMPLATE "default.html"
  DEBUG 3
  PROCESSING "JOINTABLE=SDE.JOINTESTTABLE"
  PROCESSING "JOINFROMFIELD=AQ_TAG"
  PROCESSING "JOINTOFIELD=AQ_TAG"
  FILTER "WHERE JOINTESTTABLE.AQ_TAG=JOINTESTLAYER.AQ_TAG"
  CLASSITEM "SDE.JOINTESTTABLE.VAL"
    DUMP TRUE
    METADATA
#      "ows_srs" "EPSG:4326"
      "wfs_title"     "shppoly"
#      "wfs_name" "polys"
      "gml_include_items" "all"
#     "wfs_include_items" "OBJECTID,FCODE,AQNAME"
      "gml_featureid" "OBJECTID"
#      "ows_feature_id" "OBJECTID"
#     "wms_feature_info_mime_type" "text/plain"
    END
  CLASS
    NAME "selected"
    COLOR 0 0 255
    OUTLINECOLOR 255 0 0
    EXPRESSION "val1"
  END
  CLASS
    NAME "normal"
    COLOR 0 255 0
    OUTLINECOLOR 255 0 0
  END
END

END