Ability to use saved queries over multiple databases in "Describe Objects" Window

Current limitation: The Describe Objects Window can only work on one saved query per database, so the same query cannot work on a different database even if it has the same table.

Proposed Solution: The save query button should share the saved query with the other databases, this way multiple tables won't need to recreate the exact same query

I could maybe add an option to let you import them from another DB's saved queries, but I think most users like to keep them separate.

If you have a several saved queries set up on one DB and you want to transfer them to another, you can do that like this:

  1. Close Toad
  2. Browse to C:\Users\YOUR_WINDOWS_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\TOAD_VERSION\User Files\Databases\DB_NAME
  3. Copy the file USER_NAME_TableFilters.XML to the DB_NAME folder for the database that you want to see them in.

John,

Thanks for that info. That may be all I need. I was wondering where those queries were saved - thanks!!!

Still IMO it would be a nice feature to be able to save and use a query across other DB's. Maybe make it an option so those that want them separate can keep them separate but those that want to share them can???

I need to think about that for a bit. I'd have to do it in a way that wouldn't mess up the people who like to keep things separate. I suppose I could make a "CommonDatabase" folder and save to that if you have the option set to use that instead.

A common repository sounds good!!!

Thanks!!!

To be clear, I'm just talking about a folder under your user files folder, not a common repository for multiple people to have access to.

Yep, sorry that is what I meant by - "common repository" - common across my database connections. :slight_smile:

1 Like

Next beta, you can go here and check "By table name" to make the custom filters and queries common across tables by the same name in any schema/db.

Note, when you enable this option, the files for existing queries/filters will remain in place so you can return to them later if you want (stored in C:\Users\YOUR_WINDOWS_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\TOAD_VERSION\User Files\Databases\DB_NAME\USER_NAME_TableFilters.XML.

The the common queries/filters will be stored in C:\Users\YOUR_WINDOWS_USER_NAME\AppData\Roaming\Quest Software\Toad for Oracle\TOAD_VERSION\User Files\CommonTableFilters.XML.

Queries/Filters are not migrated across when you change the option. You'll have to start fresh (or pick up where you left off last time you had that option set). The reason for this is that it's not a 1:1 mapping.

Awesome. Thank you!!! This will help me greatly! I support many instances of the same schema so sharing these across instances will be a HUGE help.

1 Like