Hi! Thanks for making the guess, and sorry for not being clearer in the original post. In fact, I think the title is wrong: it should read "filtering in"!
The point is that I want null and/or empty values included in the rendered table, and to be able to filter them in on the fly. Please, see below (those are public data available at our website, no issue about privacy):
I can easily use regex to select records containing or not containing a string in any variable. Even by using ^ I can filter out all records having null or empty values in any variable:
I get this by simply enabling regex in search list, as in:
output$row0202col0101 <- renderDT(
teamDiff_full, # data
class = "display nowrap compact", # style
filter = "top", # location of column filters
rownames= FALSE,
options = list(search = list(regex = TRUE, caseInsensitive = FALSE), pageLength = 10)
)
But, how could I get only the records with, for instance, no value for SA_RP?
Thank you very much!