search

OHDSI / WhiteRabbit

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.
http://ohdsi.github.io/WhiteRabbit
Apache License 2.0
178 stars 88 forks source link

White Rabbit - Select Table Dialogue #306

Open usmanafzal89 opened 3 years ago

usmanafzal89 commented 3 years ago

Hi concerns, In white rabbit Select Table dialogue (For Oracle Database), Either there should be an option to search for table name or List of tables should be sorted. For my case i have thousands of table in list and searching the required table is very difficult. select table

MaximMoinat commented 3 years ago

Hi @usmanafzal89. To understand your request, we need a little more background on what you want to achieve. Do you e.g. want to select tables with a certain prefix?

A possible workaround is to run WhiteRabbit from the command line. You can then simply supply a comma separated list of table names you want to scan. This also makes it easy to rerun the scan of the selected tables or create a scan with a different selection of tables.

usmanafzal89 commented 3 years ago

Hi @MaximMoinat // Do you e.g. want to select tables with a certain prefix? // perhaps not, i wanted to select different tables required for mapping against CDM tables. I know the table names in advance just wanted to select the tables for scan, but as the list was not sorted so i have to scroll up and down to find the required tables.

I have gone through the command line solution, it seems like my problem will be solved, but still i think the list of table names should be sorted in ascending order that will make table selection much easier, in case someone is not aware of command line solution (in this case me :( ).

MaximMoinat commented 3 years ago

Happy to read your issue has been solved for now. And I agree that sorting the table list would be a good enhancement of White rabbit. I have labeled the issue as such and will put it on the roadmap.

usmanafzal89 commented 3 years ago

Thanks