5 Replies Latest reply on Jul 6, 2015 10:01 AM by shawkins

    Access Path for Odata

    iginsk

      http://localhost:8080/odata/MIVDB/MIViewModel.EVI_JRNL_ART_MAP(13M)

      gives me

      <?xml version='1.0' encoding='utf-8'?><entry xmlns="http://www.w3.org/2005/Atom" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xml:base="http://localhost:8080/odata/MIVDB/"><id>http://localhost:8080/odata/MIVDB/EVI_JRNL_ART_MAP(13M)</id><title type="text"/><updated>2015-07-02T19:02:58Z</updated><author><name/></author><link rel="edit" title="EVI_JRNL_ART_MAP" href="EVI_JRNL_ART_MAP(13M)"/><link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EVI_JOURNAL_MASTER" type="application/atom+xml;type=entry" title="EVI_JOURNAL_MASTER" href="EVI_JRNL_ART_MAP(13M)/EVI_JOURNAL_MASTER"/><link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EVI_PIT_MASTER" type="application/atom+xml;type=entry" title="EVI_PIT_MASTER" href="EVI_JRNL_ART_MAP(13M)/EVI_PIT_MASTER"/><link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EVI_SUBMISSION" type="application/atom+xml;type=entry" title="EVI_SUBMISSION" href="EVI_JRNL_ART_MAP(13M)/EVI_SUBMISSION"/><link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EVI_SUBMISSION_REV" type="application/atom+xml;type=entry" title="EVI_SUBMISSION_REV" href="EVI_JRNL_ART_MAP(13M)/EVI_SUBMISSION_REV"/><category term="MIViewModel.EVI_JRNL_ART_MAP" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/><content type="application/xml"><m:properties><d:JRNL_ARTICLE_ID m:type="Edm.Decimal">13</d:JRNL_ARTICLE_ID><d:JRNL_ID m:type="Edm.Decimal">4</d:JRNL_ID><d:JRNL_ARTICLE_NAME>Full Length Article</d:JRNL_ARTICLE_NAME><d:PIT_ID m:type="Edm.Decimal">9</d:PIT_ID><d:CREATED_BY m:null="true"/><d:UPDATED_BY m:null="true"/><d:DOC_HEAD>Full Length Article</d:DOC_HEAD><d:RANK m:type="Edm.Decimal" m:null="true"/><d:CREATION_DATE m:type="Edm.DateTime" m:null="true"/><d:UPDATED_DATE m:type="Edm.DateTime" m:null="true"/><d:IS_ONLY_FOR_SPCL_CONTENT>N</d:IS_ONLY_FOR_SPCL_CONTENT></m:properties></content></entry>

      if I try to data related to EVI_SUBMISSION based on EVI_JRNL_ART_MAP(13M), like http://localhost:8080/odata/MIVDB/MIViewModel.EVI_JRNL_ART_MAP(13M)/MIViewModel.EVI_SUBMISSION, it is complaining

       

      <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

       

      <code>NotFoundException</code>

       

       

      <message lang="en-US">

       

      TEIID16003 Association is not found between entity EVI_SUBMISSION and EVI_JRNL_ART_MAP

      </message>

      </error>

      See the association in the attachment...


      I think i am missing how do I access inner objects...

      Any help please..