<html><body>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);">Hi,</div>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);"> </div>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);">Sorry about that, here is a
new set.</div>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);">It did not work
either.</div>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);"> </div>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);">Map file:</div>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);"> </div>
<div style="font-size: 13.3333px; font-family: tahoma; color: rgb(0, 0, 0);
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);">
<div>MAP<br />
NAME
"C2"<br />
IMAGETYPE JPEG<br />
EXTENT 1449000 6849000
1456000 6859000<br />
SIZE 500 500<br />
UNITS METERS<br />
# SHAPEPATH "c:\TMP\"<br />
IMAGECOLOR 255 255 255<br />
FONTSET
"c:\data\mapserverfonts\fonts.list"<br />
DEBUG 5<br />
CONFIG "MS_ERRORFILE"
"/ms4w/tmp/ms_error.txt"</div>
<div> OUTPUTFORMAT<br />
NAME "jpeg"<br />
DRIVER AGG/JPEG<br />
MIMETYPE "image/jpeg"<br />
IMAGEMODE RGB<br />
EXTENSION "jpg"<br />
FORMATOPTION "GAMMA=0.75"<br />
END<br />
<br />
LAYER<br />
NAME "X"<br />
GROUP "X"<br />
CONNECTIONTYPE oraclespatial<br />
CONNECTION "c2/c2a@//192.168.0.101/fwt"<br />
# DATA KARTOBJ_SDO FROM
c2.KARTA$TMP2 WHERE SDO_FILTER( KARTOBJ_SDO, MDSYS.SDO_GEOMETRY(2003,
-1,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),SDO_ORDINATE_ARRAY(393339,6773950,394169,6774780)),'querytype=window')
= 'TRUE'<br />
DATA "KARTOBJ_SDO FROM c2.KARTA$TMP2"<br />
FILTER ("[ID]"="BJDA1")<br />
STATUS ON<br />
TYPE POLYGON<br />
MINSCALEDENOM 2000<br />
MAXSCALEDENOM 5000000<br />
DEBUG 5</div>
<div> CLASS<br />
STYLE<br />
OUTLINECOLOR 255 0 0<br />
END <br />
END<br />
END<br />
END</div>
</div>
<div style="font-family: tahoma; color: rgb(0, 0, 0); font-size: 13.3333px;
font-weight: 400; font-style: normal; background: none 0% 0% / auto repeat
scroll padding-box border-box rgba(0, 0, 0, 0);">
<div>Debug:</div>
<div>[Wed Jan 20 11:46:47 2016].919000 msDrawMap(): rendering using
outputformat named jpeg (AGG/JPEG).<br />
[Wed Jan 20 11:46:47 2016].919000 msDrawMap(): WMS/WFS set-up and query,
0.000s<br />
[Wed Jan 20 11:46:47 2016].919000 msOracleSpatialLayerOpen called with:
KARTOBJ_SDO FROM c2.KARTA$TMP2 (Layer pointer 086AB118)<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerOpen. Shared
connection not available. Creating one.<br />
[Wed Jan 20 11:46:47 2016].950000
msConnPoolRegister(X,c2/c2a@//192.168.0.101/fwt,0DA8F108)<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerFreeItemInfo was
called.<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerInitItemInfo was
called.<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerTranslateFilter.
String: "[ID]"="BJDA1" <br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerTranslateFilter. There
are tokens to process <br />
[Wed Jan 20 11:46:47 2016].950000 total filter tokens are 3<br />
,[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerWhichShapes was
called.<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT ID, rownum, KARTOBJ_SDO FROM
c2.KARTA$TMP2 WHERE ID = 'BJDA1' AND SDO_FILTER(
KARTOBJ_SDO, MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates),'querytype=window')
= 'TRUE'<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerWhichShapes. Bind
values: srid:-1 minx:393339.500000 miny:6773950.000000
maxx:394169.500000 maxy:6774780.000000 <br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerWhichShapes getting
ordinate definition.<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerWhichShapes converting
to OCIColl.<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerWhichShapes bind by
name and object.<br />
[Wed Jan 20 11:46:47 2016].950000 msOracleSpatialLayerWhichShapes name and
object now bound.<br />
[Wed Jan 20 11:46:47 2016].965000 msOracleSpatialLayerFreeItemInfo was
called.<br />
[Wed Jan 20 11:46:47 2016].965000 msOracleSpatialLayerClose was called.
Layer: 086AB118, Layer name: X<br />
[Wed Jan 20 11:46:47 2016].965000 msOracleSpatialLayerClose. Cleaning
layerinfo handlers.<br />
[Wed Jan 20 11:46:47 2016].965000 msOracleSpatialLayerClose. Release the
Oracle Pool.<br />
[Wed Jan 20 11:46:47 2016].965000
msConnPoolRelease(X,c2/c2a@//192.168.0.101/fwt,0DA8F108)<br />
[Wed Jan 20 11:46:47 2016].965000
msConnPoolClose(c2/c2a@//192.168.0.101/fwt,0DA8F108)<br />
[Wed Jan 20 11:46:47 2016].965000 msDrawMap(): Layer 0 (X), 0.046s<br />
[Wed Jan 20 11:46:47 2016].965000 msDrawMap(): Drawing Label Cache,
0.000s<br />
[Wed Jan 20 11:46:47 2016].965000 msDrawMap() total time: 0.046s<br />
[Wed Jan 20 11:46:47 2016].997000 msFreeMap(): freeing map at 086A4BC0.<br />
[Wed Jan 20 11:46:47 2016].997000 msOracleSpatialLayerClose was called.
Layer: 086AB118, Layer name: X<br />
[Wed Jan 20 11:46:47 2016].997000 freeLayer(): freeing layer at
086AB118.</div>
<div> </div>
<div>Björn D</div>
<div> </div>
<blockquote style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">-----Original
Message-----<br />
From: thomas bonfort <thomas.bonfort@gmail.com><br />
To: Björn Danielsson <bjorn.danielsson@falubo.se><br />
Cc: Michael Smith <michael.smith.erdc@gmail.com>, MapServer Dev
Mailing List <mapserver-dev@lists.osgeo.org><br />
Date: Wed, 20 Jan 2016 10:41:12 +0100<br />
Subject: Re: [mapserver-dev] [EXTERNAL] Problem with filter in Oracle<br />
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>
<div
style="font-size:13.3333px;font-family:tahoma;color:rgb(0,0,0);font-weight:400;font-style:normal;background:none
0% 0%/auto repeat scroll padding-box border-box rgba(0,0,0,0)">
<div>
<div><br />
FILTER "([ID='BJDA1')"</div>
</div>
</div>
</div>
</blockquote>
<div><span style="color:rgb(0,0,0);font-family:tahoma;font-size:13.3333px">
Same result. Does not work with filter active, works when the filter line is
commented.</span> </div>
<div> </div>
<div>Your FILTER line is syntactically incorrect. Try with</div>
<div> </div>
<div>FILTER ("[ID]"="BJDA1") </div>
<div> </div>
<div>if using Mapserver 7, or</div>
<div> </div>
<div>FILTER "ID='BJDA1'"</div>
<div> </div>
<div>for mapserver < 7</div>
<div> </div>
<div>--</div>
<div>thomas</div>
<div> </div>
</div>
</div>
</div>
</blockquote>
</div>
</body></html>