-
Proposal:
Hide
Update request in example 57:
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))
Rewrite section on aggregate, last item in list on "virtual property $count": replace it with "$count, which is a shortcut for 1 with sum"
Show
Update request in example 57:
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))
Rewrite section on aggregate, last item in list on "virtual property $count": replace it with "$count, which is a shortcut for 1 with sum"
-
Resolution:
Show
https://github.com/oasis-tcs/odata-abnf/pull/12
Section 3.1 introduces $count as one of several options for aggregate expressions.
Example 57 applies $count relative to a collection-valued navigation property, which is a different use case that is backed by the commonExpr ABNF rule to address the count of a collection (see URL spec, section 4.8). Since section 3.1 requires commonExpr to be augmented with an aggregation method, such a method must be added to the request in the example.
The current aggregation ABNF contains a rule for $count with a path prefix, which needs to be cleaned up accordingly.
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"d8e7207c-a707-4dbf-aff5-ded6b09b314a","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1000.4000000953674,"redirectCount":0,"resourceLoadedEnd":1547,"resourceLoadedStart":325.30000019073486,"resourceTiming":[{"duration":292.7999997138977,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":325.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":325.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":618.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":293.80000019073486,"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":325.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":325.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":619.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":293.80000019073486,"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":325.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":325.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":619.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":293.90000009536743,"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":326.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":326.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":620,"responseStart":0,"secureConnectionStart":0},{"duration":294.19999980926514,"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":326.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":326.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":620.5,"responseStart":0,"secureConnectionStart":0},{"duration":336.2000002861023,"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":326.59999990463257,"connectEnd":326.59999990463257,"connectStart":326.59999990463257,"domainLookupEnd":326.59999990463257,"domainLookupStart":326.59999990463257,"fetchStart":326.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":326.59999990463257,"responseEnd":662.8000001907349,"responseStart":662.8000001907349,"secureConnectionStart":326.59999990463257},{"duration":350.8999996185303,"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":327.2000002861023,"connectEnd":327.2000002861023,"connectStart":327.2000002861023,"domainLookupEnd":327.2000002861023,"domainLookupStart":327.2000002861023,"fetchStart":327.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":327.2000002861023,"responseEnd":678.0999999046326,"responseStart":678.0999999046326,"secureConnectionStart":327.2000002861023},{"duration":353.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":327.40000009536743,"connectEnd":327.40000009536743,"connectStart":327.40000009536743,"domainLookupEnd":327.40000009536743,"domainLookupStart":327.40000009536743,"fetchStart":327.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":327.40000009536743,"responseEnd":680.5999999046326,"responseStart":680.5999999046326,"secureConnectionStart":327.40000009536743},{"duration":353.80000019073486,"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":327.59999990463257,"connectEnd":327.59999990463257,"connectStart":327.59999990463257,"domainLookupEnd":327.59999990463257,"domainLookupStart":327.59999990463257,"fetchStart":327.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":327.59999990463257,"responseEnd":681.4000000953674,"responseStart":681.4000000953674,"secureConnectionStart":327.59999990463257},{"duration":354.2999997138977,"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":327.7000002861023,"connectEnd":327.7000002861023,"connectStart":327.7000002861023,"domainLookupEnd":327.7000002861023,"domainLookupStart":327.7000002861023,"fetchStart":327.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":327.7000002861023,"responseEnd":682,"responseStart":682,"secureConnectionStart":327.7000002861023},{"duration":354.69999980926514,"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":327.90000009536743,"connectEnd":327.90000009536743,"connectStart":327.90000009536743,"domainLookupEnd":327.90000009536743,"domainLookupStart":327.90000009536743,"fetchStart":327.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":327.90000009536743,"responseEnd":682.5999999046326,"responseStart":682.5999999046326,"secureConnectionStart":327.90000009536743},{"duration":355,"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":328.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":328.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":683.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":354.80000019073486,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":328.40000009536743,"connectEnd":328.40000009536743,"connectStart":328.40000009536743,"domainLookupEnd":328.40000009536743,"domainLookupStart":328.40000009536743,"fetchStart":328.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":328.40000009536743,"responseEnd":683.2000002861023,"responseStart":683.2000002861023,"secureConnectionStart":328.40000009536743},{"duration":453.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":355.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":355.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":808.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":397.69999980926514,"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":355.40000009536743,"connectEnd":355.40000009536743,"connectStart":355.40000009536743,"domainLookupEnd":355.40000009536743,"domainLookupStart":355.40000009536743,"fetchStart":355.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":355.40000009536743,"responseEnd":753.0999999046326,"responseStart":753.0999999046326,"secureConnectionStart":355.40000009536743}],"threshold":1000,"fetchStart":0,"domainLookupStart":218,"domainLookupEnd":218,"connectStart":218,"connectEnd":268,"secureConnectionStart":242,"requestStart":268,"responseStart":316,"responseEnd":386,"domLoading":320,"domInteractive":1573,"domContentLoadedEventStart":1573,"domContentLoadedEventEnd":1618,"domComplete":2084,"loadEventStart":2084,"loadEventEnd":2087,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"3e2ab295ca0a00","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":88,"dbReadsTimeInMs":12,"dbConnsTimeInMs":15,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Resolved as proposed 2020-5-28.