What I’m trying to do
I would like to aggregate information from three notes sharing a common UUID: company, contact, and sale notes. The goal is to create a fourth note where I aggregate and pull specific YAML properties from each note using their shared UUID.
The desired outcome is to present this aggregated information in one line within the TABLE view query, rather than as three separate lines.
Things I have tried
This is the dataview query:
TABLE
company AS Company,
first_name AS "First Name",
last_name AS "Surname",
mobile_phone AS "Cell",
e-mail_address AS "e-mail",
inv_description AS "Description",
inv_quantity AS "Quantity",
inv_unit_price AS "Unit Price",
inv_amount AS "Amount",
VAT_amount AS "VAT",
inv_total AS "Total"
WHERE uuid="4f49f32e......"
This works but displays the information from the notes on three different lines.
If I use GROUP BY then it does not display the data, just the uuid number.
Any suggestions how I can get the three notes to appear in one line instead of three?