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.
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.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
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.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
Good, I wait the next beta to test it.
Thanks
Fabio
Hi,
I'm triyng to use the QueryPicker with only the picklist
but I got an error and the grid is empty.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)
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.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
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
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 errorCode: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)
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:
if I remove the "m_showcolumns", workCode: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)
Bookmarks