Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5873

OData mapping issue with mongodb

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Unresolved
    • Major
    • Backlog
    • 13.0.1
    • Misc. Connectors, OData
    • None
    • 2

    Description

      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@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

      Attachments

        Activity

          People

            Unassigned Unassigned
            limcheekin@vobject.com Chee Kin Lim (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 1 day, 7 hours
                1d 7h
                Remaining:
                Time Spent - 3 hours, 30 minutes Remaining Estimate - 1 day, 3 hours, 30 minutes
                1d 3h 30m
                Logged:
                Time Spent - 3 hours, 30 minutes Remaining Estimate - 1 day, 3 hours, 30 minutes
                3h 30m