Tracing nested references with ServiceRocket Reporting plugin

Mike Pearson

I've got 3 ServiceRocket Scaffolding templates that form a hierarchy of references (using list-data fields):

1. Customer
2. Order (contains a list-data field, data:Customer, referencing pages made with the Customer template)
3. Shipment (contains a list-data field, data:Order,  referencing pages made with the Orders template)

My challenge now is: given a Customer, how can I report on all the shipments associated with the customer?

I thought I could just use a supplier keychain as follows:

{local reporter:page:children|source=Shipments}

{text-filter:data:Order > data:Customer|include=MyCustomerName}

{local reporter}

But this doesn't seem to work.

Can anyone kindly advise how I might get this to work?

Mike Pearson

I think I've managed to get it working by nesting reporters:

{report-block}

{local-reporter:page:children|source=Orders}
{text-filter:data:Customer|include=MyCustomerName}
{local-reporter}

{report-body:injected=true}
{report-list:injected=true}
{local-reporter:page:children|source=Shipments}
{text-filter:data:Order|include=%page:title%}
{local-reporter}
{report-body}
{report-info:page:title}
{report-body}
{report-list}
{report-body}

{report-block}

 

NOTE: I'm posting here with the wiki-markup version for illustrative purposes.  In practice, I'm using the plugin UI, and have not actually tested the wiki version.  Consider the above pseudo-code to demonstrate the setup - you will have to translate into the plugin's UI or XML.