Display related table data

[angieherrera]

Description

This isn't really a feature request so much as a support request while I try out Data Studio.

This may be more of an issue of not fully grokking some more advanced concepts in Twig templating, but I'm unclear on how I can display related data for a particular element/object.

In my particular use case, I want to generate a report that shows a list of users and the data from a table in their "profile". The table is just a simple Table field in Craft and it can have any number of rows.

My hope is that the resulting report would show the table column as a list of the related table data, either separated by a comma or line break.

Here's a screenshot of example data that I pulled using Twig how I would normally use it in a front-end template. The "tasks" column is a list of key value pairs (task and status).

Example

No response

[BenParizek]

@angieherrera This is possible. Here's a very simple hard-coded example using the Twig Template Query report results template. You can, of course, loop through a set of users and call addRow for each, but I'm trying to focus on the how to control the output part of your question here.

To display line breaks, you'll need to consider TWO contexts. One is the HTML rendering of your report in the CP and the other is the CSV export of your report if a content admin were to download the report. You can use <br> tags to add the line breaks in the HTML report but you'll want to use \r\n for line breaks in the csv export.

{# Creates a `lineBreak` variable that can be used for HTML and CSV Export output #}
{% set lineBreak = isExport ? '\r\n' : '<br>' %}

{# Sets heading column names #}
{% do sprout.twigDataSet.addHeaderRow([
    "Client",
    "Tasks"
]) %}

{# Add a row #}
{% do sprout.twigDataSet.addRow([
    "Client Tier 1",
    "Line 1"~ lineBreak ~ "Line 2"
]) %}

[BenParizek]

Also, I've just moved this discussion over to our core Sprout repo discussion board. We're trying to route Q&A like this here and will see how it goes!