Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2440

No proper column mapping for second primary key in view model

    XMLWordPrintable

Details

    Description

      I have a source relational model where some entities I want to expose via OData REST don't have a primary key. As you know, teiid OData support will not expose a given entity via REST unless the entity has either a primary key or unique constraint defined.

      I also have a view model defined where i transform some entity names to make them more REST API resource model "friendly". This view model is also where I want to define some primary keys for entities in the source model that don't have primary keys.

      I can define a primary key set on one given entity in my view model, but when I try to define a primary key set on a second entity in the view model the columns that are available for selection are those related to the first given entity I defined a primary key for. It would seem that one should only be able to select columns that are associated with the entity you're working with.

      This occurs on teiid designer 8.3.4.Final, 8.6, teiid 8.7, on windows.

      The workaround is to edit the View Model in the Standard Eclipse XML Editor and assign column GUID's to the Primary Key XML element.

      Attachments

        Issue Links

          Activity

            People

              blafond Barry LaFond
              endy.brosens@opencirclesolutions.nl Endy Brosens (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: