Removing sort arrows from column header that has select checkboxes in first column.

Removing sort arrows from column header that has select checkboxes in first column.

bbrindzabbrindza Posts: 299Questions: 68Answers: 1

I need to remove the sort arrows from the column heard that contains checkboxes.

    copyMachineTasksTable = $('#copyMachineTasksTable').DataTable( {

          pageLength: 10,
          searching: false,
          paging: false,
          info: false,
          ordering: false,

          ajax: {
                   type: 'POST',
                   url: "MachineTaskManagement/ssp_TaskManagement.php",
                   data: {locationCode: userLocationCode,
                          machineCode: $("#copyTasksMachineSelectionDialogModal_machineCode").val()},   
                   cache: 'false',
            },
        columnDefs: [
                 {
                    targets: 0,
                    checkboxes: {
                    selectRow: true,
![](https://datatables.net/forums/uploads/editor/15/qkpwk3d9czn8.png "")
          
                    }
                 }
              ],
         columns: [ { 
                         data: null,
                         defaultContent: '',
                     },        
                              
                    { className: 'detail-level-control',
                      orderable: false,
                      data: null,
                      defaultContent: '',
                      width: '5px'},
                    { data: "location_code", "visible": false }, 
                    { data: "machine_code", "visible": false }, 
                    { data: "doc_link", "visible": false }, 
                    { data: "task_number" },
                    { data: "scheduled_pm_number" },
                    { data: "last_pm_date" }, 
                    { data: "pm_scheduled" },
                    { data: "type_of_pm" },
                    { data: "next_pm_date" },
                    { data: "interval_to_next_pm" },
                    { data: "meter_reading" },
                    { data: "meter_scheduled_amount" }
                ],
         select: {
                    style: 'multi'
                 },

      } );

Answers

  • bbrindzabbrindza Posts: 299Questions: 68Answers: 1

    forgot image

  • kthorngrenkthorngren Posts: 20,144Questions: 26Answers: 4,736

    Use order to change the default order of the table. By default its column 0. Change it to another column or use order: [] to order by the original data order.

    Kevin

  • bbrindzabbrindza Posts: 299Questions: 68Answers: 1

    Hi Kevin ,

    That did not seem to work. Still have the up-down arrows in the first column header.

  • kthorngrenkthorngren Posts: 20,144Questions: 26Answers: 4,736

    Works in this example:
    http://live.datatables.net/wunizepu/1/edit

    Please provide a link to your page or a test case showing the issue so we can take a look.
    https://datatables.net/manual/tech-notes/10

    Kevin

  • tangerinetangerine Posts: 3,342Questions: 35Answers: 394

    Apply "orderable: false" to the column.

  • bbrindzabbrindza Posts: 299Questions: 68Answers: 1

    That did it, I had "ordering: false",

    Thanks for the assist.

  • bbrindzabbrindza Posts: 299Questions: 68Answers: 1

    However , when I changed the "ordering: false" to "orderable: false" and adding "order: []", the first column now does not show sort arrow, but now the rest of the columns do. What up with that?

  • kthorngrenkthorngren Posts: 20,144Questions: 26Answers: 4,736

    when I changed the "ordering: false" to "orderable: false"

    The ordering option is a "global" config option while the columns.orderable is applied to the columns. Use ordering false to disable table ordering.

    Kevin

  • bbrindzabbrindza Posts: 299Questions: 68Answers: 1

    Now I am confused.
    Here is what the results are when combining " orderable: false", "ordering: false", "order: []"

    When using just ...

      orderable: false,
      order: [],
    

    The first column does not have the sort arrows, but the rest of the columns do have the sort arrows

    When using just ...

      ordering: false,
      order: [],
    

    The first column does have the sort arrows, but the rest of the columns do not have the sort arrows

    When combining ...

      ordering: false,
      orderable: false,
      order: [],
    

    The first column does have the sort arrows, but the rest of the columns do not have the sort arrows

    How do I resolve this?

  • kthorngrenkthorngren Posts: 20,144Questions: 26Answers: 4,736

    The first option is setting the default table order to nothing so it will be in the original order of the data. As I mentioned orderable: false, is set on the columns not globally so its not doing anything and allowing ordering to take place on the other columns.

    The second option should work as per my example. If its not please post a link to your page or a test case showing the issue so we can help debug. Do have any options set on the -tag table` tag using HTML5 data attributes?

    Kevin

  • tangerinetangerine Posts: 3,342Questions: 35Answers: 394

    Your original post said this:

    I need to remove the sort arrows from the column heard that contains checkboxes.

    Now you say this:

    The first column does not have the sort arrows, but the rest of the columns do have the sort arrows

    That seems to be exactly what you want.

  • bbrindzabbrindza Posts: 299Questions: 68Answers: 1

    No tags in HTML. Didn't work, I will put up a test case.

Sign In or Register to comment.