Question: ordering rows with datatables


ordering rows with datatables

Answers 1
Added at 2017-01-03 23:01

Surely this has been asked before, but I haven't been able to turn up any code that works for me. I'm working with a DataTable in R Shiny. I want to generate the DataTable and have it ordered by default on the second column rather than the first. This is what I have in server.R:

output$TabVals <- DT::renderDataTable({
              options = list(pageLength = 25, 
                             searching = FALSE, 
                             paging = FALSE),   
              rownames = FALSE) %>%
      formatRound(2, digits = 0)

This works great. What I found other people had done was include in the options order = list(2, 'asc') (since I'm sorting on the second column and want the data ascending. When I add that line, however, the DataTable no longer displays any rows.

I put together this example to recreate the problem:

c1 <- c("a", "b", "c")
c2 <- c(1, 2, 3)
test <- cbind(c1, c2)

test1 <-  DT::datatable(test)
test2 <-  DT::datatable(test, options = list(order = list(2, 'desc')))

test1 makes a nice DataTable. test2 generates a blank table.

I tried moving the order = list(2, 'asc') to other parts of the code (eg after options, before rownames, after the pipe), but that didn't help. Thoughts appreciated!

Answers to

ordering rows with datatables

nr: #1 dodano: 2017-01-04 01:01

I am not at all sure this is what you are after, but you could try either of the following

c1 <- c("a", "b", "c")
c2 <- c(1, 2, 3)
test <- data.table(c1,c2)
# or
test[, some function in j, by = c2]

Hope that helps. I have a hunch you know more R than I.

Source Show
◀ Wstecz