Custom Connector and Navigation Tables

What you need to do is use Table.View, it is very powerful as it lets you reinterpate any code that transforms or drills into a table. In paticular you want to include a defination for the handler OnSelectRows:

View= (state) =>

Table.View(null, 

[

GetType = () => ...,

GetRows = () =>  ...,

OnSelectRows = (selector) =>
let
condition = RowExpression.From(selector),

...,

in

@View(newState)

])

The selector will be the abstract syntax tree of the query. If the code returns an error, then the view is handled by default logic and the next higher view in the stack will be tried.