[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Peter
Correct Ramesh, That is for viewing the invoice details on screen after the Invoice has been created (taking information from an Invoice_header table and related records in the Line_items) but the Invoice Preview provided to the user appears identical (although the information comes from the

[web2py] Re: Is there any workaround to include 'does not contain' option in SQLform grid search?

2017-07-12 Thread Anthony
On Wednesday, July 12, 2017 at 5:28:03 AM UTC-4, Pranshul Chitransh wrote: > > Thanks for the prompt reply Anthony! Actually this is not quite I was > looking for. I meant to include the 'does not contain' option in the > pre-defined filters that grid already has in its UI. Let me know if the >

[web2py] Re: DAL pg8000 adapter and JSON type

2017-07-12 Thread lyn2py
After switching to psycopg2 I still run into the same errors. However, after I updated to 2.15.1 (after Massimo's announcement on the groups), it now works. On Tuesday, July 11, 2017 at 9:44:19 PM UTC+8, Leonel Câmara wrote: > > pydal uses text for json fields if you're using pg8000 because

[web2py] Re: Python compatibility matrix

2017-07-12 Thread Leonel Câmara
More on this, almost everything should work with python 3 3.5 and 3.6. The known problems right now are: - Markmin - Email signing and encryption. If you find any other problems please report them. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Python compatibility matrix

2017-07-12 Thread Leonel Câmara
The latest web2py support python 2.7, and experimentally pypy and python 3. The best way to actually know what we support is to look at our travis builds: https://travis-ci.org/web2py/web2py -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Python compatibility matrix

2017-07-12 Thread Nico Zanferrari
Hello, the actual (2.5.1) Python compatibility level of Web2py is not so clear to me. I guess: Python 2.5 = unsupported Python 2.6 = still working but deprecated Python 2.7 = supported Python 3 = experimental support - from which version exactly? what is already known to be missing and/or

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Dave, Thanks much for the info. Regards, Ramesh. On Wednesday, July 12, 2017 at 7:44:12 AM UTC+5:30, Dave S wrote: > > > > On Tuesday, July 11, 2017 at 7:07:56 PM UTC-7, Peter wrote: >> >> Hi Ramesh, >> >> I return a crud.read() for the invoice header and a separate query output >> for the

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Peter, Thank you, that could work for reading invoice. I guess it might require a bit more for accepting / creating new invoice... or do I get this wrong. Regards, Ramesh. On Wednesday, July 12, 2017 at 7:37:56 AM UTC+5:30, Peter wrote: > > Hi Ramesh, > > I return a crud.read() for the

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Dave, Thank you and could you post some code please... Regards, Ramesh. On Wednesday, July 12, 2017 at 4:56:14 AM UTC+5:30, Dave S wrote: > > > > On Monday, July 10, 2017 at 9:15:08 PM UTC-7, Ramesh Meda wrote: >> >> Dave, Thank you and appreciated. But, my question was about forms and not

[web2py] Re: Parent - Child (multiple rows / grid) form development

2017-07-12 Thread Ramesh Meda
Stifan, Thank you, will try that approach. :) Regards, Ramesh. On Tuesday, July 11, 2017 at 12:45:47 PM UTC+5:30, 黄祥 wrote: > > in form side, > everything in 1 page i usually use web2py load components: > first component is an sqlform.factory() to select the invoice_items > second component

[web2py] Re: How to display filtered records in drop down for further selection in SQLFORM?

2017-07-12 Thread Pranshul Chitransh
That solved it. Thanks a lot! On Wednesday, July 12, 2017 at 6:06:43 PM UTC+5:30, Leonel Câmara wrote: > > Put some parenthesis on it > > Instead of this > > db(db.all_users.status==1 & db.all_users.username!='John' ) > > Do: > > db((db.all_users.status==1) & (db.all_users.username!='John' ))) >

[web2py] Re: How to display filtered records in drop down for further selection in SQLFORM?

2017-07-12 Thread Leonel Câmara
Put some parenthesis on it Instead of this db(db.all_users.status==1 & db.all_users.username!='John' ) Do: db((db.all_users.status==1) & (db.all_users.username!='John' ))) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: How to display filtered records in drop down for further selection in SQLFORM?

2017-07-12 Thread Pranshul Chitransh
Actually I've already put a query in it. Currently it ready all active users as follows db.table.input_email.requires=IS_IN_DB(db(db.all_users.status==1), 'all_users.username') And I want to further some users based on their name say John so the condition should fulfill all active users but

[web2py] Re: How to display filtered records in drop down for further selection in SQLFORM?

2017-07-12 Thread 黄祥
i think you can put query on that e.g. db.person.name.requires = IS_IN_DB(db(db.person.id > 10), 'person.id', '%(name)s') ref: http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] How to display filtered records in drop down for further selection in SQLFORM?

2017-07-12 Thread Pranshul Chitransh
Hi all I have a SQLFORM/ SQLFORM.grid in which I have to make the user select certain values. I've used the condition to create a drop down list of entries to select from db.table1.column1.requires = IS_IN_DB(db, 'table2.column2') Now from 100 rows in drop down, I want only those rows to be

[web2py] Re: Is there any workaround to include 'does not contain' option in SQLform grid search?

2017-07-12 Thread Pranshul Chitransh
Thanks for the prompt reply Anthony! Actually this is not quite I was looking for. I meant to include the 'does not contain' option in the pre-defined filters that grid already has in its UI. Let me know if the question is not clear. On Thursday, June 15, 2017 at 7:44:27 PM UTC+5:30, Anthony