I've been looking at ways to provide a consistent way to query and select an item from related tables as this has been asked on numerous occasions.
In Lianja 4.2 we already have the "Custom Query Builder".
I have now combined "Miller Columns" with a browsable and searchable data grid.
The cascading lists of the "Miller Columns" and the data grid have a small "Search" icon which when clicked slides in the query builder allowing you to filter the individual columns and grid.
I'm still refining this prior to general release. It operates across desktop, web and mobile. I will document its usage in due course.
A picture says a thousand words. See below.
The dialog button delegate.
The "Query Picker" in operation.
Using the Query Builder to filter records fo selection.
Bookmarks