Report Query XSLT

Offline hkhan over 1 year ago

Im Trying to do a whereuse on Doc V1 table to get data from a relationship called Req V1 Doc v1 which is linked to another item called Req V1 and then Req V1 is linked to another item via relationship to Verification Record is my script below looks good for report query?

<Item type="Document V1" id="{@id}" action="get" select="id">
<Relationships>

<Item type="Req V1 Doc v1" action="get" select="source_id">
<source_id>
<Item type="Req V1" action="get" select="state,id">

<Relationships>

<Item type="Req V1 Verification Record" action="get" select="related_id">
<related_id>
<Item type="Verification Record" action="get" select="id,state">
</Item>
</related_id>
</Item>

</Relationships>

</Item>
</source_id>
</Item>



</Relationships>
</Item>

Parents

0 Offline alaxala over 1 year ago

If I understood your data structure from this query correctly the first "select='source_id'" and "<source_id> should be replaced with "related_id" as in the inner "Relationships" tag.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Offline alaxala over 1 year ago

If I understood your data structure from this query correctly the first "select='source_id'" and "<source_id> should be replaced with "related_id" as in the inner "Relationships" tag.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Offline hkhan over 1 year ago in reply to alaxala

Thank for the reply the following is the data structure and i want to run the query from doc v1 as can be seen below. the relationship is from req v1
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 Offline alaxala over 1 year ago in reply to hkhan

Try this:

<Item type='Req V1' action='get' select='id'>
  <Relationships>
    <Item action='get' type='Req V1 Doc v1' select='related_id(id)'>
      <related_id>{@id}</related_id>
    </Item>
    <Item action='get' type='Req V1 Verification Record' select='related_id(id,state)'></Item>
  </Relationships>
</Item>