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.
Gerald Krause
made changes -
28/Apr/21 6:09 PM
Environment
Proposed
Applied
Ralf Handl
made changes -
30/Jun/23 11:04 AM
Status
Resolved
[ 5
]
Applied
[ 10002
]
Heiko Theissen
made changes -
05/Jul/23 3:27 PM
Status
Applied
[ 10002
]
Closed
[ 6
]
{"report":{"apdex":1,"isInitial":true,"journeyId":"80a14376-8475-4c4e-bf39-a25f4be61e4d","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":792.4000000953674,"redirectCount":0,"resourceLoadedEnd":749.9000000953674,"resourceLoadedStart":197.19999980926514,"resourceTiming":[{"duration":171.2000002861023,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":197.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":368.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":171.2000002861023,"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":197.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":368.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":171.19999980926514,"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":197.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":369,"responseStart":0,"secureConnectionStart":0},{"duration":171.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":198,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":369.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":171,"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":198.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":198.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":369.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":206.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":198.5,"connectEnd":198.5,"connectStart":198.5,"domainLookupEnd":198.5,"domainLookupStart":198.5,"fetchStart":198.5,"redirectEnd":0,"redirectStart":0,"requestStart":198.5,"responseEnd":404.90000009536743,"responseStart":404.90000009536743,"secureConnectionStart":198.5},{"duration":234.2000002861023,"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":199.09999990463257,"connectEnd":199.09999990463257,"connectStart":199.09999990463257,"domainLookupEnd":199.09999990463257,"domainLookupStart":199.09999990463257,"fetchStart":199.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":199.09999990463257,"responseEnd":433.30000019073486,"responseStart":433.30000019073486,"secureConnectionStart":199.09999990463257},{"duration":236.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":199.40000009536743,"connectEnd":199.40000009536743,"connectStart":199.40000009536743,"domainLookupEnd":199.40000009536743,"domainLookupStart":199.40000009536743,"fetchStart":199.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":199.40000009536743,"responseEnd":435.59999990463257,"responseStart":435.59999990463257,"secureConnectionStart":199.40000009536743},{"duration":236.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":199.5,"connectEnd":199.5,"connectStart":199.5,"domainLookupEnd":199.5,"domainLookupStart":199.5,"fetchStart":199.5,"redirectEnd":0,"redirectStart":0,"requestStart":199.5,"responseEnd":436,"responseStart":436,"secureConnectionStart":199.5},{"duration":236.60000038146973,"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":199.69999980926514,"connectEnd":199.69999980926514,"connectStart":199.69999980926514,"domainLookupEnd":199.69999980926514,"domainLookupStart":199.69999980926514,"fetchStart":199.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":199.69999980926514,"responseEnd":436.30000019073486,"responseStart":436.30000019073486,"secureConnectionStart":199.69999980926514},{"duration":236.7999997138977,"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":199.90000009536743,"connectEnd":199.90000009536743,"connectStart":199.90000009536743,"domainLookupEnd":199.90000009536743,"domainLookupStart":199.90000009536743,"fetchStart":199.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":199.90000009536743,"responseEnd":436.69999980926514,"responseStart":436.69999980926514,"secureConnectionStart":199.90000009536743},{"duration":371,"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":200,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":200,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":571,"responseStart":0,"secureConnectionStart":0},{"duration":236.90000009536743,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":200.19999980926514,"connectEnd":200.19999980926514,"connectStart":200.19999980926514,"domainLookupEnd":200.19999980926514,"domainLookupStart":200.19999980926514,"fetchStart":200.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":200.19999980926514,"responseEnd":437.09999990463257,"responseStart":437.09999990463257,"secureConnectionStart":200.19999980926514},{"duration":288.8999996185303,"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":282.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":282.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":571.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":188,"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":282.5,"connectEnd":282.5,"connectStart":282.5,"domainLookupEnd":282.5,"domainLookupStart":282.5,"fetchStart":282.5,"redirectEnd":0,"redirectStart":0,"requestStart":282.5,"responseEnd":470.5,"responseStart":470.5,"secureConnectionStart":282.5},{"duration":452.2999997138977,"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":292.40000009536743,"connectEnd":292.40000009536743,"connectStart":292.40000009536743,"domainLookupEnd":292.40000009536743,"domainLookupStart":292.40000009536743,"fetchStart":292.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":292.40000009536743,"responseEnd":744.6999998092651,"responseStart":744.6999998092651,"secureConnectionStart":292.40000009536743},{"duration":376.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":373.19999980926514,"connectEnd":373.19999980926514,"connectStart":373.19999980926514,"domainLookupEnd":373.19999980926514,"domainLookupStart":373.19999980926514,"fetchStart":373.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":373.19999980926514,"responseEnd":749.9000000953674,"responseStart":749.9000000953674,"secureConnectionStart":373.19999980926514},{"duration":100.30000019073486,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":642.5,"connectEnd":642.5,"connectStart":642.5,"domainLookupEnd":642.5,"domainLookupStart":642.5,"fetchStart":642.5,"redirectEnd":0,"redirectStart":0,"requestStart":642.5,"responseEnd":742.8000001907349,"responseStart":742.8000001907349,"secureConnectionStart":642.5}],"threshold":1000,"fetchStart":0,"domainLookupStart":84,"domainLookupEnd":84,"connectStart":84,"connectEnd":132,"secureConnectionStart":108,"requestStart":132,"responseStart":178,"responseEnd":373,"domLoading":182,"domInteractive":936,"domContentLoadedEventStart":936,"domContentLoadedEventEnd":1020,"domComplete":1412,"loadEventStart":1412,"loadEventEnd":1414,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"5d4f48b7d98c53","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":204,"dbReadsTimeInMs":60,"dbConnsTimeInMs":66,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Created PR for mapping hierarchy transformations to SQLite using recursive common table expressions from standard SQL:1999.