How to store value from an insertUI

Hi guys!

How can I store a value selected by an insertUI widget?
Like:

observeEvent(input$buscaciclo, {
      
      insertUI(
        selector = "#buscaciclo",
        where = "afterEnd",
        ui = selectInput(
          "ciclo",
          label = "Ciclo:",
          choices = df$CICLO
        )
      )
    })

I just to get the value selected in this widget and pass it like a value to my query:

sqldf('select anything
                  from my_df
                  where anything = "input$ciclo"
                  ')

I'm trying to store this value to pass in WHERE clause, but it just not working.

2 posts were merged into an existing topic: Syntax problem with Inputs and SQLDF