Skip to main content
N
nborrerojr.1-Visitor
1-Visitor
August 30, 2016
Solved

relationshipgroupby in report recipe

  • August 30, 2016
  • 1 reply
  • 2060 views

I have the following in a report recipe:

<!-- Walk doc -->
<%beginrelationshipsdetail Query[(walkdocordered[<%<%builtin ID%>%>])]%>

<!-- Walk relationship to find STO -->
<%beginrelationshipsdetailL2 Verified By%><%filter%>(field[Category] = "MOP Eval Criteria")<%endfilter%>

  <%beginrelationshipsdetailL3 Query[(walk[<%builtin Contained By%>]<%RelationshipL2 <%builtin ID%>%>)]%><%filter%>(field[Category] = "STO")<%endfilter%>
 
   <%relationshipgroupby <%RelationshipL3 ID%>%>
  
    <tr>
     <td> </td>
    </tr>
  
   <%endrelationshipgroup%>
 
  <%endrelationshipsdetailL3%>
<%endrelationshipsdetailL2%>
<%endrelationshipsdetail%>

The relationshipgroupby never seems to do anything. It's not even processed when I run the report. The tags still stay as-is in the output html. I want to group the items returned in the L3 query. How do I make this work?

    Best answer by dthierjung

    Hi Nolin Borrero Jr.,

    Since you are in Level 3 i think you need to set the correct Level. Also, you can't use <%RelationshipL3 ID%> in that context. You group by field(name) and what you are doing is inserting a specific id.

    You can either do it as below (select the group by field in the Report Wizard) or set the Fieldname directly.

    <%relationshipgroupbyL3 &groupby%>

              ......

    <%endrelationshipgroupL3%>

    Regards,

    Dominik

    1 reply

    D
    dthierjung1-VisitorAnswer
    1-Visitor
    August 31, 2016

    Hi Nolin Borrero Jr.,

    Since you are in Level 3 i think you need to set the correct Level. Also, you can't use <%RelationshipL3 ID%> in that context. You group by field(name) and what you are doing is inserting a specific id.

    You can either do it as below (select the group by field in the Report Wizard) or set the Fieldname directly.

    <%relationshipgroupbyL3 &groupby%>

              ......

    <%endrelationshipgroupL3%>

    Regards,

    Dominik

    N
    nborrerojr.1-VisitorAuthor
    1-Visitor
    August 31, 2016

    When I do that, it does seem to process it but the report is blank. Any idea what that might indicate?

    Terms & ConditionsAccessibility statement