Using the Query Picker

From Lianjapedia
Revision as of 03:28, 10 June 2018 by Barrymavin (Talk | contribs)

Jump to: navigation, search

Under construction

To keep coding (NoCode) to a minimum there are many built-in WebViewWidgets that can be used with Lianja.showDialogPanel(), Lianja.showDialog() or as the URL in a WebView section or in a custom WebView object created with createObject("webview").

The Query Picker is a powerful WebViewWidget that incorporates the functionality of Miller columns and a searchable data grid. It also has integrated support for drilling down through data using the Query Builder.

A picture says a thousand words so let's look at the Query Picker then see how we can use it in our Apps.

You will typically want to show the Query Picker associated with a specific field in a form or canvas section. You can use the "Dialog Button" to achieve that.


Querypicker1.png


Here the Query Picker will slide in from the right. You can of course have it slide in from the left and optionally animate across the whole of the UI viewport.


Querypicker2.png


Clicking one of the "Search" icons in the column headers or the data grid header will show the Query Builder providing a powerfull means of drilling down through the data currently being queried.


Querypicker3.png


Double clicking on a row in the data grid will select the column of your choice from the grid row and return back sliding the Query Picker out off the screen. You can specify a delegate to be called with one argument which is the value selected.

Let's now look at the ways we can activate the query picker and what parameters we can specify.