How to print results coming from Oracle Database

shiny
, ,
1

Hi everyone!

I have the following code to extract data from a database

filtros=('select plaordem.dth_criacao_reg, 
         plaordem.dim_ext_tubo,
         plaordem.esp_par_tubo,
         plaordem.dsc_aco,
         plaordem.cod_aqa
         
         from QT_QTS.PLA_ORDEM_PRODUCAO plaordem,
         qt_qts.res_tubo_austenitizacao aust,
         qt_qts.res_tubo_sofia_aust sofia
         
         where   plaordem.dth_criacao_reg=:1
         and     plaordem.DIM_EXT_TUBO=:2
         and     plaordem.ESP_PAR_TUBO=:3
         and     plaordem.DSC_ACO=:4
         and     plaordem.COD_AQA=:5 
         and     sofia.HF1=:6
         and     sofia.TF1=:7
         and     sofia.TF2=:8
         
         
         and plaordem.cod_ordem_producao = aust.cod_ordem_producao 
         and aust.cod_ordem_producao = sofia.cod_ordem_producao
         
         
         order by DTH_CRIACAO_REG desc')

df<- dbGetQuery(connection,
                filtros,
                data.frame(
                  input$dates,
                  input$diametro,
                  input$parede,
                  input$grau,
                  input$aqa,
                  input$hf1,
                  input$tf1,
                  input$tf2
                ),

I want to create a method to plot the results coming from this database search.
How can I do this?

I tried with "dataTableOutput" and "output$table<- renderDataTable" but it didn't work.

Really Thx!

2

Hi, we have resources on our R and Databases website that may help you with this: https://db.rstudio.com/

These specific pages may be of special help for your use case:

1 Like
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.