]
Steven Hawkins updated TEIID-5873:
----------------------------------
Fix Version/s: 14.1
(was: 14.0)
Since there appears to be a workaround, moving out of 14.0
OData mapping issue with mongodb
---------------------------------
Key: TEIID-5873
URL:
https://issues.redhat.com/browse/TEIID-5873
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors, OData
Affects Versions: 13.0.1
Reporter: Chee Kin Lim
Assignee: Steven Hawkins
Priority: Major
Fix For: 14.1
Given the following document in MongoDB matrix_variable collection:
{
"_id" : ObjectId("5b2367c9c9e77c0007ca0111"),
"createdOn" : ISODate("2018-06-15T07:16:25.459Z"),
"modifiedOn" : ISODate("2018-07-02T02:04:16.661Z"),
"variableId" : "183cf101d2334ac09bd0db9aee96081f",
"name" : "lfzq_test",
"description" : "",
"lastModifiedUserEmail" : "admin1(a)abc.com",
"headerRow" : {
"rowId" : "0b002942a5b4424f98fcc270af0290c3",
"values" : [
"name",
"value"
],
"isEncrypted" : [
false,
true
]
},
"rows" : [
{
"rowId" : "940467f9bb724d1688086baeec05049b",
"values" : [
"lfzq123q",
"751c634ca5e24102a00800b386955a5c"
]
}
],
"deleted" : false
}
The "headerRow" property is exposed as separate entity type in OData schema,
but not "rows" property.
I found the following entity types with odata/$metadata:
<EntityType Name="headerRow">...</EntityType>
<EntityType Name="matrix_variable">...</EntityType>
Github repo to showcase the issue:
https://github.com/limcheekin/teiid-spring-boot-mongodb-odata
Related StackOverflow post:
https://stackoverflow.com/a/59385181/303211