-
Proposal:
Hide
Correct 3.10 Transformation groupby, point 1: Replace “Splits the initial set...” with “Splits the input set ...”
The remaining parts of the reported issue have been addressed and resolved with ODATA-1404, which introduces transformation nest
Show
Correct 3.10 Transformation groupby , point 1: Replace “Splits the initial set...” with “Splits the input set ...”
The remaining parts of the reported issue have been addressed and resolved with ODATA-1404 , which introduces transformation nest
Property paths used in a $apply transformation by default may refer to any instances that can be directly or indirectly reached via navigation properties. They are all part of the input set of the transformation.
A preceding expand transformation limits the input set to those navigation paths constructed from the navigation property given as first argument to expand, possibly nested several times, reaching target instances that match the given filter expression.
From the current text this limitation does not become clear.
Furthermore, groupby may follow an expand transformation. The definition of groupby currently refers to an “initial” set, and it should be clarified that this is actually the input set, e.g. the result of the preceding expand.
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"ab9061e4-8cc9-4620-b5f9-aa57288a669f","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":2640.8999996185303,"redirectCount":0,"resourceLoadedEnd":2668.7999997138977,"resourceLoadedStart":370.8999996185303,"resourceTiming":[{"duration":125.90000009536743,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":370.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":370.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":496.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":126.5,"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":371.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":371.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":497.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":127.2000002861023,"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":371.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":371.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":498.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":128.19999980926514,"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":371.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":371.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":499.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":128.10000038146973,"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":371.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":371.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":500,"responseStart":0,"secureConnectionStart":0},{"duration":686.5,"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":372.19999980926514,"connectEnd":802.1999998092651,"connectStart":748.1999998092651,"domainLookupEnd":748.1999998092651,"domainLookupStart":748.0999999046326,"fetchStart":372.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":804.3999996185303,"responseEnd":1058.6999998092651,"responseStart":902.2999997138977,"secureConnectionStart":772.5999999046326},{"duration":2095.300000190735,"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":372.69999980926514,"connectEnd":849.3999996185303,"connectStart":800.8999996185303,"domainLookupEnd":800.8999996185303,"domainLookupStart":800.8999996185303,"fetchStart":372.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":849.5,"responseEnd":2468,"responseStart":907.8999996185303,"secureConnectionStart":824.8999996185303},{"duration":524.5,"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":372.8999996185303,"connectEnd":852.1999998092651,"connectStart":803.6999998092651,"domainLookupEnd":803.6999998092651,"domainLookupStart":803.6999998092651,"fetchStart":372.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":852.2999997138977,"responseEnd":897.3999996185303,"responseStart":896.5,"secureConnectionStart":827.6999998092651},{"duration":527.6999998092651,"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":373.09999990463257,"connectEnd":869.7999997138977,"connectStart":821.1999998092651,"domainLookupEnd":821.1999998092651,"domainLookupStart":821.1999998092651,"fetchStart":373.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":869.8999996185303,"responseEnd":900.7999997138977,"responseStart":899.1999998092651,"secureConnectionStart":845.1999998092651},{"duration":599.8000001907349,"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":373.2999997138977,"connectEnd":945.8999996185303,"connectStart":897.2999997138977,"domainLookupEnd":897.2999997138977,"domainLookupStart":897.2999997138977,"fetchStart":373.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":946,"responseEnd":973.0999999046326,"responseStart":972.0999999046326,"secureConnectionStart":921.6999998092651},{"duration":607.8999996185303,"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":373.5,"connectEnd":953.7999997138977,"connectStart":900.5999999046326,"domainLookupEnd":900.5999999046326,"domainLookupStart":900.5999999046326,"fetchStart":373.5,"redirectEnd":0,"redirectStart":0,"requestStart":953.8999996185303,"responseEnd":981.3999996185303,"responseStart":980.3999996185303,"secureConnectionStart":928.7999997138977},{"duration":147.09999990463257,"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":373.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":373.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":520.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":676.8000001907349,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":373.7999997138977,"connectEnd":1023.1999998092651,"connectStart":973,"domainLookupEnd":973,"domainLookupStart":973,"fetchStart":373.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1023.3999996185303,"responseEnd":1050.5999999046326,"responseStart":1049.8999996185303,"secureConnectionStart":998.8999996185303},{"duration":167.69999980926514,"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":430.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":430.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":597.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":1909,"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":430.3999996185303,"connectEnd":2311.7999997138977,"connectStart":2263.7999997138977,"domainLookupEnd":2263.7999997138977,"domainLookupStart":2263.7999997138977,"fetchStart":430.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":2312,"responseEnd":2339.3999996185303,"responseStart":2338.2999997138977,"secureConnectionStart":2287.5999999046326},{"duration":2189.1000003814697,"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":440.3999996185303,"connectEnd":2602.7999997138977,"connectStart":2554.7999997138977,"domainLookupEnd":2554.7999997138977,"domainLookupStart":2554.7999997138977,"fetchStart":440.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":2602.7999997138977,"responseEnd":2629.5,"responseStart":2628.199999809265,"secureConnectionStart":2578.5},{"duration":1302.5999999046326,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":1207.2999997138977,"connectEnd":2479.199999809265,"connectStart":2426.0999999046326,"domainLookupEnd":2426.0999999046326,"domainLookupStart":2426.0999999046326,"fetchStart":1207.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":2479.3999996185303,"responseEnd":2509.8999996185303,"responseStart":2509.0999999046326,"secureConnectionStart":2454.199999809265}],"threshold":1000,"fetchStart":0,"domainLookupStart":177,"domainLookupEnd":206,"connectStart":207,"connectEnd":289,"secureConnectionStart":232,"requestStart":290,"responseStart":358,"responseEnd":460,"domLoading":364,"domInteractive":2693,"domContentLoadedEventStart":2693,"domContentLoadedEventEnd":2752,"domComplete":3960,"loadEventStart":3960,"loadEventEnd":3962,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"afec364291fe50","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":131,"dbReadsTimeInMs":29,"dbConnsTimeInMs":44,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
I did some investigation how the aggregation requests can be translated to LINQ
Trying to highlight that example 54 is not "just" grouping by a key like example 53 but first has to split the input set in a way that bring the grouping key sales/currency/code to the top level.
see attachment. linq-aggregation.docx