Disable datatables when processing

Question

I'm using datatables with processing message but I would like to block datatable when this message show up. This is important because otherwise the user may use an old row. This is my configuration:

datatableTable = $('#datatableTable').DataTable({
            responsive: true,
            "bLengthChange": false,
            deferRender:    true,
            scrollY:        '60vh',
            scrollCollapse: true,
            scroller:       true,
            "bProcessing": true,

and I'm using this message css:

div.dataTables_wrapper div.dataTables_processing {
  position: absolute;
  top: 50%;
  left: 50%;
  width: 200px;
  margin-left: -100px;
  margin-top: -26px;
  text-align: center;
  padding: 1em 0;
  z-index: 9999;
}

Is there a way to block datatable? thanks

What do you exactly mean by "block datatable"? Disabling datatable control elements such as pagination and column headers or something else? — hindmost
– hindmost, Commented Dec 6, 2016 at 13:41
In each row of my datatable I have several buttons, files browse and so forth, I would like to forbid the use of these element. — luca
– luca, Commented Dec 6, 2016 at 13:45
Then it has no relation to datatables. Since you output your input elements inside table yourself, you have to disable them yourself too. Datatables can't do all work for you. — hindmost
– hindmost, Commented Dec 6, 2016 at 13:50
Isn't it possible to disable the entire datatable? I see that all the commands given during processing are elaborated at the end of elaboration (even the columns ordering) — luca
– luca, Commented Dec 6, 2016 at 13:53
No way except manual disabling all child input elements (e.g. using loops). — hindmost
– hindmost, Commented Dec 6, 2016 at 13:58

alcia · Accepted Answer · 2016-12-06 13:54:44Z

1

You can just disable mouse interaction:

$("body").addClass("disabled");

And css:

.disabled {
    pointer-events: none;
}

You can also put a fixed overlay between your message and body and set some opacity (like 0.5), black background, proper z-index etc. to make it hide everything that is behind.

Maybe you should also read something about database's transactions - there're a solution for many problems with data.

answered Dec 6, 2016 at 13:54

alcia

1391 silver badge7 bronze badges

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

4 Comments

luca Over a year ago

I already have my modal to disable all page, I was only wondering if was possibile to disable only the table

alcia Over a year ago

Of course - you can add id for your table (for example #tableid) and write:

alcia Over a year ago

$("#tableid").addClass("disabled"); :)

suba Over a year ago

I have the same issue, Is there any way to freeze the pagination button when the datatable is processing?

Collectives™ on Stack Overflow

Disable datatables when processing

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related