Answers

• colin Posts: 15,144Questions: 1Answers: 2,586

  April 2018

  Hi @gmisterk ,

  The best bet is to use initComplete, this will get called when the table has fully loaded. You can do something like this:

        initComplete: function() {
          this.api().rows().select();
        }
  

  See this live example.

  Cheers,

  Colin
• jshuff Posts: 1Questions: 0Answers: 0

  March 2019

  This was very helpful in getting me started. Any suggestions on how to have it select only specific rows instead of all?

  My objective is that I'm setting this up for a user to UPDATE an existing record in the database. I have the complete form loaded and pre-populated with the existing database values.

  What I need to accomplish is now AFTER LOAD my datatable shows all US States but I need to auto select New York and California. My JSON that populates the datatable has an additional attribute name 'active' which is set to '1' for the rows I'd like to auto select.

  Any ideas?
• kthorngren Posts: 20,302Questions: 26Answers: 4,769

  March 2019

  Good question. The solution I would use makes use of rows().indexes() and filter(). Inside initComplete a combo of those APIs is used to build an array of indexes containing the rows with active === 1. The indexes is then used to select the rows to select using rows().select(). Here is an example selecting all rows where the Office is London.
  http://live.datatables.net/ketaripi/1/edit

  Kevin