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 is disabled.
Example:
ll.ViewFeatures = "MyView"
ll.ViewFeatures = "(select * from lwaters_FEA where lwaters_FEA.UID IN (SELECT UID from lwaters_FEA where name like 'a%') )"
Note:
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.