Re: [web2py] Re: Querying data using admin

Ramos: Other posibility is create a form using grid and then choose columns you want to show, for example: def query_venta(): query = (db.tventa.id >= 3) & (db.tventa.id <= 7) columns = [db.tventa.fecha, db.tventa.monto]] grid=SQLFORM.grid(query,field_id = db.tventa.id,fields=

Re: [web2py] Re: Querying data using admin

Yes it works now. Too bad that i cannot only return some of the columns. It would be perfect because i have many columns and i have to scroll to the right a lot. 2016-06-09 14:55 GMT+01:00 isi_jca : > Hello!!! > > Try using Parenthesis, for example: > > (db.tventa.id >= 3) & (db.tventa.id <= 7

[web2py] Re: Querying data using admin

Hello!!! Try using Parenthesis, for example: (db.tventa.id >= 3) & (db.tventa.id <= 7) Result Set tventa.id tventa.fecha tventa.vendedor

Re: [web2py] Re: Querying data using admin

Oops Thank you Anthony António 2016-06-09 14:39 GMT+01:00 Anthony : > (db.amostras.n==203027) & (db.amostras.estante1=="_E_000") -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/l

[web2py] Re: Querying data using admin

Same rules as usual apply -- you need parentheses: (db.amostras.n==203027) & (db.amostras.estante1=="_E_000") Anthony On Thursday, June 9, 2016 at 5:29:39 AM UTC-4, Ramos wrote: > > hello > how can i, via admin query a table using in the input box more than 1 > field to query? > > i tried > db