Replies: 1 comment 2 replies
-
At the moment we don't support I think the easiest way would just be to join from the view? Obviously there's a bit of boilerplate with the shared joins, but at least there's a bit of an improvement here. resumable AS TransferWithSyncpoint:
SELECT syncSession.**, transfers.**
FROM incompleteTransfers it
INNER JOIN sync_sessions AS syncSession ON syncSession.global_endpoint_id = it.endpoint_id
INNER JOIN transfers AS transfer ON transfer.id = it.transfer_id
WHERE handed_off = 0
AND status IS NOT 'NOT_STARTED'; |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi,
I've created a view in my moor file to greatly simplify a number of queries interested in a very similar dataset. Though a number of queries previously written could benefit from the view if I knew how to deal with Nested Results.
Here is an example where we schedule file/folder transfers:
Here is an attempt to refactor the query above using the view #yummy :
What do I replace the dots with to get a
TransferWithSyncpoint
?Beta Was this translation helpful? Give feedback.
All reactions