Using the 1.1 Web API documentation it seems the IN statement should work. The only thing I noticed was possible spaces before and after the ( ). Who knows maybe this is also broke in 1.2 RC2 as a result of the SDF changes. Can anyone confirm?
<br><br><a href="http://mapguide.osgeo.org/files/mapguide/docs/webapi/index.html">http://mapguide.osgeo.org/files/mapguide/docs/webapi/index.html</a><br><br><a href="http://mapguide.osgeo.org/files/mapguide/docs/webapi/da/ddd/group___filters_and_expressions.html">
http://mapguide.osgeo.org/files/mapguide/docs/webapi/da/ddd/group___filters_and_expressions.html</a><br><br><br><h2><Identifier> IN ( <ValueExpressionCollection> ) </h2>
<p>anInt16 is an Int16 property. In one feature instance the value of anInt16 is
-7033. If you apply <filter>anInt16 IN ( -5995, -7033 ), you select this
feature. </p><pre><?php<br>$queryOptions->AddFeatureProperty("anInt16");<br>$queryOptions->SetFilter("anInt16 IN ( -5995, -7033 )");<br>$featureService->SelectFeatures($featureSrcResourceId, $featClassName, $queryOptions);
<br>?><br>sqlplus> select anInt16 from featclass where anInt16 in ( -5995, -7033 );<br></pre>The Rock<br><br><br><br><div><span class="gmail_quote">On 7/13/07, <b class="gmail_sendername">James Card</b> <<a href="mailto:James.Card@calcad.com">
James.Card@calcad.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">There is apparently no "IN" operator for layer filter expressions that
<br>would allow me to select a list of objects like "FID IN (37,53,249,1391)".<br>It looks like the only option is a series of "OR" statements: "FID=37 OR<br>FID=53 OR FID=249 OR FID=1391". Have I overlooked something somewhere? Is
<br>there a better way of doing this?<br><br>--<br>James Card<br>209-578-5580<br>_______________________________________________<br>mapguide-users mailing list<br><a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org
</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br></blockquote></div><br>