When using the layer.ViewFeatures
property, a complicated sub-query can be sent to the database to narrow the dataset.
By setting ViewFeatures
to a non-empty string, the build in TableFeatures
ll.ViewFeatures = "MyView"
ll.ViewFeatures = "(select * from lwaters_FEA where lwaters_FEA.UID IN (SELECT UID from lwaters_FEA where name like 'a%') )"
Selection should return the shape UID number, like a standard TableFeatures returns. The result of the ViewFeatures will be joined with the TableGeometry on UID field.