-
Proposal:
Show
Overview and examples: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/65934/Enhanced%20support%20for%20hierarchy%20use%20cases%20-%20Examples.pptx
Context, use cases and proposals for new transformations: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/68535/Enhanced%20support%20for%20hierarchy%20use%20cases%20V1.6.4.1.docx (covers all feedback items from the review discussion)
-
Resolution:
Show
https://github.com/oasis-tcs/odata-vocabularies/pull/121
Working with hierarchies often involves functionality to select sub-hierarchies, to retrieve hierarchy nodes in a specified tree order, and to aggregate bottom-up along the hierarchy paths.
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"59835346-ace4-40fb-bbb1-68e4905896fc","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":2915.300000190735,"redirectCount":0,"resourceLoadedEnd":2759.300000190735,"resourceLoadedStart":264.90000009536743,"resourceTiming":[{"duration":15.5,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":264.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":264.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":280.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":16.799999713897705,"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":265.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":265.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":282,"responseStart":0,"secureConnectionStart":0},{"duration":16.700000286102295,"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":265.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":265.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":282.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":16.59999990463257,"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":265.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":265.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":282.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":17,"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":265.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":265.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":282.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":470.1000003814697,"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":266,"connectEnd":512.1000003814697,"connectStart":463.7000002861023,"domainLookupEnd":463.7000002861023,"domainLookupStart":463.7000002861023,"fetchStart":266,"redirectEnd":0,"redirectStart":0,"requestStart":512.2000002861023,"responseEnd":736.1000003814697,"responseStart":550.8000001907349,"secureConnectionStart":487.90000009536743},{"duration":2464.0999999046326,"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":266.6000003814697,"connectEnd":522.7000002861023,"connectStart":474.5,"domainLookupEnd":474.5,"domainLookupStart":474.5,"fetchStart":266.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":522.8000001907349,"responseEnd":2730.7000002861023,"responseStart":551.8000001907349,"secureConnectionStart":498.30000019073486},{"duration":299.90000009536743,"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":266.80000019073486,"connectEnd":539.4000000953674,"connectStart":487.2000002861023,"domainLookupEnd":487.2000002861023,"domainLookupStart":487.2000002861023,"fetchStart":266.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":539.6000003814697,"responseEnd":566.7000002861023,"responseStart":565.7000002861023,"secureConnectionStart":511.30000019073486},{"duration":336.7000002861023,"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":267,"connectEnd":575.9000000953674,"connectStart":527,"domainLookupEnd":527,"domainLookupStart":526.9000000953674,"fetchStart":267,"redirectEnd":0,"redirectStart":0,"requestStart":576.1000003814697,"responseEnd":603.7000002861023,"responseStart":602.7000002861023,"secureConnectionStart":551.4000000953674},{"duration":347.59999990463257,"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":267.2000002861023,"connectEnd":587.6000003814697,"connectStart":538.9000000953674,"domainLookupEnd":538.9000000953674,"domainLookupStart":538.9000000953674,"fetchStart":267.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":587.7000002861023,"responseEnd":614.8000001907349,"responseStart":613.9000000953674,"secureConnectionStart":562.9000000953674},{"duration":376.59999990463257,"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":267.30000019073486,"connectEnd":615.5,"connectStart":566.5,"domainLookupEnd":566.5,"domainLookupStart":566.4000000953674,"fetchStart":267.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":615.7000002861023,"responseEnd":643.9000000953674,"responseStart":643.1000003814697,"secureConnectionStart":590.5},{"duration":21.5,"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":267.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":289,"responseStart":0,"secureConnectionStart":0},{"duration":411.59999990463257,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":267.7000002861023,"connectEnd":651.9000000953674,"connectStart":603.6000003814697,"domainLookupEnd":603.6000003814697,"domainLookupStart":603.5,"fetchStart":267.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":652.1000003814697,"responseEnd":679.3000001907349,"responseStart":678.5,"secureConnectionStart":627.5},{"duration":37.5,"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":345.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":345.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":382.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":1862.1999998092651,"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":345.30000019073486,"connectEnd":2179.6000003814697,"connectStart":2131.9000000953674,"domainLookupEnd":2131.9000000953674,"domainLookupStart":2131.7000002861023,"fetchStart":345.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":2179.7000002861023,"responseEnd":2207.5,"responseStart":2206.6000003814697,"secureConnectionStart":2155.5},{"duration":2320.199999809265,"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":363.80000019073486,"connectEnd":2656.2000002861023,"connectStart":2608.2000002861023,"domainLookupEnd":2608.2000002861023,"domainLookupStart":2608.1000003814697,"fetchStart":363.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":2656.300000190735,"responseEnd":2684,"responseStart":2682.7000002861023,"secureConnectionStart":2631.9000000953674},{"duration":2347.9000000953674,"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":411.40000009536743,"connectEnd":2731.2000002861023,"connectStart":2682.1000003814697,"domainLookupEnd":2682.1000003814697,"domainLookupStart":2682.1000003814697,"fetchStart":411.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":2731.300000190735,"responseEnd":2759.300000190735,"responseStart":2757.800000190735,"secureConnectionStart":2706.300000190735},{"duration":1573.0999999046326,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":874.6000003814697,"connectEnd":2414.5,"connectStart":2366,"domainLookupEnd":2366,"domainLookupStart":2366,"fetchStart":874.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":2414.6000003814697,"responseEnd":2447.7000002861023,"responseStart":2446.9000000953674,"secureConnectionStart":2389.800000190735},{"duration":62.40000009536743,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":2783.7000002861023,"connectEnd":2783.7000002861023,"connectStart":2783.7000002861023,"domainLookupEnd":2783.7000002861023,"domainLookupStart":2783.7000002861023,"fetchStart":2783.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":2783.7000002861023,"responseEnd":2846.1000003814697,"responseStart":2846.1000003814697,"secureConnectionStart":2783.7000002861023}],"threshold":1000,"fetchStart":0,"domainLookupStart":22,"domainLookupEnd":86,"connectStart":86,"connectEnd":172,"secureConnectionStart":110,"requestStart":172,"responseStart":252,"responseEnd":411,"domLoading":255,"domInteractive":2997,"domContentLoadedEventStart":2997,"domContentLoadedEventEnd":3065,"domComplete":3147,"loadEventStart":3147,"loadEventEnd":3149,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"db78df4e9ef13e","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":199,"dbReadsTimeInMs":54,"dbConnsTimeInMs":61,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Created PR for mapping hierarchy transformations to SQLite using recursive common table expressions from standard SQL:1999.