suppressing sorting in dataTables in Shiny

Question

I have a dataTable in Shiny but I want to disable sorting and get rid of the arrows next to the column headings as exemplified in the following image.

I have used the following code to attempt to disble it with no luck.

output$ex <-
  renderDataTable({inData},
                  options = list(
                      bLengthChange = 0,
                      bFilter       = 0,
                      bInfo         = 0,
                      bPaginate     = 0,
                      bSortable     = 0,
                      bOrderable    = 0),
                  rownames=FALSE)

I thought bSortable=0, bOrderable=0 would do the trick but doesn't make it work.

score 64 · Accepted Answer · answered Jun 16 '16 at 07:22

64

Try

datatable(iris,options = list(ordering=F))

to remove sorting

And

datatable(iris,options = list(dom='t',ordering=F))

to show only table

answered Jun 16 '16 at 07:22

Batanichek

7,761
31
49

1

Works great and not so intuitive for me as all the other options in the list started with the B and ended with = 0. Thanks! – mike Jun 17 '16 at 00:27
`ordering=0` also work ( simply 0\1 as bool == FALSE\TRUE) – Batanichek Jun 17 '16 at 06:12

suppressing sorting in dataTables in Shiny

1 Answers1

Linked