Branch: refs/heads/release_18.01 Home: https://github.com/galaxyproject/galaxy Commit: 04a901771b59d1fcf8070cd4c4de1f464e304e55 https://github.com/galaxyproject/galaxy/commit/04a901771b59d1fcf8070cd4c4de1... Author: John Chilton <jmchilton@gmail.com> Date: 2018-03-26 (Mon, 26 Mar 2018) Changed paths: M lib/galaxy/webapps/galaxy/api/workflows.py Log Message: ----------- [18.01] Fix SQL query for "workflows shared with me" as part of workflow index. Before and after queries here: https://gist.github.com/jmchilton/dc57bca60178341d9ce0f6cf6d4bd36f You can see that before the joined load of the stored workflow wasn't being registered by SQLalchemy properly and so it was joining that table twice - once using the proper index and another time just walking the whole table. The filter and order by were being applied to the unconditional version - kind of like saying give me all the workflows and the right workflows and I will check all the workflows to see if this one is deleted instead of just the subset of workflows that are actually being shared with the target user. Commit: d6be56256fcbee53509dc867d863819621ef1d08 https://github.com/galaxyproject/galaxy/commit/d6be56256fcbee53509dc867d8638... Author: Dannon Baker <dannon.baker@gmail.com> Date: 2018-03-27 (Tue, 27 Mar 2018) Changed paths: M lib/galaxy/webapps/galaxy/api/workflows.py Log Message: ----------- Merge pull request #5782 from jmchilton/fix_1801 [18.01] Fix SQL query for "workflows shared with me" as part of workflow index. Compare: https://github.com/galaxyproject/galaxy/compare/fbb47f6e03d0...d6be56256fcb