pass multiple inputs sql query shiny

Question

I have an sql query that works well with 1 input parameter e.g.

mydf1=dbGetQuery(con2, paste0("select month from incoming where to_char(TO_TIMESTAMP(vessel_servertimestamp, 'YYYY-MM-DD HH24:MI:SS'), 'MON') in  '",input$dataset1,"' 
group by  month "))

How do construct an sql query to pass multiple input parameters? Below is the selectInput..

output$dataset1 =renderUI({
      selectInput("dataset1", "Choose month:", 
                  choices  = as.list(c("JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP","OCT","NOV","DEC")),
                  multiple = TRUE)
    })

fenix_fx · Accepted Answer · 2018-07-07 09:23:41Z

2

You need change sql part with input$dataset to

in (", paste0("'", input$dataset1, "'", collapse = ","), ") group_by month"

answered Jul 7, 2018 at 9:23

fenix_fx

3943 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pass multiple inputs sql query shiny

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related