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 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/7e0bcbc2-6f9e-499d-bef5-dee93fd6370f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
