I've attached the 'packed' file of the app. The app:
-uses your table setup (I took the uppercase characters out of your table names - I'm not preaching, but in my experience you don't want to do this) -puts some test data into the degree table -added a page to list the degrees using datatables.net Modified files -added DataTables directory to /static -views/layout.html - added references to datatables css and javascript files -controllers/default - added degrees and _get_degrees methods -created views/default/degrees.html To Run it -Extract the code to your applications directory -fire up web2py -navigate to 127.0.0.1:8000/school/default/degrees You should see the list of degrees. Paging should work and the search filter should work. I didn't add the 'click on the column heading to sort', but you can do all of that as well. Let me know if you have any problems or questions. -Jim web2py.app.school.w2p <https://drive.google.com/file/d/14SQthm4NUpvmWtxEoFyQBHR_hEphlB-J/view?usp=drive_web> On Fri, Jun 14, 2019 at 9:43 AM Cristina Sig <[email protected]> wrote: > Thank you @Jim. I will appreciate if you can share some example because I > have been struggling with this for weeks and I'm really confused with ajax > and server side. > > El viernes, 14 de junio de 2019, 9:39:14 (UTC-3), Jim S escribió: >> >> I believe you are confusing a couple things here. The code you're using >> is trying to use a server-side data set, but the >> >> data:{{=results}}, >> >> is using the results passed to the view as the data to display, not the >> data you're getting back from the ajax call. >> >> I'll try to make some time later this morning to build up a demo for >> you. I've been working with datatables.net and web2py A LOT in the past >> few weeks and have some good working samples, but will need to tear some of >> it down to the bare essentials to make what I have more understandable. >> >> Gotta run but will get back to this in a few hours. >> >> -Jim >> >> >> On Thursday, June 13, 2019 at 6:19:18 PM UTC-5, Cristina Sig wrote: >>> >>> Thank you @John >>> yes, I have been checking DT docs and it seems that I need to add that >>> data, I tried it but the sorting and ordering is not working at all. >>> Do you have any idea or example how to deal with that? >>> >>> El martes, 11 de junio de 2019, 9:43:14 (UTC-3), John Bannister escribió: >>>> >>>> @Leonel .. I think this will work well with client side but not >>>> serverside datables but may be wrong. >>>> >>>> @Cristina: >>>> >>>> My understanding of serverside processing is that you will need to have >>>> a few more items returned to datatables as outlined in the DT docs for >>>> serverside processing. >>>> >>>> Your response to the request from DataTables should look something like >>>> this for serverside processing: >>>> >>>> return dict(draw=sEcho, recordsTotal=iTotalRecords, >>>> recordsFiltered=iTotalRecords, data=aaData) >>>> >>>> You will also need to move your sorting, filtering and ordering to the >>>> server (which is a bit more complicated) but doable. >>>> >>>> As said I could be wrong. >>>> >>>> BR >>>> John >>>> >>>> >>>> On Tuesday, 11 June 2019 10:52:42 UTC+2, Leonel Câmara wrote: >>>>> >>>>> It's because you're not using the generic.json view and you're also >>>>> not setting the response.headers content-type to json. I would simply >>>>> change your function to this which will do everything for you: >>>>> >>>>> def manageCareer(): >>>>> rows = db((db.Career.faculty == db.Faculty.id)&(db.Career.degree >>>>> == db.Degree.id)).select() >>>>> return response.json({'results': rows}) >>>>> >>>> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/CZtFA49nJ18/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/7e0bcbc2-6f9e-499d-bef5-dee93fd6370f%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/7e0bcbc2-6f9e-499d-bef5-dee93fd6370f%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAERBpoD9Y1fO4mkn-d1JtwuXdvMffdOXj0ePz01iWmw4j2GohA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
