Entried data

Entried data

sarath_datatablessarath_datatables Posts: 16Questions: 8Answers: 0

Hi Allan

Implemented Scroller + Server-side filtering with individual column filters.All worked fine excepcet the entries info.

Thought the table shows 6 and half entries, the footer part shows the message below
** "Showing 1 to 5 of 40,332 entries (filtered from 10,324 total entries)"**
parameters set like below for Datatable object and also without any filters/search operation intial launch of table show the data "(filtered from 10,324 total entries)"

.DataTable({
          processing: true,
           serverSide: true,
           scrollY: "70%",
           scrollX: false,
           scrollCollapse: false,
           deferRender: true,
          scroller: true,
          ajax: urlDataRetrieval,
          oLanguage: { "sSearch": "" },

Replies

  • colincolin Posts: 15,237Questions: 1Answers: 2,599

    Hi Sarath,

    This is probably coming from the JSON response in the server-side script. In there, there's a two entries:

      "recordsTotal": 57,
      "recordsFiltered": 57,
    

    When you return the data, what values do you have in yours?

    Cheers,

    Colin

  • sarath_datatablessarath_datatables Posts: 16Questions: 8Answers: 0

    hi colin,
    sorry for late replay,

    when i check the log for DataTablesOutput(org.springframework.data.jpa.datatables.mapping.DataTablesOutput)
    implmented by forking at https://github.com/darrachequesne/spring-data-jpa-datatables-sample
    (draw=1, recordsTotal=2727, recordsFiltered=2727....

    and the data show in datatables, "Showing 1 to 5 of 84 entries (filtered from 2,727 total entries)",but the table shows 6rows. didnt applied any filters(default data)

    -> how to show entires data like "Showing 1 to 6"?

  • allanallan Posts: 63,298Questions: 1Answers: 10,430 Site admin

    Could you use the debugger on the table and let me know the debug code it gives you?

    Allan

This discussion has been closed.