If you use the option "Create Base View from Query" to create a base view, any condition added when querying the view will be delegated to the data source if the condition is included in the SQL query using interpolation variables or if the special “WHEREEXPRESSION” interpolation variable is used in the query specification.
Another option to allow delegation to the data source when the data source is JDBC and the query used to create the base view is a SELECT statement is to modify the Wrapper Source configuration on the base view. After creating the base view go to the Advanced screen and then to Search Methods > Wrapper Source Configuration from the Virtual Dataport Administration Tool. Under Wrapper Source Configuration change the Delegate SQL sentence as subquery property to Yes and save the changes. By doing this, VDP will be able to delegate more queries over the base view to the database.
Note: Starting from Denodo 6.0, the property Delegate SQL sentence as subquery is set to ‘Yes’ by default.
If you have a base view created from query with a projection view that contains additional conditions or does not project all the base view fields, the message “Projection/Selection queries cannot be delegated to this database” means that Virtual DataPort will be responsible of performing these operations that can not be delegated them the database because of the base view query definition.
Virtual DataPort Administration Guide: Creating Base Views from SQL Queries(JDBC/ODBC)
Virtual DataPort Administration Guide: Using the WHEREEXPRESSION Variable