Currently the user can't access a history of executed versions of a query. See http://imgur.com/tg7bwHI for sketch of what that might look like.
Description
Description
Details
Details
| Project | Branch | Lines +/- | Subject | |
|---|---|---|---|---|
| analytics/quarry/web | master | +68 -7 | Expose history of query revisions |
Related Objects
Related Objects
Event Timeline
Comment Actions
What if the query is changed between executions? Do we save the version the query that produced each result set?
Comment Actions
Yes we already do have revisions - they are saved each time the query is executed :) We do need to expose them.
Comment Actions
This request arouse out of a discussion at a workshop. In my drawing, I saw modifications of the same query as branches, while completely new queries formed new top-level nodes. Of course it is difficult to figure out what creates a new query and what is a derivative query, so this may not be possible to do accurately when there is no explicit branching (explicit branching = giving the query a new name?).
It would still be helpful to simply be able to browse through my previous queries and rapidly switch between them. I can imagine that I might want to build up a query by checking two tables and then joining them, or I might be building up a new query and forgotten an earlier result that I want to build on.
Comment Actions
Might want to put this in a "history" tab, rather than crowding the query window with a persistent sidebar.
Comment Actions
Change 773578 had a related patch set uploaded (by Vivian Rook; author: Vivian Rook):
[analytics/quarry/web@master] Expose history of query revisions
Comment Actions
Change 773578 merged by jenkins-bot:
[analytics/quarry/web@master] Expose history of query revisions
Comment Actions
Mentioned in SAL (#wikimedia-cloud) [2022-04-18T17:30:10Z] <Rook> exposing query history https://phabricator.wikimedia.org/T100982