Lianja.showPickList() in Lianja 6.3

[barrymavin]

It has been a popular request to add support into Lianja for "pick lists" so in Lianja 6.3 I have implemented Lianja.showPickList().

Lianja.showPickList(
    "Select an Order",                         /* title */
    function(rowdata)                          /* onok */
    {
        // rowdata is an object with members for all columns in the active grid record 
        console.log(rowdata);
    },
    function()                                 /* oncancel */
    {
    },
    600,                                       /* width */
    600,                                       /* height */
    "southwind",                               /* database */
    "orders",                                  /* table */
    "",                                        /* filter */
    [                                          /* columns to display */
        {caption: 'CustomerID', controlsource: 'customerid', type: 'C', width: 100},
        {caption: 'OrderID', controlsource: 'orderid', type: 'C', width: 100},
        {caption: 'Order Date', controlsource: 'orderdate', type: 'D', width: 100},
        {caption: 'Required Date', controlsource: 'requireddate', type: 'D', width: 100},
        {caption: 'Shipped Date', controlsource: 'shippeddate', type: 'D', width: 100}
    ]
);

The onok callback is called if the user double clicks a row to select it. It is passed an object which contains members for all columns in the active record.

See screenshots below.



You can search for text across the rows of the grid and a searchfilter is applied.

[leon@doene.net]

Hi Barry,

maybe here also great if onok callback is called if the user presses <ENTER> and the oncancel it <ESC> is pressed, assuming the arrow keys can be used for navigation?

[phabio]

This great new feature are the top if you can add also query picker and sort option.. :-)

[barrymavin]

Hi Fabio

The grid is sortable by clicking on the column headers. In desktop the query picker is built into the grid but not in the web. Maybe later not in 6.3. The search bar satisfies most requirements.

[barrymavin]

Hi Leon,

In desktop apps that is what happens.

If you are using Lianja.showPickList() in LianjaScript/VFP it operates slightly differently.

1. It is modal
2. No onok or oncanel callbacks are needed. These are only for web based javascript apps.
3. It returns a JSON encoded string of the selected record. You can decode this into an object using json_decode() and reference the fields of the record.

[phabio]

excellent as always!

Lasagna for Barry!

[phabio]

Hi Barry
what would be the syntax for a Lianja script?

thanks
Fabio

[barrymavin]

Hi Fabio

jsonresult = Lianja.showPickList( ;
    "Select an Order",  ;               
    600,  ;                              
    600,  ;                                
    "southwind",  ;                    
    "orders", ;                           
    "", ;                               
    “Caption:controlsource:type:width, …”  ;
)

if len(jsonresult) > 0
    result = json_decode( jsonresult )
endif

Notice how the onok and onsuccess callbacks are not needed in LianjaScript as it’s a modal dialog. The column definitions are specified as a comma separated string. The result is a JSON string.

[phabio]

many thanks