Thank you @Jim, I will test it out this evening and let you know if I have any questions or doubts about it :)
El viernes, 14 de junio de 2019, 13:16:32 (UTC-3), Jim S escribió: > > 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 <kryst...@gmail.com > <javascript:>> 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 >> web...@googlegroups.com <javascript:>. >> 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/61e5aa67-03bd-4f25-8da7-3e9275dd5f1c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.