Answers

• kthorngren Posts: 21,558Questions: 26Answers: 4,994

  March 2021

  Your code snippet works here:
  http://live.datatables.net/goretebo/1/edit

  It hides the Name and Office columns.

  There is something else in your code causing column 2 to be "unhidden". Please post a link to your page or update my test case to replicate the issue so we can help debug.

  Kevin
• vpalhories Posts: 13Questions: 5Answers: 0

  March 2021 edited March 2021

  Hey Kevin ...

  I added my snippet and sure enough, it works too.

  live.datatables.net/kiwihufe/1/edit

  The only difference is that I'm doing a server side load of the data as well as saving the state so I removed those from the code snippet. I'm also using Moment.js to format the dates but I commented that out in the snippet.

  My Ajax Call looks as follows which is right before the [ColumnDefs] section.

   ajax: {
                      url: "/TimeSheet/LoadTimeSheetEntries",
                      data: {
                          "userid": $('#@Html.IdFor(m=>m.UserId)').val(),
                          "projectid": $('#@Html.IdFor(m=>m.ProjectId)').val(),
                          "starttime": $('#@Html.IdFor(m=>m.StartDate)').val(),
                          "endtime": $('#@Html.IdFor(m=>m.EndDate)').val()
                      },
                      type: "POST",
                      datatype: "json"
                  },
  

  Other than that I also have the following at the very top. I use that because I change the Ajax Parameters on the page and resubmit the query.

   if ($.fn.dataTable.isDataTable('#timesheet')) {
                  $('#timesheet').dataTable().fnDestroy();
              }
  

  Not sure where to go from here! It's something I'm doing pretty consistently because it's the same on ALL of my tables.

  --- Val

  Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• kthorngren Posts: 21,558Questions: 26Answers: 4,994

  March 2021

  ServerSide processing won't affect column visibility. Can you post a link to your page so we can take a look?

  Kevin
• vpalhories Posts: 13Questions: 5Answers: 0

  March 2021 edited March 2021

  Kevin,

  I finally got this working. I noticed that I had code like the one below within the variable declaration of the table. As soon as I moved it out, the column visibility worked.

  ('#timesheet tbody').on('dblclick', 'tr', function () {
  ...
  }
  

  Thanks for your time.

  --- Val