Remove 'search' option but leave 'search columns' option

Question

I would like to remove 'global search' option from my application, but leave 'column search' option. Any ideas? I've tried different paramethers like searching=FALSE, filtering='none'... None of this works properly.

My code:

server.R:

library("shiny")
library("DT")

data(iris)

shinyServer(function(input, output) {

    output$tabelka <- DT::renderDataTable({

        datatable(iris, filter="top", selection="multiple", escape=FALSE)

    })

})

ui.R

library("shiny")
library("DT")

shinyUI(fluidPage(

    DT::dataTableOutput("tabelka")

))

And picture which helps to understand my problem:

Take a look [here](http://rstudio.github.io/DT/), section 2.5. — danas.zuokas, Feb 25 '16 at 10:29
@danas.zuokas, I've read this manual, but it didn't help me. Could you give me more specyfic clue? — Marta, Feb 25 '16 at 11:47
Well I don't have the answer myself, thought it would lead you in the right direction. What I understand is that you can build up a table as you wish using custom container. I suggest reproducing the example and adapting it to your needs. — danas.zuokas, Feb 25 '16 at 11:53
For those finding this on Google (like I just did): to hide the search/filter without disabling the actual API functionality in the regular HTML/JS web setup, use the [`dom`](https://datatables.net/reference/option/dom) option. [Source](https://datatables.net/forums/discussion/comment/64154/#Comment_64154) — ᴍᴇʜᴏᴠ, Apr 22 '21 at 11:30

score 57 · Answer 1 · answered Feb 20 '17 at 16:15

57

Slightly simpler syntax, for anyone else still looking:

datatable(head(iris), options = list(dom = 't'), filter = list(position = "top"))

Other options. To display table only, use dom = 't':

datatable(head(iris), options = list(dom = 't'))

To display table and filter (search box), the default setting:

datatable(head(iris), options = list(dom = 'ft'))

Source:

https://rstudio.github.io/DT/options.html

answered Feb 20 '17 at 16:15

RAFisherman

889
1
8
9

10

This may turn off more features than desired, such as the page buttons. – wibeasley May 16 '17 at 16:53
4

@wibeasley then use `"tp"` to turn on pagination. See http://legacy.datatables.net/usage/options#sDom for more options. – Roman Luštrik Apr 05 '19 at 08:56

Pewi · Accepted Answer · 2016-02-26T09:48:51.883

45

DT options needs to be passed as a list. Further, by using the sDom initialisation variable it is possible to specify where in the DOM controls are placed. The standard setup looks like this:

    datatable(iris, filter="top", selection="multiple", escape=FALSE, 
      options = list(sDom  = '<"top">flrt<"bottom">ip'))

The syntax is a bit quirky, but basically the above says that f, l, r and t options are to be placed in the top div with the i and p options in the bottom div. Please refer to the docs at http://legacy.datatables.net/usage/options for a more thorough explanation.

Anyways, "f" is the "Filtering input" option (i.e. the search option) and by moving "f" to another div or omitting it we may move around or disable the search bar. A solution to your problem might look like this:

    datatable(iris, filter="top", selection="multiple", escape=FALSE, 
      options = list(sDom  = '<"top">lrt<"bottom">ip'))

edited Feb 26 '16 at 09:48

answered Feb 25 '16 at 12:17

Pewi

1,134
13
14

1

Yes, I've tried it. 'Global search' disapears, but 'column search' does not work either... – Marta Feb 25 '16 at 12:20
Strange! The above works as expected for me. What versions of R, shiny and DT are you running? Maybe the dev version works better: devtools::install_github('rstudio/DT') – Pewi Feb 25 '16 at 12:28
There are filtering boxes for columns, but they don't work (try, if it is the same in your version). My DT is quite new, I think. – Marta Feb 25 '16 at 12:30
This doesn't work for me either (DT_0.1.40). The global search disappears as expected but when I try to filter the columns whatever is displayed doesn't change (most likely a bug). – NicE Feb 25 '16 at 12:30
Yeah, my bad, as it turns out it doesn't work here either. Looks ok but nothing happens when filters are applied.. – Pewi Feb 25 '16 at 12:40
Turns out it is not an error, the searching option governs both search and filtering. http://datatables.net/reference/option/. Using the "sDom" option it is possible to move around (or remove) elements. Have modified my answer to reflect this. – Pewi Feb 25 '16 at 13:02
Thanks! Could you try to explain what exactly this code does. Is it written in Java? – Marta Feb 25 '16 at 13:07
No, worries! In the process of building a shiny application at work where DT is used quite extensively. Were looking for a solution to a similar issue when i stumbled on your question :) – Pewi Feb 26 '16 at 09:56
7

why not to use `bFilter=0` in options? – Aleksandr Ianevski Feb 19 '17 at 16:09

score 31 · Answer 3 · answered Jan 16 '18 at 14:27

31

datatable(iris, filter="top", selection="multiple", escape=FALSE,
options = list(searching = FALSE))

answered Jan 16 '18 at 14:27

s157

453
4
10

1

Thank you for this code snippet, which might provide some limited, immediate help. A [proper explanation](https://meta.stackexchange.com/q/114762) would greatly improve its long-term value by showing why this is a good solution to the problem and would make it more useful to future readers with other, similar questions. Please [edit](https://meta.stackoverflow.com/posts/360251/edit) your answer to add some explanation, including the assumptions you’ve made. [ref](https://meta.stackoverflow.com/a/360251/8371915) – Alper t. Turker Jan 16 '18 at 17:25
All the suggestions above don't get rid of the column space used by the search input form that was removed. The big "WHY" to remove the global search was to release the crucial column space on a full-width screen. Any hopes of getting that space released in shiny? – Lazarus Thurston Nov 14 '18 at 06:38
1

@Marta I think you should accept this as the correct answer. – Roman Luštrik Apr 02 '19 at 06:29
2

This disables searching for the entire table i.e. it stops column filters from working, too. The correct way is explained below by Yeahman269 – Benbob Jan 13 '22 at 07:59
@Benbob yeahman's answer is disabling my filter too – its.me.adam Jan 25 '23 at 16:15

score 8 · Answer 4 · answered May 22 '20 at 09:39

You have to act on the dom options of DT::datatable. The following works fine for me:

datatable(iris, filter="top", selection="multiple", escape=FALSE, options = list(dom = 'ltipr'))

By default DT::datatable has dom = 'lftipr', simply drop the 'f' which is for the filter ("search" button).

Learn more on dom here: https://datatables.net/reference/option/dom

emr2 · Answer 5 · 2021-06-04T09:43:27.207

According on what @Alex Nevsky commented, his solution is the best for me! I tried @Pewi solution, but it deleted me the download buttons.

I tried bFilter=0 with your example and it totally works!

library("shiny")
library("DT")

data(iris)

ui <- fluidPage(
  
  DT::dataTableOutput("tabelka")
  
)


server <- function(input, output) {
  
  output$tabelka <- DT::renderDataTable({
    
    datatable(iris, 
              filter="top", 
              selection="multiple", 
              escape=FALSE,
              options = list(bFilter=0))
  })
}


shinyApp(ui=ui, server=server)

Warning, if you want to filter your dataframe (filter="top"), this command is not good for you.

Remove 'search' option but leave 'search columns' option

5 Answers5

Linked