Proposal:
Hide
Treat the result structures with related entities expanded from all $apply transformations in a uniform manner.
The necessary changes to the specification text and examples are described in this document
Show
Treat the result structures with related entities expanded from all $apply transformations in a uniform manner.
The necessary changes to the specification text and examples are described in this document
Resolution:
Show
https://www.oasis-open.org/apps/org/workgroup/odata/download.php/69361/odata-data-aggregation-ext-v4.0-wd05.docx
In the context of ODATA-1449transformnested include a navigation property, the resources addressed by that path are included in the output set of the transformation, but that it requires a dedicated $expand of that navigation property to include the resources also in the response to the request.
This is in line with the following para in section 3 System Query Option $apply of the current WD of the spec: : "This means an output set can contain structural and dynamic properties as well as navigation properties, Navigation properties in the result of $apply can be further expanded using $expand (see Evaluating $apply )."
However, transformation groupby behaves differently: Navigation properties part of a grouping property path are returned expanded in the response to the request - see examples in spec text.
This means the specification has two behaviors when processing paths with navigation properties. It should be clarified if this is intended.
In this context, the text at the end of section 3.10.2 should be sharpened. It says: "Grouping properties that specify navigation properties are automatically expanded, and the specified properties of that navigation property correspond to properties specified in a $select expand option on the expanded navigation property. " - It is unclear if it describes the effect for the output set of the groupby transformation or for the response to the request.
made changes -
16/Jul/21 2:00 PM
Field
Original Value
New Value
Summary
Clarify representation of navigation properties in respone that are expanded by $apply
Clarify representation of navigation properties in response that are expanded by $apply
made changes -
12/Aug/21 3:55 PM
Status
New
[ 10000
]
Open
[ 1
]
made changes -
18/Nov/21 5:24 PM
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Resolved
[ 5
]
made changes -
26/Nov/21 5:32 PM
Environment
proposed
Applied
made changes -
30/Jun/23 11:04 AM
Status
Resolved
[ 5
]
Applied
[ 10002
]
made changes -
05/Jul/23 3:27 PM
Status
Applied
[ 10002
]
Closed
[ 6
]
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"7516a558-8edb-4180-9ace-7c0d582d7d55","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":2652,"redirectCount":0,"resourceLoadedEnd":2468.300000190735,"resourceLoadedStart":202,"resourceTiming":[{"duration":92.5,"initiatorType":"link","name":"https://issues.oasis-open.org/s/3edeca31ab9ba77980aae0809fbe7121-CDN/nu8zej/803004/aeedb5937bed650f2f0cc4ec9ceaa5d3/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":202,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":294.5,"responseStart":0,"secureConnectionStart":0},{"duration":99.7999997138977,"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":202.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":302.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":100.40000009536743,"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":202.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":302.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":100.60000038146973,"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":202.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":303.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":102,"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":202.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":304.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":641.6000003814697,"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":203.19999980926514,"connectEnd":591.5999999046326,"connectStart":542,"domainLookupEnd":542,"domainLookupStart":542,"fetchStart":203.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":591.6999998092651,"responseEnd":844.8000001907349,"responseStart":657.3000001907349,"secureConnectionStart":566.5},{"duration":2264.6000003814697,"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":203.69999980926514,"connectEnd":710.0999999046326,"connectStart":660.3000001907349,"domainLookupEnd":660.3000001907349,"domainLookupStart":660.3000001907349,"fetchStart":203.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":710.0999999046326,"responseEnd":2468.300000190735,"responseStart":739.0999999046326,"secureConnectionStart":684.8000001907349},{"duration":465.59999990463257,"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":203.90000009536743,"connectEnd":642.4000000953674,"connectStart":592.8000001907349,"domainLookupEnd":592.8000001907349,"domainLookupStart":592.8000001907349,"fetchStart":203.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":642.5999999046326,"responseEnd":669.5,"responseStart":668.6999998092651,"secureConnectionStart":617.3000001907349},{"duration":543.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":204.09999990463257,"connectEnd":719.5999999046326,"connectStart":669.4000000953674,"domainLookupEnd":669.4000000953674,"domainLookupStart":669.4000000953674,"fetchStart":204.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":719.8000001907349,"responseEnd":747.8000001907349,"responseStart":747,"secureConnectionStart":694.3000001907349},{"duration":545,"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":204.19999980926514,"connectEnd":721.3000001907349,"connectStart":671.6999998092651,"domainLookupEnd":671.6999998092651,"domainLookupStart":671.5999999046326,"fetchStart":204.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":721.4000000953674,"responseEnd":749.1999998092651,"responseStart":747.9000000953674,"secureConnectionStart":696.1999998092651},{"duration":621.8000001907349,"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":204.5,"connectEnd":797.5,"connectStart":747.6999998092651,"domainLookupEnd":747.6999998092651,"domainLookupStart":747.6999998092651,"fetchStart":204.5,"redirectEnd":0,"redirectStart":0,"requestStart":797.5999999046326,"responseEnd":826.3000001907349,"responseStart":825.1999998092651,"secureConnectionStart":772.3000001907349},{"duration":105.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":204.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":309.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":622.9000000953674,"initiatorType":"script","name":"https://issues.oasis-open.org/rest/api/1.0/shortcuts/803004/a29179d70fa8562374ee16707692af77/shortcuts.js?context=issuenavigation&context=issueaction","startTime":204.69999980926514,"connectEnd":798.4000000953674,"connectStart":749.0999999046326,"domainLookupEnd":749.0999999046326,"domainLookupStart":749,"fetchStart":204.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":798.5999999046326,"responseEnd":827.5999999046326,"responseStart":826.9000000953674,"secureConnectionStart":773.5999999046326},{"duration":95.59999990463257,"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":267.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":362.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":1877.5999999046326,"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":267.5,"connectEnd":2116.800000190735,"connectStart":2067.0999999046326,"domainLookupEnd":2067.0999999046326,"domainLookupStart":2067.0999999046326,"fetchStart":267.5,"redirectEnd":0,"redirectStart":0,"requestStart":2116.9000000953674,"responseEnd":2145.0999999046326,"responseStart":2144.300000190735,"secureConnectionStart":2091.699999809265},{"duration":2174,"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":278.09999990463257,"connectEnd":2424.4000000953674,"connectStart":2374.5,"domainLookupEnd":2374.5,"domainLookupStart":2374.5,"fetchStart":278.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":2424.5,"responseEnd":2452.0999999046326,"responseStart":2451.300000190735,"secureConnectionStart":2399.199999809265},{"duration":2156.300000190735,"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":304.19999980926514,"connectEnd":2432.0999999046326,"connectStart":2382,"domainLookupEnd":2382,"domainLookupStart":2382,"fetchStart":304.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":2432.5,"responseEnd":2460.5,"responseStart":2459.5,"secureConnectionStart":2406.9000000953674},{"duration":1271.1999998092651,"initiatorType":"xmlhttprequest","name":"https://issues.oasis-open.org/rest/webResources/1.0/resources","startTime":970.8000001907349,"connectEnd":2211,"connectStart":2161,"domainLookupEnd":2161,"domainLookupStart":2161,"fetchStart":970.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":2211,"responseEnd":2242,"responseStart":2241.199999809265,"secureConnectionStart":2185.699999809265}],"threshold":1000,"fetchStart":0,"domainLookupStart":23,"domainLookupEnd":50,"connectStart":50,"connectEnd":140,"secureConnectionStart":75,"requestStart":140,"responseStart":193,"responseEnd":304,"domLoading":197,"domInteractive":2708,"domContentLoadedEventStart":2708,"domContentLoadedEventEnd":2763,"domComplete":3177,"loadEventStart":3177,"loadEventEnd":3179,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"4c87314f6e8316","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":138,"dbReadsTimeInMs":44,"dbConnsTimeInMs":51,"applicationHash":"4d4040e0714d65b7fffa4801569d014c0b16eaa9","experiments":[]}}
Improvement
Major
Without auto-$expand, the result of Example 23 would look so:
{ "@odata.context": "$metadata#Sales(Total)", "value": [ { "Total": 3, ... }, { "Total": 2, ... }, { "Total": 12, ... }, { "Total": 5, ... }, { "Total": 2, ... } ] }