Possible bug with SQLFORM.grid search and order

[Jeff Plata]

Possible bug when searching in SQLFORM.grid with order activated.

To reproduce:

1. SQLFORM.grid, advanced_search = True

2. Click a column header on the grid to activate 'order'

3. Click 'search' (with or without keyword)

4. Error as follows:

Traceback (most recent call last):
File "C:\Users\User\Desktop\web2py\gluon\restricted.py", line 219, in restricted
exec(ccode, environment)
File "C:/Users/User/Desktop/web2py/applications/bsmOnline/controllers/library.py", line 113, in <module>
File "C:\Users\User\Desktop\web2py\gluon\globals.py", line 430, in <lambda>
self._caller = lambda f: f()
File "C:/Users/User/Desktop/web2py/applications/bsmOnline/controllers/library.py", line 56, in region
create=can_add_library, editable=can_edit_library, deletable=can_delete_library)
File "C:\Users\User\Desktop\web2py\gluon\tools.py", line 3951, in f
return action(*a, **b)
File "C:/Users/User/Desktop/web2py/applications/bsmOnline/models/db1.py", line 78, in library
grid = SQLFORM.grid(query, maxtextlength=80, csv=False, **kwargs)
File "C:\Users\User\Desktop\web2py\gluon\sqlhtml.py", line 2804, in grid
otablename, ofieldname = order.split('~')[-1].split('.', 1)
AttributeError: 'list' object has no attribute 'split'

Upon clicking the 'search' button, it seems that the 'order' in request .vars is transformed from string to list, such that order = 'anykey' becomes 'order = ['anykey', 'anykey'], hence, the error.

Workaround for me:

if request.vars:

    if 'order' in request.vars:

        request.vars.order = request.vars.order[0]

Can somebody please confirm or am I doing something wrong?

[Douglas Krueger]

Hello Jeff, 

I've posted a here but it seems to be pending approval. I notice no responses to your post. Is this site dead? Is Web2py dead? Did everyone go to Django? Thanks in advance for your reply. 

[Clemens]

Hi
web2py is not dead, there are still updates, but mainly concerning security and thus stuff. And web2py is not further developed because the future of this framework is py4web.

Just have a look here to learn the difference between web2py and py4web, because they are very similar:

https://py4web.com/_documentation/static/en/chapter-15.html

Best regards

Clemens

[Douglas Krueger]

Thank you Clemens, 

The differences between web2py and py4web seem minor. Would you suggest new folks start with Py4web?  

Many thanks, 

Doug 

[Clemens]

Hi Jeff,

if you're just starting up, I would suggest to use py4web, since it is the future. I'm still using web2py because I've developed there a bigger system. But sooner or later I'm gonna migrate my system to py4web.

And btw I really like web2py and thus I like py4web too. The community is very active but is already migrated to py4web ;-) Thus, start with py4web.

Best regards

Clemens

[Douglas Krueger]

HI Clemens, 

I noticed the latest post in the py4web label is 3 years old. Where could I find the latest py4web posts? 

thanks again, 

Doug 

[Clemens]

Here they are :-)

https://groups.google.com/g/py4web/

[Jim S]

@doug - I would highly recommend looking at py4web over web2py.  web2py is a fantastic tool, but seems its time has passed.  py4web uses lots of the same concepts and tools, but is re-architected to be more efficient.  There are a few of us that usually always active on the py4web site.  Massimo is around a lot to look at questions and help out with answers.

-Jim