Export - CSV (All fields)
Export - CSV (Current fields)
- ODATA-1557
Collection-valued Aggregation.RecursiveHierarchy/ParentNavigationProperty - ODATA-1556
Entities with ambiguous property values - ODATA-1554
Clarify the algorithm for evaluating the compute transformation - ODATA-1533
Allow more methods to qualify start nodes of transformation ancestors and descendants - ODATA-1532
Align usages of recursive hierarchies - ODATA-1468
Unified treatment of paths in aggregate, groupby and transformnested - ODATA-1460
Aggregation.ApplySupportedDefaults: use PATCH logic when overriding with ApplySupported - ODATA-1459
Clarify representation of property paths in groupby with leading segments being null - ODATA-1458
Clarify representation of navigation properties in response that are expanded by $apply - ODATA-1452
search('text') instead of search(text) - ODATA-1451
Rephrase definitions for any, all and aggregate - ODATA-1449
Split nest into three transformations - ODATA-1444
groupby algorithm does not cover "select distinct" case - ODATA-1442
Update Aggregation ABNF with changes from previous issues - ODATA-1440
Aggregation.CustomAggregate applies to ComplexType still needed? - ODATA-1439
Improve descriptions of property restrictions in term Aggregation.ApplySupported - ODATA-1427
Clarify treatment of duplicates in OData-Aggr example 7 - ODATA-1423
Check uniform handling of entities reached via navigation in responses - ODATA-1414
Clarify application of term Aggregation.ApplySupported on entity containers - ODATA-1409
Add support for joining entities with instances of their related collections - ODATA-1406
Clarify behavior of aggregate on property paths with collection-valued properties - ODATA-1404
groupby specification does not explain example 54 - ODATA-1403
Annotation of implicit entity sets - ODATA-1402
Correct Nullable attributes in Aggregation vocabulary terms - ODATA-1395
Clarify impact of applying expand to subsequent transformations - ODATA-1392
Point out aggregation of amounts in different currencies - ODATA-1391
Enable usage of $this and $root in filter transformation - ODATA-1390
Clean up annotation term RecursiveHierarchy - ODATA-1384
Clarify usage of annotation qualifiers as references to hierarchies - ODATA-1383
Complete the cardinalities in data model - ODATA-1382
Add EntitySet to the list of possible target for terms ApplySupported, CustomAggregate - ODATA-1377
$all not available for rolling up named hierarchies - ODATA-1375
Clarify location of custom aggregates in $apply results - ODATA-1374
Clarify service-defined bound functions used as $apply transformations - ODATA-1373
Examples 60, 61: Missing aggregation method for $count on related entities - ODATA-1372
Clarify term "filter function" - ODATA-1369
Example 30: Wrong context - ODATA-1349
Calculate Custom Aggregates from Aggregated Instances - ODATA-1332
Support augmenting entities with aggregated values from related entities - ODATA-1307
Errors in Example 34: products with aggregated sales - ODATA-1279
Data Aggregation: Clarify need for @odata.id in nested response structures - ODATA-1256
Harmonize usage of custom aggregates with structured aggregatable properties - ODATA-1255
Correct usage of $count - ODATA-1244
Add a function to determine aggregated values within common expressions - ODATA-1225
Correct example 68 - ODATA-1218
Enhance hierarchy processing - ODATA-1215
Clarify datatype of virtual property $count - ODATA-1206
Explicitly note support for collection-valued navigation/complex properties in property paths in aggregate/groupby - ODATA-1205
Examples 53, 54, and 59 are not compliant with Data Aggregation ABNF - ODATA-1201
Improve the syntax of aggregation exceptions with "from" - ODATA-1186
Clarify names that can appear in annotation of term ApplySupported/Transformations - ODATA-1185
Extend transformation nest to multiple sequences - ODATA-1182
Clarify that transformation topcount keeps the order of the input set - ODATA-1179
Enhance orderby $apply-transformation with sorting of undefined properties - ODATA-1169
Transformation for nesting the result of another transformation within a single entity - ODATA-1167
Add way to specify which batch formats (if any) are supported by a service - ODATA-1162
Fix data type in example model - ODATA-1161
Clarify how to process hybrid results of a transformation in subsequent transformations - ODATA-1160
Clarify example 66 in section 7.5 - ODATA-1159
Clarify context URLs for aggregated result sets - ODATA-1158
Transformations for limiting the number of entities in the result of a $apply transformation - ODATA-1157
Transformation for sorting entities created by a $apply transformation - ODATA-1142
Clarify MaxDistance is an optional parameter in hierarchy filter functions - ODATA-1138
Facilitate processing of aggregated results created with concat - ODATA-1137
Clarify type information for dynamic properties in the aggregated result set - ODATA-1136
Allow hierarchy filter functions for ancestors and descendants to return true for starting node - ODATA-1073
Conformance section references wrong annotation term - ODATA-1072
Annotation to describe supported aggregation methods - ODATA-1068
3.12 Transformation expand: require at least two parameters, with innermost expansion requiring a filter() - ODATA-1041
Broaden definitions of transformations topcount and bottomcount - ODATA-1040
Clarification of term "expression" - ODATA-1038
Clarify term "simple value" - ODATA-972
Example 30: wrong result - ODATA-971
7.1: Add example for grouping by single-valued navigation property - ODATA-968
3.1.4: add example for from in aggregate() with multiple arguments - ODATA-967
Chapter 3: remove restriction for input type of bound functions - ODATA-947
Transformation for computing ratios with aggregated values - ODATA-946
Clarify scope for $apply - ODATA-945
Correct examples 53, 54, and 61 - ODATA-944
Clarify scope of property paths in transformations - ODATA-943
Correct broken link for Groupable Property - ODATA-939
Add example for groupby single-valued navigation property - ODATA-909
ABNF for pathPrefix should also allow qualifiedComplexTypeName - ODATA-905
Example 67: result row for USA, Sugar missing, Example 68: last total should be 7 - ODATA-904
Example 55: clarify groupby in combination with relationships of instance cardinality zero - ODATA-839
A recursive hierarchy annotation may also contain a navigation property to the children nodes
[{"value":"affectedVersion","displayName":"affectedVersion","auto":"true","orderable":"true","searchable":"true","operators":["~","!~","=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["was","was not","was not in","not in","changed","is not","was in","in","=","!=","is"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"category","displayName":"category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.ProjectCategory"]},{"value":"comment","displayName":"comment","searchable":"true","operators":["~","!~"],"types":["java.lang.String"]},{"value":"component","displayName":"component","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"created","displayName":"created","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"createdDate","displayName":"createdDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"creator","displayName":"creator","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Development","displayName":"Development - cf[10120]","orderable":"true","searchable":"true","cfid":"cf[10120]","operators":[">",">=","=","<","<=","in","!~","not in","is","is not"],"types":["java.lang.Number","java.lang.String"]},{"value":"due","displayName":"due","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"duedate","displayName":"duedate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"environment","displayName":"environment","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic/Theme\"","displayName":"Epic/Theme - cf[10027]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10027]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Color\"","displayName":"Epic Color - cf[10024]","orderable":"true","searchable":"true","cfid":"cf[10024]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10021]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10021]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10023]","orderable":"true","searchable":"true","cfid":"cf[10023]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10022]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10022]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"filter","displayName":"filter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":["<=","was not","was not in","not in","is not",">","~","!~","in","=",">=","was","changed","was in","<","!=","is"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"Flagged","displayName":"Flagged - cf[10026]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10026]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"id","displayName":"id","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue","displayName":"issue","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue.property","displayName":"issue.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.lang.Number","java.util.Date"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueLinkType","displayName":"issueLinkType","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.link.IssueLinkType"]},{"value":"issuetype","displayName":"issuetype","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"key","displayName":"key","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"labels","displayName":"labels","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"lastViewed","displayName":"lastViewed","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"level","displayName":"level","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.security.IssueSecurityLevel"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["<=","was not","was not in","not in","is not",">","in","=",">=","was","changed","was in","<","!=","is"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"Proposal","displayName":"Proposal - cf[10001]","orderable":"true","searchable":"true","cfid":"cf[10001]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Rank","displayName":"Rank - cf[10025]","orderable":"true","searchable":"true","cfid":"cf[10025]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["was","was not","was not in","not in","changed","is not","was in","in","=","!=","is"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["<=","was not","was not in","not in","is not",">","in","=",">=","was","changed","was in","<","!=","is"],"types":["com.atlassian.jira.issue.resolution.Resolution"]},{"value":"cf[10002]","displayName":"Resolution - cf[10002]","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"resolutiondate","displayName":"resolutiondate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"resolved","displayName":"resolved","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"searchrequest","displayName":"searchrequest","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"Sprint","displayName":"Sprint - cf[10020]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10020]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["was","was not","was not in","not in","changed","is not","was in","in","=","!=","is"],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"\"Story Points\"","displayName":"Story Points - cf[10028]","orderable":"true","searchable":"true","cfid":"cf[10028]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"summary","displayName":"summary","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"type","displayName":"type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"updated","displayName":"updated","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"updatedDate","displayName":"updatedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]}]
[{"value":"cascadeOption(\"\")","displayName":"cascadeOption(\"\")","isList":"true","types":["com.atlassian.jira.issue.customfields.option.CascadingOption"]},{"value":"closedSprints()","displayName":"closedSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"endOfDay()","displayName":"endOfDay()","types":["java.util.Date"]},{"value":"endOfMonth()","displayName":"endOfMonth()","types":["java.util.Date"]},{"value":"endOfWeek()","displayName":"endOfWeek()","types":["java.util.Date"]},{"value":"endOfYear()","displayName":"endOfYear()","types":["java.util.Date"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasPermission(\"\")","displayName":"projectsWhereUserHasPermission(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasRole(\"\")","displayName":"projectsWhereUserHasRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"standardIssueTypes()","displayName":"standardIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"startOfDay()","displayName":"startOfDay()","types":["java.util.Date"]},{"value":"startOfMonth()","displayName":"startOfMonth()","types":["java.util.Date"]},{"value":"startOfWeek()","displayName":"startOfWeek()","types":["java.util.Date"]},{"value":"startOfYear()","displayName":"startOfYear()","types":["java.util.Date"]},{"value":"subTaskIssueTypes()","displayName":"subTaskIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"unreleasedVersions()","displayName":"unreleasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"updatedBy(\"\")","displayName":"updatedBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"votedIssues()","displayName":"votedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"watchedIssues()","displayName":"watchedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]}]
["explain","select","isnull","commit","isempty","when","rowid","output","number","character","identified","sqrt","delimiter","else","exclusive","lock","catch","join","strict","greater","if","between","order","having","in","byte","double","subtract","outer","index","raw","is","then","execute","input","as","defaults","field","size","left","unique","difference","returns","begin","modulo","object","trans","minus","access","increment","sum","long","into","uid","current","default","file","goto","min","audit","by","share","where","after","power","escape","connect","noaudit","table","validate","cf","set","break","initial","max","more","column","right","trigger","union","asc","rename","decrement","equals","fetch","char","exists","notin","to","first","return","transaction","checkpoint","date","privileges","declare","before","do","integer","float","while","empty","mode","view","whenever","prior","continue","function","intersection","limit","raise","create","from","collation","alter","group","add","all","last","like","resource","count","check","less","encoding","inner","rownum","collate","null","abort","immediate","true","decimal","exec","nowait","changed","desc","option","drop","next","string","session","values","for","distinct","insert","revoke","update","delete","not","synonym","avg","public","and","of","define","alias","divide","end","row","multiply","on","or","intersect","previous","false","go","start","was","rows","any","int","modify","with","inout","boolean","grant","remainder","user"]
{"errorMessages":["jqlTooComplex"],"errors":{}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]