Lianja 4.2 Query Picker

[barrymavin]

No it uses miller columns above a data grid. If there are no Miller columns it’s not a Query Picker it would just be a data grid and that’s not what it’s for.

You need to adjust the columncount. You have it set to 1 but you have two columns. I will look into using one column as I can see the use of that but it’s not what Miller columns are for.

... to answer your other question, no a column is a column from a table not a grid. So you cannot have multiple columns as one column.

[phabio]

Ok...
So, in the main example, I can't have "Customer ID" and "Customer name"...
so, it's not easy to get the right customer..

[barrymavin]

Ok...
So, in the main example, I can't have "Customer ID" and "Customer name"...
so, it's not easy to get the right customer..

Ill take a look and see. I can see the use case.

[barrymavin]

Hi Fabio,

I have extended this in 4.2Beta18 so that the cascading lists can contain multiple columns which can include keyLookup() or other calculations. See screen shot below.

[HankFay]

Wonderful!

[phabio]

Fantastic

[phabio]

	m_database 		= "database=southwind"
	m_table 		= "table=products"
	m_tabletitle 	= "tabletitle=Item Details"
	m_selectcolumn 	= "selectcolumn=productid"
	m_columncount 	= "columncount=1"
	m_columntitles 	= "columntitles=Categories"
	m_columns 		= "columns=categories,categoryid:categoryname|products,productid,categoryid=%7B%7D"
	m_columnsorderby = "columnsorderby=||"
	m_picklist 		= "picklist=products|productid,productname|categoryid=%7B%7D"
		
	m_par = m_database + "&" + m_table + "&" + m_tabletitle + "&" + m_selectcolumn + "&" + m_columncount + "&" + m_columntitles + "&" + m_columns + "&" + m_columnsorderby + "&" + m_picklist
	? m_par
	
	
	Lianja.showQueryPickerPanel("Browse Items", "", "southwind", "products", m_par, 900)

this, work fine.

the only left question is:
I've try with this:
m_picklist = "picklist=products|productid,productname|1=1"
on the bottom, I see all the "Products".. great
and the search work fine


have you see if is possible to hide the top column and show only the picklist?

one suggestion..
if I set "columncount=-1"
you show only the picklist.. and the query are performed without to click on the header grid.. :-)

[barrymavin]

Thats not what its designed to do. You filter down through related data. Its not just a searchable grid.

[phabio]

Ok..
it's planned to create a searchable grid?
thanks
Fabio

[barrymavin]

Ok..
it's planned to create a searchable grid?
thanks
Fabio

If you submit an ER it will be considered but not in 4.2 which will ship this week. It’s already a massive release.