Restore tree status on refresh

User, date	Message
Written by bouvrie 4 months ago Category: Feature discussion 4 posts since Wed, 10 Aug 11	When working with databases and tables in the database pane on the left, sometimes a refresh of the objects is needed to show new tables. Unfortunately, invoking the refresh also causes a reset of all expanded schemas to the state of collapsed. This could perhaps also be related to the Work Sets Feature Request, in terms of restoring the collapsed/expanded state of specific previously opened schema's/tables.
Written by ansgar 4 months ago 4020 posts since Fri, 07 Apr 06	I think it's good to keep only the current database expanded. Think of a situation where you have gone through 10 databases, and each of them needs to be reretrieved automatically. When you need it, you click the expand button again which again will fetch the database items.
Written by bouvrie 4 months ago 4 posts since Wed, 10 Aug 11	Ah yes, you're referring to a situation in which one would ideally want to refresh a Work Set (multiple databases), or even all expanded databases. Personally when I issue a refresh, I'm typically using the "Refresh" context menu option on the specific (current) database. And while doing so I find it annoying having to expand the database again to access the table list and scroll to the new table I was looking for. In my case I'm frequently dropping and re-creating databases, so I'm refreshing a lot. :)
Written by ansgar 4 months ago 4020 posts since Fri, 07 Apr 06	Please note that you might be one of only a few users who do refreshes such often. For the majority of users I think it's better to have only the current database opened again, not multiple databases.
Written by bouvrie 4 months ago 4 posts since Wed, 10 Aug 11	Sure, I can't think of a situation in which one wants to refresh the current database, and expect another database's tree to be collapsed too. :)
	Please login to leave a reply, or register at first. Username: Password: Remember me