Proposal:
Hide
Ex 60: Replace
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount))
with
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))
Ex 61: Replace
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount, Sales(Amount with sum as TotalAmount)))
with
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount, Sales(Amount with sum as TotalAmount)))
Show
Ex 60: Replace
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount))
with
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))
Ex 61: Replace
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount, Sales(Amount with sum as TotalAmount)))
with
GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount, Sales(Amount with sum as TotalAmount)))
The examples make use of $count applied to a path expression in an aggregate expression without specifying an aggregation method, e.g. aggregate(Sales/$count as SalesCount)
This syntax construct and its semantics has been introduced in the Core specification, section 11.2.6.1 System Query Option $filter and must not be confused with the virtual property $count defined in the Data Aggregation extension specification, section 3.1.5 Virtual Property $count . It represents a common expression that, if used in the aggregate transformation, must be complemented with an aggregation method.
Gerald Krause
made changes -
26/May/20 10:27 AM
Field
Original Value
New Value
Proposal
Ex 60:
Replace
{{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount))}}
with
{{ GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))}}
Ex 61: Replace
{{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}
with
{{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}
*Ex 60: Replace*
{{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount))}}
with
{{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount))}}
*Ex 61: Replace*
{{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}
with
{{GET ~/Products?$apply=groupby((Name),aggregate(Sales/$count with sum as SalesCount,}}{{Sales(Amount with sum as TotalAmount)))}}
Gerald Krause
made changes -
26/May/20 1:38 PM
Status
New
[ 10000
]
Closed
[ 6
]
Ralf Handl
made changes -
20/Jul/23 6:44 AM
Status
Closed
[ 6
]
Open
[ 1
]
Ralf Handl
made changes -
20/Jul/23 6:44 AM
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Resolved
[ 5
]
Ralf Handl
made changes -
20/Jul/23 6:44 AM
Status
Resolved
[ 5
]
Applied
[ 10002
]
Ralf Handl
made changes -
20/Jul/23 6:44 AM
Status
Applied
[ 10002
]
Closed
[ 6
]
{"report":{"apdex":1,"isInitial":true,"journeyId":"9ef70287-7872-4228-a1da-3db05923cf55","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":782.9000000953674,"redirectCount":0,"resourceLoadedEnd":644.8000001907349,"resourceLoadedStart":151.69999980926514,"resourceTiming":[{"duration":205.2000002861023,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":151.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":151.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":356.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":205.19999980926514,"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":152,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":357.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":205.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":152.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":357.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":204.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":152.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":357.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":204.80000019073486,"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":152.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":357.5,"responseStart":0,"secureConnectionStart":0},{"duration":213.40000009536743,"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":152.90000009536743,"connectEnd":152.90000009536743,"connectStart":152.90000009536743,"domainLookupEnd":152.90000009536743,"domainLookupStart":152.90000009536743,"fetchStart":152.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":152.90000009536743,"responseEnd":366.30000019073486,"responseStart":366.30000019073486,"secureConnectionStart":152.90000009536743},{"duration":228.09999990463257,"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":153.59999990463257,"connectEnd":153.59999990463257,"connectStart":153.59999990463257,"domainLookupEnd":153.59999990463257,"domainLookupStart":153.59999990463257,"fetchStart":153.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":153.59999990463257,"responseEnd":381.69999980926514,"responseStart":381.69999980926514,"secureConnectionStart":153.59999990463257},{"duration":230.39999961853027,"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":153.80000019073486,"connectEnd":153.80000019073486,"connectStart":153.80000019073486,"domainLookupEnd":153.80000019073486,"domainLookupStart":153.80000019073486,"fetchStart":153.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":153.80000019073486,"responseEnd":384.19999980926514,"responseStart":384.19999980926514,"secureConnectionStart":153.80000019073486},{"duration":230.69999980926514,"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":154,"connectEnd":154,"connectStart":154,"domainLookupEnd":154,"domainLookupStart":154,"fetchStart":154,"redirectEnd":0,"redirectStart":0,"requestStart":154,"responseEnd":384.69999980926514,"responseStart":384.69999980926514,"secureConnectionStart":154},{"duration":230.90000009536743,"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":154.19999980926514,"connectEnd":154.19999980926514,"connectStart":154.19999980926514,"domainLookupEnd":154.19999980926514,"domainLookupStart":154.19999980926514,"fetchStart":154.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":154.19999980926514,"responseEnd":385.09999990463257,"responseStart":385,"secureConnectionStart":154.19999980926514},{"duration":231.09999990463257,"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":154.40000009536743,"connectEnd":154.40000009536743,"connectStart":154.40000009536743,"domainLookupEnd":154.40000009536743,"domainLookupStart":154.40000009536743,"fetchStart":154.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":154.40000009536743,"responseEnd":385.5,"responseStart":385.5,"secureConnectionStart":154.40000009536743},{"duration":231.40000009536743,"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":154.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":386,"responseStart":0,"secureConnectionStart":0},{"duration":231.10000038146973,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":154.69999980926514,"connectEnd":154.69999980926514,"connectStart":154.69999980926514,"domainLookupEnd":154.69999980926514,"domainLookupStart":154.69999980926514,"fetchStart":154.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":154.69999980926514,"responseEnd":385.80000019073486,"responseStart":385.80000019073486,"secureConnectionStart":154.69999980926514},{"duration":188,"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":200.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":388.5,"responseStart":0,"secureConnectionStart":0},{"duration":186.40000009536743,"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":200.69999980926514,"connectEnd":200.69999980926514,"connectStart":200.69999980926514,"domainLookupEnd":200.69999980926514,"domainLookupStart":200.69999980926514,"fetchStart":200.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":200.69999980926514,"responseEnd":387.09999990463257,"responseStart":387.09999990463257,"secureConnectionStart":200.69999980926514},{"duration":434.5,"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":209.80000019073486,"connectEnd":209.80000019073486,"connectStart":209.80000019073486,"domainLookupEnd":209.80000019073486,"domainLookupStart":209.80000019073486,"fetchStart":209.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":209.80000019073486,"responseEnd":644.3000001907349,"responseStart":644.3000001907349,"secureConnectionStart":209.80000019073486},{"duration":412.7000002861023,"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":232.09999990463257,"connectEnd":232.09999990463257,"connectStart":232.09999990463257,"domainLookupEnd":232.09999990463257,"domainLookupStart":232.09999990463257,"fetchStart":232.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":232.09999990463257,"responseEnd":644.8000001907349,"responseStart":644.8000001907349,"secureConnectionStart":232.09999990463257},{"duration":170.40000009536743,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":603.4000000953674,"connectEnd":603.4000000953674,"connectStart":603.4000000953674,"domainLookupEnd":603.4000000953674,"domainLookupStart":603.4000000953674,"fetchStart":603.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":603.4000000953674,"responseEnd":773.8000001907349,"responseStart":773.8000001907349,"secureConnectionStart":603.4000000953674}],"threshold":1000,"fetchStart":0,"domainLookupStart":45,"domainLookupEnd":45,"connectStart":45,"connectEnd":93,"secureConnectionStart":69,"requestStart":94,"responseStart":142,"responseEnd":232,"domLoading":147,"domInteractive":881,"domContentLoadedEventStart":881,"domContentLoadedEventEnd":932,"domComplete":1471,"loadEventStart":1471,"loadEventEnd":1473,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"2b8218a6cce8ef","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":113,"dbReadsTimeInMs":25,"dbConnsTimeInMs":30,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Duplicate of
ODATA-1255