search

d4software / QueryTree

Data reporting and visualization for your app
http://querytreeapp.com
GNU Lesser General Public License v3.0
335 stars 121 forks source link

New tables/Views added to database not showing #135

Closed QuentinBennett closed 1 year ago

QuentinBennett commented 2 years ago

Duplicate of closed issue #109, but on a SQL Server database.

New Table/View shows when new connection created, but not showing on existing connection, created prior to the table/view.

Additionally, columns added/changed after the connection created are not reflected in the Query Tree, resulting in 'invalid column name' errors.

harpsicord86 commented 1 year ago

Hi @QuentinBennett,

I had noticed this too and it turns out that QueryTree has a cache which updates every hour. If you reset your app pool in IIS, this usually gets any new view/tables to show. Have a try and see if this works for you.

d4nt commented 1 year ago

Thanks @QuentinBennett, that's absolutely right.