Currently the query caching work for entire query, there is no way to cache query with specific conditions. For example, I have a query that returns me all user data, this data changes very rarely, and I can't specify that the cache should work for user A, but not for user B. Like in Redis I can store this user under user#123, then go to cache and instantly get data, then go to cache again but for user#256 and the cache is invalidated. Retool stores the query across all users, and all users data are invalidated or not.
Hi @danyloh,
Thanks for reaching out!
One note I wanted to share from our docs: Administrators can disable Cache queries across all users in your organization's Advanced settings to perform caching on a per-user basis instead.
Depending on the resource, you could have a dummy parameter in your query to create separate caches
For any resource queries that are cached, you can invalidate the cache with Javascript:
1 Like