-
2 Attachment(s)
I have enhanced the QueryPicker so now it can display a searchable grid.
Just specify showcolumns=false in your parameters.
Attachment 1710
And the result is...
Attachment 1711
Bear in mind that this loads the whole grid in one go so that it is free text searchable.
-
Another Brick In The Wall...
great Barry!
do you have modified only the rsp or also the ShowQueryPickerPanel?
Fabio
-
Hi Fabio,
It’s a WebViewWidget. All I needed to do was edit the rsp file.
-
Good, I wait the next beta to test it.
Thanks
Fabio
-
Hi,
I'm triyng to use the QueryPicker with only the picklist
Code:
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
-
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.
-
Ok, I try, but in the sample you have all the tables.
-
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
-
Strange..
this, work: 1 column and 1 detail
Code:
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:
Code:
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
-
also with SouthWind data:
Code:
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