Hope you enjoyed the OHDSI symposium. Unfortunately, I could not be there due to family circumstances.
I did make some time to create a first version of the Shiny app. See screenshot below and the following repo: https://github.com/thehyve/omop-queries/tree/shinyApp.
To test, clone the 'shinyApp' branch and open an R console in the main folder. Then execute:
It should open a Shiny window with the G01 OMOP Query pre-selected. If shiny is not installed yet on your system, execute
All that the app now does, is rendering the markdowns in the OMOP-Query repo and extracting the sql part for translation. For that, I have blatantly copied the SqlDeveloper shiny app by Martijn.
Any feedback is welcome! Please do note that this is a first version. Especially the file selection box has to be replaced with a filterable table, with metadata from the markdown files (like domain and table target).