Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 31

Thread: Lianja 4.2 Query Picker

  1. #21
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,770
    I have enhanced the QueryPicker so now it can display a searchable grid.

    Just specify showcolumns=false in your parameters.

    Name:  Screen Shot 2018-06-22 at 10.46.59 AM.jpg
Views: 83
Size:  16.3 KB

    And the result is...

    Name:  Screen Shot 2018-06-22 at 10.46.26 AM.jpg
Views: 85
Size:  114.0 KB

    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

  2. #22
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    Another Brick In The Wall...

    great Barry!

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

    Fabio

  3. #23
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,770
    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

  4. #24
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    Good, I wait the next beta to test it.

    Thanks
    Fabio

  5. #25
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    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

  6. #26
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,770
    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

  7. #27
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    Ok, I try, but in the sample you have all the tables.

  8. #28
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    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

  9. #29
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    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

  10. #30
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,881
    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

Page 3 of 4 FirstFirst 1234 LastLast

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us