-
Proposal:
Hide
Proposal amended during meeting 2018-7-19: treat group by NavProp as group by NavProp/$ref and return the nested @odata.id values
Since section 3.10.1 only mentions grouping by navigation properties, but lacks a definition that is then finally given by example in section 7.1, move the relevant statements from section 7.1 to 3.10.1
Show
Proposal amended during meeting 2018-7-19: treat group by NavProp as group by NavProp/$ref and return the nested @odata.id values
Since section 3.10.1 only mentions grouping by navigation properties, but lacks a definition that is then finally given by example in section 7.1, move the relevant statements from section 7.1 to 3.10.1
Section 7.1 defines the result of grouping by a single-valued navigation property without giving an example.
Any example in this section that groups by the key property of a related entity could be rephrased to group by the navigation property instead. Here's how example 52 would look like:
GET ~Sales?$apply=groupby((Customer,Product))
and results in
{
"@odata.context": "$metadata#Sales(Customer,Product)",
"value": [
{ "@odata.id": null, "Customer": { "@odata.id": "Customers('C1')" }, "Product": { "@odata.id": "Products('P2')" } },
{ "@odata.id": null, "Customer": { "@odata.id": "Customers('C1')" }, "Product": { "@odata.id": "Products('P3')" } },
{ "@odata.id": null, "Customer": { "@odata.id": "Customers('C1')" }, "Product": { "@odata.id": "Products('P1')" } },
{ "@odata.id": null, "Customer": { "@odata.id": "Customers('C2')" }, "Product": { "@odata.id": "Products('P2')" } },
{ "@odata.id": null, "Customer": { "@odata.id": "Customers('C2')" }, "Product": { "@odata.id": "Products('P3')" } },
{ "@odata.id": null, "Customer": { "@odata.id": "Customers('C3')" }, "Product": { "@odata.id": "Products('P3')" } },
{ "@odata.id": null, "Customer": { "@odata.id": "Customers('C3')" }, "Product": { "@odata.id": "Products('P1')" } }
]
}
{"report":{"apdex":1,"isInitial":true,"journeyId":"a1004788-8e13-4215-addb-42718aea4d4e","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":608.3000001907349,"redirectCount":0,"resourceLoadedEnd":491.59999990463257,"resourceLoadedStart":171.09999990463257,"resourceTiming":[{"duration":10.599999904632568,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":171.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":181.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":10.900000095367432,"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":171.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":182.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":11.200000286102295,"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":171.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":182.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":11.5,"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":171.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":183.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":12.100000381469727,"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":172.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":172.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":184.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":55.799999713897705,"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":172.40000009536743,"connectEnd":172.40000009536743,"connectStart":172.40000009536743,"domainLookupEnd":172.40000009536743,"domainLookupStart":172.40000009536743,"fetchStart":172.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":172.40000009536743,"responseEnd":228.19999980926514,"responseStart":228.19999980926514,"secureConnectionStart":172.40000009536743},{"duration":75.69999980926514,"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":173,"connectEnd":173,"connectStart":173,"domainLookupEnd":173,"domainLookupStart":173,"fetchStart":173,"redirectEnd":0,"redirectStart":0,"requestStart":173,"responseEnd":248.69999980926514,"responseStart":248.69999980926514,"secureConnectionStart":173},{"duration":78.80000019073486,"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":173.19999980926514,"connectEnd":173.19999980926514,"connectStart":173.19999980926514,"domainLookupEnd":173.19999980926514,"domainLookupStart":173.19999980926514,"fetchStart":173.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":173.19999980926514,"responseEnd":252,"responseStart":252,"secureConnectionStart":173.19999980926514},{"duration":81,"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":173.40000009536743,"connectEnd":173.40000009536743,"connectStart":173.40000009536743,"domainLookupEnd":173.40000009536743,"domainLookupStart":173.40000009536743,"fetchStart":173.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":173.40000009536743,"responseEnd":254.40000009536743,"responseStart":254.40000009536743,"secureConnectionStart":173.40000009536743},{"duration":81.40000009536743,"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":173.5,"connectEnd":173.5,"connectStart":173.5,"domainLookupEnd":173.5,"domainLookupStart":173.5,"fetchStart":173.5,"redirectEnd":0,"redirectStart":0,"requestStart":173.5,"responseEnd":254.90000009536743,"responseStart":254.90000009536743,"secureConnectionStart":173.5},{"duration":83.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":173.80000019073486,"connectEnd":173.80000019073486,"connectStart":173.80000019073486,"domainLookupEnd":173.80000019073486,"domainLookupStart":173.80000019073486,"fetchStart":173.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":173.80000019073486,"responseEnd":257,"responseStart":257,"secureConnectionStart":173.80000019073486},{"duration":83.59999990463257,"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":173.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":173.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":257.5,"responseStart":0,"secureConnectionStart":0},{"duration":83.30000019073486,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":174.09999990463257,"connectEnd":174.09999990463257,"connectStart":174.09999990463257,"domainLookupEnd":174.09999990463257,"domainLookupStart":174.09999990463257,"fetchStart":174.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":174.09999990463257,"responseEnd":257.40000009536743,"responseStart":257.40000009536743,"secureConnectionStart":174.09999990463257},{"duration":55.59999990463257,"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":202.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":258.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":55.5,"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":202.69999980926514,"connectEnd":202.69999980926514,"connectStart":202.69999980926514,"domainLookupEnd":202.69999980926514,"domainLookupStart":202.69999980926514,"fetchStart":202.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":202.69999980926514,"responseEnd":258.19999980926514,"responseStart":258.19999980926514,"secureConnectionStart":202.69999980926514},{"duration":257.90000009536743,"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":213,"connectEnd":213,"connectStart":213,"domainLookupEnd":213,"domainLookupStart":213,"fetchStart":213,"redirectEnd":0,"redirectStart":0,"requestStart":213,"responseEnd":470.90000009536743,"responseStart":470.90000009536743,"secureConnectionStart":213},{"duration":268.7999997138977,"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":222.80000019073486,"connectEnd":222.80000019073486,"connectStart":222.80000019073486,"domainLookupEnd":222.80000019073486,"domainLookupStart":222.80000019073486,"fetchStart":222.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":222.80000019073486,"responseEnd":491.59999990463257,"responseStart":491.59999990463257,"secureConnectionStart":222.80000019073486},{"duration":66.2000002861023,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":427.19999980926514,"connectEnd":427.19999980926514,"connectStart":427.19999980926514,"domainLookupEnd":427.19999980926514,"domainLookupStart":427.19999980926514,"fetchStart":427.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":427.19999980926514,"responseEnd":493.40000009536743,"responseStart":493.40000009536743,"secureConnectionStart":427.19999980926514}],"threshold":1000,"fetchStart":1,"domainLookupStart":64,"domainLookupEnd":64,"connectStart":64,"connectEnd":113,"secureConnectionStart":88,"requestStart":113,"responseStart":161,"responseEnd":223,"domLoading":165,"domInteractive":655,"domContentLoadedEventStart":655,"domContentLoadedEventEnd":695,"domComplete":834,"loadEventStart":834,"loadEventEnd":837,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"a44c09520fd2d2","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":84,"dbReadsTimeInMs":12,"dbConnsTimeInMs":15,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Resolved per amended proposal 2018-7-19