-
Proposal:
Hide
An OData representation of a grid-like result spanned by multiple axes could be achieved by a new transformation nest() that allows to embed data of grid cells as a nested collection of entities representing grid rows.
Relevant excerpt from section 3 in the referenced document: The nest transformation has two parameters. The first takes the name of a dynamic containment navigation property, the second is a (chain of) $apply transformations. nest( cnp, t ) applies transformation chain t to the input set and creates a result set containing a single entity that only contains the navigation property cnp, which in turn holds the result collection of t applied to the input set:
{ <cnp>: [ <result of t applied to input set> ] }
Show
An OData representation of a grid-like result spanned by multiple axes could be achieved by a new transformation nest() that allows to embed data of grid cells as a nested collection of entities representing grid rows.
Relevant excerpt from section 3 in the referenced document: The nest transformation has two parameters. The first takes the name of a dynamic containment navigation property, the second is a (chain of) $apply transformations. nest( cnp, t ) applies transformation chain t to the input set and creates a result set containing a single entity that only contains the navigation property cnp , which in turn holds the result collection of t applied to the input set:
{ <cnp>: [ <result of t applied to input set> ] }
This new feature is motivated by a concrete use case. The current version of the Data Aggregation specification already includes an example for a cross-table and describes how to retrieve its data using transformation groupby in combination with rollup. However, this data is returned as linear collection of entities. For working with data in a grid efficiently, it must be possible to access selected sections of the grid. Details are described in the document “Grid-Like Access to Aggregated Data”, sections 2 and 3: https://www.oasis-open.org/committees/document.php?document_id=62593&wg_abbrev=odata
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"1569d056-5e7d-429a-978c-9ef28c301c06","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1394.2999999998137,"redirectCount":0,"resourceLoadedEnd":2198.2999999998137,"resourceLoadedStart":376,"resourceTiming":[{"duration":488.0999999998603,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":376,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":376,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":864.0999999998603,"responseStart":0,"secureConnectionStart":0},{"duration":488.10000000009313,"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":376.29999999981374,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":376.29999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":864.3999999999069,"responseStart":0,"secureConnectionStart":0},{"duration":488.10000000009313,"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":376.39999999990687,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":376.39999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":864.5,"responseStart":0,"secureConnectionStart":0},{"duration":487.89999999990687,"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":376.69999999995343,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":376.69999999995343,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":864.5999999998603,"responseStart":0,"secureConnectionStart":0},{"duration":487.5999999998603,"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":377,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":377,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":864.5999999998603,"responseStart":0,"secureConnectionStart":0},{"duration":508.89999999990687,"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":377.19999999995343,"connectEnd":377.19999999995343,"connectStart":377.19999999995343,"domainLookupEnd":377.19999999995343,"domainLookupStart":377.19999999995343,"fetchStart":377.19999999995343,"redirectEnd":0,"redirectStart":0,"requestStart":377.19999999995343,"responseEnd":886.0999999998603,"responseStart":886.0999999998603,"secureConnectionStart":377.19999999995343},{"duration":568.6000000000931,"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":377.89999999990687,"connectEnd":377.89999999990687,"connectStart":377.89999999990687,"domainLookupEnd":377.89999999990687,"domainLookupStart":377.89999999990687,"fetchStart":377.89999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":377.89999999990687,"responseEnd":946.5,"responseStart":946.5,"secureConnectionStart":377.89999999990687},{"duration":574.1999999999534,"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":378.0999999998603,"connectEnd":378.0999999998603,"connectStart":378.0999999998603,"domainLookupEnd":378.0999999998603,"domainLookupStart":378.0999999998603,"fetchStart":378.0999999998603,"redirectEnd":0,"redirectStart":0,"requestStart":378.0999999998603,"responseEnd":952.2999999998137,"responseStart":952.2999999998137,"secureConnectionStart":378.0999999998603},{"duration":574.7000000001863,"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":378.29999999981374,"connectEnd":378.29999999981374,"connectStart":378.29999999981374,"domainLookupEnd":378.29999999981374,"domainLookupStart":378.29999999981374,"fetchStart":378.29999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":378.29999999981374,"responseEnd":953,"responseStart":953,"secureConnectionStart":378.29999999981374},{"duration":575.1999999999534,"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":378.5999999998603,"connectEnd":378.5999999998603,"connectStart":378.5999999998603,"domainLookupEnd":378.5999999998603,"domainLookupStart":378.5999999998603,"fetchStart":378.5999999998603,"redirectEnd":0,"redirectStart":0,"requestStart":378.5999999998603,"responseEnd":953.7999999998137,"responseStart":953.7999999998137,"secureConnectionStart":378.5999999998603},{"duration":575.4000000001397,"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":378.79999999981374,"connectEnd":378.79999999981374,"connectStart":378.79999999981374,"domainLookupEnd":378.79999999981374,"domainLookupStart":378.79999999981374,"fetchStart":378.79999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":378.79999999981374,"responseEnd":954.1999999999534,"responseStart":954.1999999999534,"secureConnectionStart":378.79999999981374},{"duration":588,"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":379,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":379,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":967,"responseStart":0,"secureConnectionStart":0},{"duration":576.1999999999534,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":379.0999999998603,"connectEnd":379.0999999998603,"connectStart":379.0999999998603,"domainLookupEnd":379.0999999998603,"domainLookupStart":379.0999999998603,"fetchStart":379.0999999998603,"redirectEnd":0,"redirectStart":0,"requestStart":379.0999999998603,"responseEnd":955.2999999998137,"responseStart":955.2999999998137,"secureConnectionStart":379.0999999998603},{"duration":730.1000000000931,"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":408.39999999990687,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":408.39999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1138.5,"responseStart":0,"secureConnectionStart":0},{"duration":638.0999999998603,"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":408.69999999995343,"connectEnd":408.69999999995343,"connectStart":408.69999999995343,"domainLookupEnd":408.69999999995343,"domainLookupStart":408.69999999995343,"fetchStart":408.69999999995343,"redirectEnd":0,"redirectStart":0,"requestStart":408.69999999995343,"responseEnd":1046.7999999998137,"responseStart":1046.7999999998137,"secureConnectionStart":408.69999999995343}],"threshold":1000,"fetchStart":1,"domainLookupStart":271,"domainLookupEnd":271,"connectStart":271,"connectEnd":321,"secureConnectionStart":295,"requestStart":321,"responseStart":368,"responseEnd":439,"domLoading":372,"domInteractive":2244,"domContentLoadedEventStart":2244,"domContentLoadedEventEnd":2319,"domComplete":2670,"loadEventStart":2670,"loadEventEnd":2673,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"b4cecbeda36a0e","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":86,"dbReadsTimeInMs":11,"dbConnsTimeInMs":13,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Resolved 2018-05-24