Lianja 4.2 Query Picker

[barrymavin]

I have enhanced the QueryPicker so now it can display a searchable grid.

Just specify showcolumns=false in your parameters.



And the result is...



Bear in mind that this loads the whole grid in one go so that it is free text searchable.

[phabio]

Another Brick In The Wall...

great Barry!

do you have modified only the rsp or also the ShowQueryPickerPanel?

Fabio

[barrymavin]

Hi Fabio,

It’s a WebViewWidget. All I needed to do was edit the rsp file.

[phabio]

Good, I wait the next beta to test it.

Thanks
Fabio

[phabio]

Hi,
I'm triyng to use the QueryPicker with only the picklist

		open database southwind
	
	m_database 	= "database=southwind"
	m_table 	= "table=products"			
	m_tabletitle 	= "tabletitle=product"	
	m_selectcolumn 	= "selectcolumn=productid"			
	m_columncount 	= "columncount=1"			
	m_columntitles 	= "columntitles=products"			
	m_columns 	= "columns=" + "products,productid,1=1"
	m_columnsorderby = "columnsorderby="
	m_picklist 	= "picklist=products|productid|1=1"
        m_showcolumns   = "showcolumns=false"
		
	m_par = m_database + "&" + m_table + ;
			"&" + m_tabletitle + ;
			"&" + m_selectcolumn + ;
			"&" + m_columncount + ;
			"&" + m_columntitles + ;
			"&" + m_columnsorderby + ;
			"&" + m_picklist + ;
			"&" + m_showcolumns


	? m_par	 
	
	Lianja.showQueryPicker("Ricerca progetti", "a=1", "southwind", "Products", m_par, 800)

but I got an error and the grid is empty.

where I wrong?

thanks
Fabio

[barrymavin]

Hi Fabio,

Remove the empty parameters and then remove each parameter one by one until you identify the issue. In my example above in this thread it is working as per the screenshot.

[phabio]

Ok, I try, but in the sample you have all the tables.

[phabio]

I get everytime this error
gio nov 1 11:03:18 2018
**** Lianja error ****
odata_read([/southwind/products&$select eq productid], [_00002ef000d7.tmp])
^
Unrecognized phrase/keyword near column 52

[phabio]

Strange..
this, work: 1 column and 1 detail

	m_database 		= "database=SFM"
	m_table 		= "table=documenti"			// la table col massimo dettaglio
	m_tabletitle 	= "tabletitle=Documenti"	// descrizione table col massimo dettaglio
	m_selectcolumn 	= "selectcolumn=ID"			// il campo della tabella selezionata
	m_columncount 	= "columncount=1"			// numero finestrelle sopra al dettaglio
	m_columntitles 	= "columntitles=Progetti"	// titoli			
	m_columns 		= "columns=" + "progetti,clienteid:id:progetto" + "|documenti,descrizione,progettoid=%7B%7D"
	m_columnsorderby = "columnsorderby=progetto|stato"
	m_picklist 		= "picklist=documenti|progettoid,id,descrizione,caso,stato|progettoid=%7B%7D"
	m_showcolumns   = "showcolumns=false"
		
	m_par = m_database + "&" + m_table + ;
			"&" + m_tabletitle + ;
			"&" + m_selectcolumn + ;
			"&" + m_columncount + ;
			"&" + m_columntitles + ;
			"&" + m_columns + ;
			"&" + m_columnsorderby + ;
			"&" + m_picklist 
			/*
			+ ;
			"&" + m_showcolumns 
*/

	? m_par	 
	
	Lianja.showQueryPicker("Ricerca progetti", "a=1", "SFM", "Clienti", m_par, 800)

this:

	m_database 		= "database=SFM"
	m_table 		= "table=documenti"			// la table col massimo dettaglio
	m_tabletitle 	= "tabletitle=Documenti"	// descrizione table col massimo dettaglio
	m_selectcolumn 	= "selectcolumn=ID"			// il campo della tabella selezionata
	m_columncount 	= "columncount=1"			// numero finestrelle sopra al dettaglio
	m_columntitles 	= "columntitles=Progetti"	// titoli			
	m_columns 		= "columns=" + "progetti,clienteid:id:progetto" + "|documenti,descrizione,progettoid=%7B%7D"
	m_columnsorderby = "columnsorderby=progetto|stato"
	m_picklist 		= "picklist=documenti|progettoid,id,descrizione,caso,stato|progettoid=%7B%7D"
	m_showcolumns   = "showcolumns=false"
		
	m_par = m_database + "&" + m_table + ;
			"&" + m_tabletitle + ;
			"&" + m_selectcolumn + ;
			"&" + m_columncount + ;
			"&" + m_columntitles + ;
			"&" + m_columns + ;
			"&" + m_columnsorderby + ;
			"&" + m_picklist + ;
			"&" + m_showcolumns 

	? m_par	 
	
	Lianja.showQueryPicker("Ricerca progetti", "a=1", "SFM", "Clienti", m_par, 800)

return the error
ven nov 2 17:17:59 2018
**** Lianja error ****
odata_read([/SFM/documenti&$select eq progettoid,id,descrizione,caso,stato], [_0000375803a7.tmp])
^
Unrecognized phrase/keyword near column 55

I've added only the clause:
showcolumns=false

[phabio]

also with SouthWind data:

	open database southwind
	
	m_database 		= "database=southwind"
	m_table 		= "table=products"			
	m_tabletitle 	= "tabletitle=product"	
	m_selectcolumn 	= "selectcolumn=productid"			
	m_columncount 	= "columncount=1"			
	m_columntitles 	= "columntitles=products"			
	m_columns 		= "columns=" + "products,productid,productname,1=1"
	m_columnsorderby = "columnsorderby="
	m_picklist 		= "picklist=products|productid,productname|1=1"
        m_showcolumns   = "showcolumns=false"
		
	m_par = m_database + "&" + m_table + ;
			"&" + m_tabletitle + ;
			"&" + m_columntitles + ;
			"&" + m_picklist + ;
			"&" + m_columncount + ;
			"&" + m_showcolumns
	
	Lianja.showQueryPicker("Ricerca progetti", "a=1", "southwind", "Products", m_par, 800)

if I remove the "m_showcolumns", work