Issue in viewing data | Community
Skip to main content
maheswarik23685
maheswarik23685
New Participant
October 23, 2018
Solved

Issue in viewing data

  • October 23, 2018
  • 12 replies
  • 10667 views

Hi All,

I have created a 1:n link  between two tables recipient and contract. When we do a query choosing recipient as targeting dimension and contract as filtering dimension it gives me 0 results but data corresponding to recipient id are present in contract table.

Below is the code which I have added in contract table for creating one to many link between recipient and contract

<element label="Recipients" name="recipient" revLink="contract" target="nms:recipient"

             type="link">

      <join xpath-dst="@gid" xpath-src="@gid"/>

  </element>

Kindly let me know if the linking is done correctly

Thanks,

Maheswari

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by DebTr

    Hi maheswarik23685204​,

    Seems you are on track. As per your comment, in Data tab you can see 32 records satisfying the criteria mentioned in your changed link(ABX Recipients) between Recipient and Contract schema.

    Please have a look if you are selecting the correct link in your query Or you can try  generic query editor output.

    Regards,

    Deb

    12 replies

    Show previous replies
    maheswarik23685
    maheswarik23685Author
    New Participant
    October 24, 2018

    Hi Deb.

    1.Both the schema are having attribute "gid"

    2. I am not sure how to verify relationship but more than one record available for same gid in contract schema and only one record available for that gid in recipient schema

    3.When I choose gid from recipient link through configure list of contract schema  I couldn't see any data in contract schema data tab.It gives me 0. Similarly when I choose gid from contract link of recipient schema it shows all recipient data but the value of gid is 0 for all records  in recipient data tab

    Could you please let me know what might be the issue

    Thanks,

    Maheswari

    D
    DebTr
    New Participant
    October 24, 2018

    Hi Maheswari,

    Please try to check the following.

    1. Both the schemas are having attribute "gid".
    2. Data available in both the schemas satisfying the relationship.
    3. Instead of query activity try to check how Recipient data is getting populated in "Data" tab of "Contract" schema.

    Regards,

    Deb

      Terms & ConditionsAccessibility statement

      Loading footer...