Answers

• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  June 2016

  Do you mean you want to set the data for those columns to be null? If so, that's an edit action and you could use the edit() method in a custom button to do that.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  June 2016

  Hi alla,

  I want to add one checkbox as column to select all rows. After select all rows Edit and Delete button should be enable.can u please let me know.
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  June 2016 Answer ✓

  There isn't a built in option for a checkbox to select all rows, but you could use the rows().select() method to do that with your own checkbox:

      table.rows().select( true );
  

  will select all rows for example.

  You might also be interested to look into the buttons that Select provides which does include a "select all" option - see this example.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016 edited July 2016

  Hi alla,

  I am created one custom button for deleteing the specific column data set to null.But i am not able to get the data to serverside once row is selected.can you please let me know how can i do that.Please find the below code what i am written the code for removing the row data and set to null.

   var table= $('#example').DataTable( {
  buttons: [
   {
                        text: "Remove Discount",
                        editor: editor,
                        action: function ( e, dt, node, config ) {
                          var newData = table.rows().data();
                           $.ajax({
                           url: "http://localhost:7001/JqueryExample/hello.do?method=getRemove",
                            idSrc:  'rowid',
                            data:newData ,
    });   
  

  Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  July 2016 Answer ✓

  I'm afraid I don't fully understand. Do you want to get the data from the selected rows? The documentation for how to do that is available here.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  yes allan I want to get the selected rows data to serverside through ajax call
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi allan,

  please find the attached image i am able to see an error in jquery.dataTables.min.js.please let me know what is the isse.

  datables.PNG 28.9K
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  July 2016

  Without a test case showing the issue, I'm afraid I don't know. At the very least I would need to know the back trace for the error, the DataTables initialisation options and any API methods that were used when the error is triggered.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi allan,
  I am implemented one checkbox in header to select the all check boxes.But i am not able to select only filter data.can you please let me know how can i implement that functionality in jquery. please provide the function to select only filter data.
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  July 2016 Answer ✓

  But i am not able to select only filter data

  Do you mean you want to select the rows that are in the table filtered, and not the ones which have been filtered out? The rows() method with the selector-modifier object can be used for that. table.rows( { search: 'applied' } ).nodes() for example.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi allan i tried this function it's wrking fine thanks allan
  table.rows( {order:'index', search:'applied'} ).select(true).nodes();
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi allan,

  I want to add the validation for inline editing.can you please let me know how can i do that validation for client side in jquery.
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  July 2016 Answer ✓

  There is an example of how to do client-side validation here.

  Note that Editor focuses on server-side validation since the validation has to be done there anyway.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi allan,

  I want to send only changed value from Edit entry(Jquery) to server side.I don't want to get complete row data and iterate the values.please let me know how can i do that.
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  July 2016

  Use the submit option of the form-options object. See also the formOptions.main documentation for how to set a default for that option for the main lightbox editing.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi allan,

  In datatables even if there is no data in UI the page is looking like still loading how to ignore the loading.. tab if data is null.For reference please find the attached file.

  Capture.PNG 7.6K
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  July 2016 Answer ✓

  That suggests that there is a Javascript error occurring. If null is being returned, that would cause an array before it isn't a valid array of data. For an empty data set, return an empty array.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi Allan,

  I want to hide one column in edit entry window in editor .can u please let me know how can i do that?
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  July 2016 Answer ✓

  I presume you want to keep it for the create view? If so, you need to use show() and hide() to show and hide the field and the initCreate and initEdit events to know when to call those methods.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  July 2016

  Hi Allan,

  when i clicked the inline edit for any any cell i want get the header name how can i do that in jquery can you please let me know..
• allan Posts: 63,689Questions: 1Answers: 10,500 Site admin

  August 2016

  Use cell().index() to get the index information (including the column index) and then column().header() to get the header cell, which you can read its content from.

  The full, searchable, API reference is available here.

  Allan
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  August 2016

  Hi Allan,

  After applying filter when i clicked 'x' data is not getting filtered or cleared.please let me know what is the issue?
• TELE2_NL2 Posts: 17Questions: 2Answers: 0

  August 2016

  In internet explorer having that problem but it's working in google chrome it's working fine allan.
  But i want to test my application in IE only.please let me know