-
4 Attachment(s)
Lianja 4.2 Query Picker
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.
Attachment 1685
The dialog button delegate.
Attachment 1686
The "Query Picker" in operation.
Attachment 1687
Using the Query Builder to filter records fo selection.
Attachment 1688
-
I'm touched ... :o
another step to the best RAD!
thanks Barry!
you are welcome in Italy!
Fabio
-
2 Attachment(s)
The "Query Picker" is now fully working across desktop, web and mobile. Doc to come. This is included in 4.2Beta14.
Attachment 1690
Attachment 1691
-
Hi Barry
it's fantastic.
in the demo, what is the fourth parameter?
Lianja.showQueryPickerPanel("Browse Orders", "myCallback()", "southwind", "order_details");
I suppose it is "what needs to be analyzed", but I do not find how it is defined.
thanks
Fabio
-
Hi Fabio,
I'm currently documenting it.
https://www.lianja.com/doc/index.php/QueryPicker
So read through that doc if if you have any questions let me know. I'll add some additional explanations regarding params.
-
Ok, I try to play with parameters..
-
Hi Barry, I'm tryng.. without a good results..
but I've a question:
if I need to browse only one table.. it's possible?
-
Now, I'me try with this parameters:
database=southwind&
table=products&
tabletitle=Item Details&
selectcolumn=productid&
columncount=1&
columntitles=Categories&
columns=categories,categoryid|products,productid,p roductname,categoryid={}&
columnsorderby=||&
picklist=products|productid,productname|categoryid ={}
but don't work.
-
Hi Fabio,
See the latest updates to the parameters table. The {} should be encoded: %7B%7D
Regards,
Yvonne
-
YES!
now is better..
this work
Code:
m_par = [database=southwind&table=products&tabletitle=Item Details&selectcolumn=productid&columncount=1&columntitles=Categories&columns=categories,categoryid|products,productid,categoryid=%7B%7D&columnsorderby=||&picklist=products|productid,productname|categoryid=%7B%7D]
Lianja.showQueryPickerPanel("Browse Items", "", "southwind", "products", m_par, 900)
2 questions:
is possible to add a column to the "Coategories?
I've try with
Code:
m_par = [database=southwind&table=products&tabletitle=Item Details&selectcolumn=productid&columncount=1&columntitles=Categories&columns=categories,categoryid<b>,categoryname</b>|products,productid,categoryid=%7B%7D&columnsorderby=||&picklist=products|productid,productname|categoryid=%7B%7D]
Lianja.showQueryPickerPanel("Browse Items", "", "southwind", "products", m_par, 900)
but not work
If I don't need to have 2 table?
It's possible to only have the products table?