Report Query XSLT

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 Reply
  • 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>

Children
No Data