[teiid-issues] [JBoss JIRA] (TEIID-5873) OData mapping issue with mongodb

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-5873:
----------------------------------
    Fix Version/s: Backlog


>  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: Backlog
>
>   Original Estimate: 1 day, 7 hours
>          Time Spent: 3 hours, 30 minutes
>  Remaining Estimate: 1 day, 3 hours, 30 minutes
>
> 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 at 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



--
This message was sent by Atlassian Jira
(v7.13.8#713008)