Query Editor will not Refresh

[mhardy]

On the main Window, clicking a query called "FieldList" on the data tab shows correctly with all up-to-date data.
- Click Edit Queries
- Click the same query "This preview may be up to 11 days old."
- Click 'Refresh'
- Fiddler shows no request is made back to the server to retrieve updated data
- Yellow dots roll across the top of the screen indefinitely and the data is never refreshed.

- This data comes from a JSON API that via Postman takes less than 200 milliseconds to run

- Close, Edit Queries again.  Click 'Refresh Preview', it comes back instantly but the data is still out-of-date.

All other tables depend on this table being correct so it's critical this table is able to refresh in the *Query Editor*.

Outside the Query Editor, it refreshes fine. But inside the Query Editor it's out-of-date and refuses to fresh.

[pqian · Accepted solution]

@mhardy can you try dumping the cache in Options -> Data Load -> Clear Cache?

(ps, what's the cache size before you clear it?)

[mhardy]

used: 71.4 MB

max: 4,096 MB

That did the trick.  Cleared the cache and Refresh Preview pulled in the new data instantly.

Thanks,

Mike