I have access to a WFS service which contains a large number (250,000+) of features. It takes a very long time to load into ArcMap and I'd like to be able to filter in the data for the end users as they will only want to see data specific to their program. In version 10, there are options when creating the WFS connection parameters to a) set the Max # of Features & b) set a Filter in XML using the OGC comparison filters like this -
Is there a way to do this in 9.3.1? There's a small textbox labeled 'filter' when you view the table list, but I've tried using the exact XML that works in v10 but I still get all the features. Is this kind of functionality available in 9.3.1? Most of our users will not be in v10 until this fall.
Assuming you are hitting a WFS 1.1.0-capable server then you should be able to append the extra details to the Dataset (i.e. base URL) string. if you are using English then the raw XML should be URL-compliant (my uneducated guess). Something like:
I finally had time to go back and try this. Bruce you were correct - only tweak I had to make was to qualify all of the filter tags with the ogc namespace, otherwise it would connect to the dataset but not filter.
On a side note, I noticed the .fdl files created contain the user name and password as plain text, was hoping at least the password would be encrypted like in a SDE connection file.