Showing custom message in jquery datatable while loading data?

Question

I have below code in jsp to create a dataTable. I am using bProcessing as true which displays the 'processing' indicator till i get the data from the server. I want to show the message as "loading data.." instead of 'processing'. I tried using sProcessing as suggested on various sites but it does not work?

      customersTable = $('cutomer').dataTable({
         "sAjaxSource": "ajax url",
         "bProcessing":true,
         "bDeferRender": true,
         "sServerMethod": "POST",
             "oLanguage": {
                "sProcessing": "loading data..."
              }
      });

why do you have two , after the "sServerMethod": "POST" ? remove one of them... — Daniel
– Daniel, Commented Dec 9, 2012 at 7:56

M Sach · Accepted Answer · 2012-12-09 07:43:28Z

6

 "oLanguage": {
          "sProcessing": "loading data..."
   }

works for me and also suggested in dataTable Api's http://datatables.net/ref. Just check whether you are putting at right place. Otherwise you can also try fnPreDrawCallback and fnDrawCallback

answered Dec 9, 2012 at 7:43

M Sach

34.6k78 gold badges232 silver badges317 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GameCharmer · Accepted Answer · 2012-12-08 19:12:44Z

5

You could try sLoadingRecords instead of sProcessing, as sLoadingRecords deals with loading data, and sProcessing deals with datatables sorting/searching local data. Since you are using server side processing, I'm don't think sLoadingRecords will work for you, but it might actually change the text for you.. Let us know it it works for you.

Here's the info on sLoadingRecords from the DataTables website.

When using Ajax sourced data and during the first draw when DataTables is gathering the data, this message is shown in an empty row in the table to indicate to the end user the the data is being loaded. Note that this parameter is not used when loading data by server-side processing, just Ajax sourced data with client-side processing.

And for sProcessing

Text which is displayed when the table is processing a user action (usually a sort command or similar).

answered Dec 8, 2012 at 19:12

GameCharmer

6431 gold badge7 silver badges20 bronze badges

1 Comment

emilly Over a year ago

It does not work with "oLanguage": { "sLoadingRecords": "DataTables is currently busy" }. Also i am not using server side processing because by default bserverside is false

Collectives™ on Stack Overflow

Showing custom message in jquery datatable while loading data?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related