-
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":"194ce142-1def-4794-ae49-118e6354bfba","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1147.2000000001863,"redirectCount":0,"resourceLoadedEnd":2069.7000000001863,"resourceLoadedStart":302.30000000004657,"resourceTiming":[{"duration":391.60000000009313,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":302.30000000004657,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":302.30000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":693.9000000001397,"responseStart":0,"secureConnectionStart":0},{"duration":391.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":302.60000000009313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":302.60000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":694.1000000000931,"responseStart":0,"secureConnectionStart":0},{"duration":391.4000000001397,"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":302.80000000004657,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":302.80000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":694.2000000001863,"responseStart":0,"secureConnectionStart":0},{"duration":391.4000000001397,"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":303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":694.4000000001397,"responseStart":0,"secureConnectionStart":0},{"duration":391.10000000009313,"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":303.30000000004657,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":303.30000000004657,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":694.4000000001397,"responseStart":0,"secureConnectionStart":0},{"duration":401.30000000004657,"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":303.5,"connectEnd":303.5,"connectStart":303.5,"domainLookupEnd":303.5,"domainLookupStart":303.5,"fetchStart":303.5,"redirectEnd":0,"redirectStart":0,"requestStart":303.5,"responseEnd":704.8000000000466,"responseStart":704.8000000000466,"secureConnectionStart":303.5},{"duration":459.39999999990687,"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":304.10000000009313,"connectEnd":304.10000000009313,"connectStart":304.10000000009313,"domainLookupEnd":304.10000000009313,"domainLookupStart":304.10000000009313,"fetchStart":304.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":304.10000000009313,"responseEnd":763.5,"responseStart":763.5,"secureConnectionStart":304.10000000009313},{"duration":461.69999999995343,"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":304.20000000018626,"connectEnd":304.20000000018626,"connectStart":304.20000000018626,"domainLookupEnd":304.20000000018626,"domainLookupStart":304.20000000018626,"fetchStart":304.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":304.20000000018626,"responseEnd":765.9000000001397,"responseStart":765.9000000001397,"secureConnectionStart":304.20000000018626},{"duration":462,"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":304.4000000001397,"connectEnd":304.4000000001397,"connectStart":304.4000000001397,"domainLookupEnd":304.4000000001397,"domainLookupStart":304.4000000001397,"fetchStart":304.4000000001397,"redirectEnd":0,"redirectStart":0,"requestStart":304.4000000001397,"responseEnd":766.4000000001397,"responseStart":766.4000000001397,"secureConnectionStart":304.4000000001397},{"duration":462.60000000009313,"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":304.60000000009313,"connectEnd":304.60000000009313,"connectStart":304.60000000009313,"domainLookupEnd":304.60000000009313,"domainLookupStart":304.60000000009313,"fetchStart":304.60000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":304.60000000009313,"responseEnd":767.2000000001863,"responseStart":767.2000000001863,"secureConnectionStart":304.60000000009313},{"duration":466.5,"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":304.70000000018626,"connectEnd":304.70000000018626,"connectStart":304.70000000018626,"domainLookupEnd":304.70000000018626,"domainLookupStart":304.70000000018626,"fetchStart":304.70000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":304.70000000018626,"responseEnd":771.2000000001863,"responseStart":771.2000000001863,"secureConnectionStart":304.70000000018626},{"duration":467.30000000004657,"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":305,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":305,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":772.3000000000466,"responseStart":0,"secureConnectionStart":0},{"duration":467.19999999995343,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":305.10000000009313,"connectEnd":305.10000000009313,"connectStart":305.10000000009313,"domainLookupEnd":305.10000000009313,"domainLookupStart":305.10000000009313,"fetchStart":305.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":305.10000000009313,"responseEnd":772.3000000000466,"responseStart":772.2000000001863,"secureConnectionStart":305.10000000009313},{"duration":456.60000000009313,"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":339.10000000009313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":339.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":795.7000000001863,"responseStart":0,"secureConnectionStart":0},{"duration":455.9000000001397,"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":339.5,"connectEnd":339.5,"connectStart":339.5,"domainLookupEnd":339.5,"domainLookupStart":339.5,"fetchStart":339.5,"redirectEnd":0,"redirectStart":0,"requestStart":339.5,"responseEnd":795.4000000001397,"responseStart":795.4000000001397,"secureConnectionStart":339.5}],"threshold":1000,"fetchStart":0,"domainLookupStart":180,"domainLookupEnd":180,"connectStart":180,"connectEnd":235,"secureConnectionStart":206,"requestStart":235,"responseStart":290,"responseEnd":367,"domLoading":297,"domInteractive":2115,"domContentLoadedEventStart":2115,"domContentLoadedEventEnd":2176,"domComplete":2531,"loadEventStart":2531,"loadEventEnd":2534,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"45666be2e5b474","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":103,"dbReadsTimeInMs":22,"dbConnsTimeInMs":26,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Supplement: PoCs to validate the mapping of the new hierarchy transformations to SQL, namely Microsoft SQL Server, SQLite and SAP HANA 2: