-
Proposal:
Hide
require that all explicitly mentioned "from" properties appear in the same order in all arguments
Show
require that all explicitly mentioned "from" properties appear in the same order in all arguments
Explain how in aggregate() with multiple arguments the "from" keyword can be resolved into a groupby/aggregate sequence by initially grouping by all "from" properties appearing in any argument.
Will probably work only if all "from" chains are compatible, i.e. there exists a "super-chain" so that any from chain is a sub-chain of this super-chain.
1) from A from B from D,from A from C from D works with super-chain from A from B from C from D (B and C can be swapped to get another possible super-chain.
2) from A from B, from B from A won't work
{"report":{"apdex":1,"isInitial":true,"journeyId":"400514ea-21bc-49fc-8f56-f41fe72b0292","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":580.6000003814697,"redirectCount":0,"resourceLoadedEnd":501.90000009536743,"resourceLoadedStart":153.80000019073486,"resourceTiming":[{"duration":5.099999904632568,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":153.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":153.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":158.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":5.699999809265137,"initiatorType":"link","name":"https://issues.oasis-open.org/s/7d2823769c2e7b66e860863fe879b7f8-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/9aebb1c0aaa4c36289529757ec9dbb54/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":154.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":159.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":6.099999904632568,"initiatorType":"link","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":154.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":160.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":6.399999618530273,"initiatorType":"link","name":"https://issues.oasis-open.org/s/645acc233eb869f48a571293b8358a7d-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":154.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":161,"responseStart":0,"secureConnectionStart":0},{"duration":6.800000190734863,"initiatorType":"link","name":"https://issues.oasis-open.org/s/a0dd6509771c1de0667aae5429c04cda-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":154.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":161.60000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":55.09999990463257,"initiatorType":"script","name":"https://issues.oasis-open.org/s/e5479157e7a0c08b005e6522f2f04104-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":154.90000009536743,"connectEnd":154.90000009536743,"connectStart":154.90000009536743,"domainLookupEnd":154.90000009536743,"domainLookupStart":154.90000009536743,"fetchStart":154.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":154.90000009536743,"responseEnd":210,"responseStart":210,"secureConnectionStart":154.90000009536743},{"duration":76.10000038146973,"initiatorType":"script","name":"https://issues.oasis-open.org/s/83514d5d4e8543747b02042eafcdc99c-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/9aebb1c0aaa4c36289529757ec9dbb54/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":155.5,"connectEnd":155.5,"connectStart":155.5,"domainLookupEnd":155.5,"domainLookupStart":155.5,"fetchStart":155.5,"redirectEnd":0,"redirectStart":0,"requestStart":155.5,"responseEnd":231.60000038146973,"responseStart":231.60000038146973,"secureConnectionStart":155.5},{"duration":78.19999980926514,"initiatorType":"script","name":"https://issues.oasis-open.org/s/70bb2263e59e7e1f04fbd137c80b895b-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":155.7000002861023,"connectEnd":155.7000002861023,"connectStart":155.7000002861023,"domainLookupEnd":155.7000002861023,"domainLookupStart":155.7000002861023,"fetchStart":155.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":155.7000002861023,"responseEnd":233.90000009536743,"responseStart":233.90000009536743,"secureConnectionStart":155.7000002861023},{"duration":78.5,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":156,"connectEnd":156,"connectStart":156,"domainLookupEnd":156,"domainLookupStart":156,"fetchStart":156,"redirectEnd":0,"redirectStart":0,"requestStart":156,"responseEnd":234.5,"responseStart":234.5,"secureConnectionStart":156},{"duration":78.59999990463257,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":156.2000002861023,"connectEnd":156.2000002861023,"connectStart":156.2000002861023,"domainLookupEnd":156.2000002861023,"domainLookupStart":156.2000002861023,"fetchStart":156.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":156.2000002861023,"responseEnd":234.80000019073486,"responseStart":234.80000019073486,"secureConnectionStart":156.2000002861023},{"duration":81.19999980926514,"initiatorType":"script","name":"https://issues.oasis-open.org/s/cda37faab827dbdf305de8efe8282062-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":156.30000019073486,"connectEnd":156.30000019073486,"connectStart":156.30000019073486,"domainLookupEnd":156.30000019073486,"domainLookupStart":156.30000019073486,"fetchStart":156.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":156.30000019073486,"responseEnd":237.5,"responseStart":237.5,"secureConnectionStart":156.30000019073486},{"duration":81.60000038146973,"initiatorType":"link","name":"https://issues.oasis-open.org/s/07245784f53abc49bad9d9d4d36c577a-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/cadc4f20cc5c138dee060d42cf85f220/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":156.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":238.10000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":81.40000009536743,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":156.7000002861023,"connectEnd":156.7000002861023,"connectStart":156.7000002861023,"domainLookupEnd":156.7000002861023,"domainLookupStart":156.7000002861023,"fetchStart":156.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":156.7000002861023,"responseEnd":238.10000038146973,"responseStart":238,"secureConnectionStart":156.7000002861023},{"duration":161.5,"initiatorType":"link","name":"https://issues.oasis-open.org/s/f77fd89aa211a76b20e9b0e63564383c-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/4a9288299d147101bf66484f4be48925/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":195.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":195.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":357.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":139,"initiatorType":"script","name":"https://issues.oasis-open.org/s/41525c48ddceeb9b11e54085268fc285-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/4a9288299d147101bf66484f4be48925/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":195.90000009536743,"connectEnd":195.90000009536743,"connectStart":195.90000009536743,"domainLookupEnd":195.90000009536743,"domainLookupStart":195.90000009536743,"fetchStart":195.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":195.90000009536743,"responseEnd":334.90000009536743,"responseStart":334.90000009536743,"secureConnectionStart":195.90000009536743},{"duration":257.09999990463257,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":206.60000038146973,"connectEnd":206.60000038146973,"connectStart":206.60000038146973,"domainLookupEnd":206.60000038146973,"domainLookupStart":206.60000038146973,"fetchStart":206.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":206.60000038146973,"responseEnd":463.7000002861023,"responseStart":463.6000003814697,"secureConnectionStart":206.60000038146973},{"duration":282.59999990463257,"initiatorType":"script","name":"https://issues.oasis-open.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":219.30000019073486,"connectEnd":219.30000019073486,"connectStart":219.30000019073486,"domainLookupEnd":219.30000019073486,"domainLookupStart":219.30000019073486,"fetchStart":219.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":219.30000019073486,"responseEnd":501.90000009536743,"responseStart":501.90000009536743,"secureConnectionStart":219.30000019073486},{"duration":55.200000286102295,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":408,"connectEnd":408,"connectStart":408,"domainLookupEnd":408,"domainLookupStart":408,"fetchStart":408,"redirectEnd":0,"redirectStart":0,"requestStart":408,"responseEnd":463.2000002861023,"responseStart":463.2000002861023,"secureConnectionStart":408}],"threshold":1000,"fetchStart":0,"domainLookupStart":42,"domainLookupEnd":42,"connectStart":42,"connectEnd":91,"secureConnectionStart":66,"requestStart":91,"responseStart":140,"responseEnd":219,"domLoading":144,"domInteractive":627,"domContentLoadedEventStart":627,"domContentLoadedEventEnd":671,"domComplete":882,"loadEventStart":882,"loadEventEnd":886,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"cb83275c9f4551","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":103,"dbReadsTimeInMs":21,"dbConnsTimeInMs":23,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Give rationale why the "from" syntax is helpful, given that it can alternatively be expressed as a chain of groupby/aggregate operations which forces clients to explicitly specify the "super-chain" they want to be used for the aggregation.