-
Proposal:
Hide
Details are described in the document “Grid-Like Access to Aggregated Data”, sections 4 and 8.1: https://www.oasis-open.org/committees/document.php?document_id=62593&wg_abbrev=odata
Excerpt from relevant section 8.1: Extend the expressions that can be passed to the orderby transformation by an optional suffix that, if specified, determines the position of undefined values of properties that have been aggregated away:
With orderby( <orderbyItem> undefined first ) undefined values of the orderby item come before any defined value. The order among the undefined values is undefined.
With orderby( <orderbyItem> undefined last ) undefined values of the orderby item come after any defined value. The order among the undefined values is undefined.
Show
Details are described in the document “Grid-Like Access to Aggregated Data”, sections 4 and 8.1: https://www.oasis-open.org/committees/document.php?document_id=62593&wg_abbrev=odata
Excerpt from relevant section 8.1: Extend the expressions that can be passed to the orderby transformation by an optional suffix that, if specified, determines the position of undefined values of properties that have been aggregated away:
With orderby( <orderbyItem> undefined first ) undefined values of the orderby item come before any defined value. The order among the undefined values is undefined.
With orderby( <orderbyItem> undefined last ) undefined values of the orderby item come after any defined value. The order among the undefined values is undefined.
-
Resolution:
Hide
As per 2018-6-7, closing with no action. We can already support this by putting expressions in the orderby:
orderby(Continent,isdefined(Country) desc,Country desc)
orderby(Continent,isdefined(Country) asc,Country desc)
orderby(Continent,Country eq null asc,Country desc)
Show
As per 2018-6-7, closing with no action. We can already support this by putting expressions in the orderby:
orderby(Continent,isdefined(Country) desc,Country desc)
orderby(Continent,isdefined(Country) asc,Country desc)
orderby(Continent,Country eq null asc,Country desc)
Extend $orderby expressions accepted by the orderby transformation with the option to specify how to sort undefined properties.
In general, the demand for being able to specify the position of entities with undefined properties emerges from combining transformation sequences using concat or by applying groupby(rollup(...), ...). A concrete use case is described in more detail in https://www.oasis-open.org/committees/document.php?document_id=62593&wg_abbrev=odata.
There are no comments yet on this issue.
{"report":{"apdex":1,"isInitial":true,"journeyId":"664c0b9a-540d-467e-9488-2b88d0887982","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":986.4000000953674,"redirectCount":0,"resourceLoadedEnd":1158.3000001907349,"resourceLoadedStart":137.80000019073486,"resourceTiming":[{"duration":498.5,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":137.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":137.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":636.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":498.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":138.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":636.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":498.30000019073486,"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":138.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":636.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":498.09999990463257,"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":138.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":636.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":498.09999990463257,"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":138.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":636.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":516.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":139.10000038146973,"connectEnd":139.10000038146973,"connectStart":139.10000038146973,"domainLookupEnd":139.10000038146973,"domainLookupStart":139.10000038146973,"fetchStart":139.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":139.10000038146973,"responseEnd":655.6000003814697,"responseStart":655.6000003814697,"secureConnectionStart":139.10000038146973},{"duration":553.2999997138977,"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":139.60000038146973,"connectEnd":139.60000038146973,"connectStart":139.60000038146973,"domainLookupEnd":139.60000038146973,"domainLookupStart":139.60000038146973,"fetchStart":139.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":139.60000038146973,"responseEnd":692.9000000953674,"responseStart":692.9000000953674,"secureConnectionStart":139.60000038146973},{"duration":555.3000001907349,"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":139.80000019073486,"connectEnd":139.80000019073486,"connectStart":139.80000019073486,"domainLookupEnd":139.80000019073486,"domainLookupStart":139.80000019073486,"fetchStart":139.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":139.80000019073486,"responseEnd":695.1000003814697,"responseStart":695.1000003814697,"secureConnectionStart":139.80000019073486},{"duration":587.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":140,"connectEnd":140,"connectStart":140,"domainLookupEnd":140,"domainLookupStart":140,"fetchStart":140,"redirectEnd":0,"redirectStart":0,"requestStart":140,"responseEnd":727.5,"responseStart":727.5,"secureConnectionStart":140},{"duration":591.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":140.2000002861023,"connectEnd":140.2000002861023,"connectStart":140.2000002861023,"domainLookupEnd":140.2000002861023,"domainLookupStart":140.2000002861023,"fetchStart":140.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":140.2000002861023,"responseEnd":731.5,"responseStart":731.5,"secureConnectionStart":140.2000002861023},{"duration":594,"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":140.30000019073486,"connectEnd":140.30000019073486,"connectStart":140.30000019073486,"domainLookupEnd":140.30000019073486,"domainLookupStart":140.30000019073486,"fetchStart":140.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":140.30000019073486,"responseEnd":734.3000001907349,"responseStart":734.3000001907349,"secureConnectionStart":140.30000019073486},{"duration":659.2000002861023,"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":140.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":140.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":799.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":596,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":140.60000038146973,"connectEnd":140.60000038146973,"connectStart":140.60000038146973,"domainLookupEnd":140.60000038146973,"domainLookupStart":140.60000038146973,"fetchStart":140.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":140.60000038146973,"responseEnd":736.6000003814697,"responseStart":736.6000003814697,"secureConnectionStart":140.60000038146973},{"duration":623.6999998092651,"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":176.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":176.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":799.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":563.0999999046326,"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":176.30000019073486,"connectEnd":176.30000019073486,"connectStart":176.30000019073486,"domainLookupEnd":176.30000019073486,"domainLookupStart":176.30000019073486,"fetchStart":176.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":176.30000019073486,"responseEnd":739.4000000953674,"responseStart":739.4000000953674,"secureConnectionStart":176.30000019073486}],"threshold":1000,"fetchStart":0,"domainLookupStart":11,"domainLookupEnd":11,"connectStart":11,"connectEnd":60,"secureConnectionStart":35,"requestStart":60,"responseStart":127,"responseEnd":195,"domLoading":131,"domInteractive":1171,"domContentLoadedEventStart":1171,"domContentLoadedEventEnd":1211,"domComplete":1515,"loadEventStart":1515,"loadEventEnd":1518,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"24f9fe7f715ae","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":107,"dbReadsTimeInMs":18,"dbConnsTimeInMs":20,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}