Nested bullets from multiple queries

[rapatel0]

Hey guys I'm trying to denormalize a table and was wondering if dataview can render nested bullets. Here is' the full description

Here's what I have thus far. Data is pulled from lists in notes and then rendered as a table.

let summaryList = pages.file.lists
    .where(z=> z.text.includes('Summary'))
    .children.map(z=> (['Summary',myFunction(z.link), z.text]))

let importantNoteList  = pages.file.lists
    .where(z=> z.text.includes('Important notes'))
    .children.map(z=> (["Important", myFunction(z.link), z.text]))

let actionsList = pages.file.lists
    .where(z=> z.text.includes('Actions'))
    .children.map(z=> (['Actions', myFunction(z.link), z.text]))


dv.header(5, 'Overview')
dv.table( ['Note', 'Meeting', 'Text'] , summaryList.concat(importantNoteList).concat(actionsList))

Rendering

This renders as a table:

Note	meeting	Text
summary	Meeting1	some description1
summary	Meeting2	some description2
summary	Meeting3	some description3
Important	Meeting1	some important1
Important	Meeting2	some important2
Important	Meeting3	some important3
Actions	Meeting1	some Actions1
Actions	Meeting2	some Actions2
Actions	Meeting3	some Actions3

Target - This is what I'm trying to achieve.

• summary
  • some description1 meeting1
  • some description2 meeting2
  • some description3 meeting3
• Important
  • some important1
  • some important2
  • some important3
• Actions
  • some Actions1
  • some Actions1
  • some Actions1

I've tried multiple ways to get this to render but I can't figure out how to have nested bullets. I usually just get double bullets on each line.

• summary
• • some description1 meeting1
• • some description2 meeting2
• • some description3 meeting3

Any ideas?

[AnnaKornfeldSimpson]

dv.taskList(items, false) is probably what you want for displaying nested lists, even of not tasks.
This is not the nicest code, but it adapts part of yours to get a properly nested "summary" list:

const summaryList = pages.file.lists.where(i => i.text.includes("summary"));
summaryList.forEach(i => i.children.forEach(z=> z.text = z.text + " " + myFunction(z.link)));
dv.taskList(summaryList, false);

I think you can probably just make 3 different dv.taskList(items, false) in the same codeblock. Hopefully this gives you a starting point!

[rapatel0]

I'll try this to see if I can get it to work and post back if I get something working

[rapatel0]

Had some minor issues with consolidation across notes. Made some slight tweaks and put a convenience function around it and some formatting if empty

Here's the code I ended up using. Still hacky but functional.

let pages = dv.pages(folder).where(b => String(b.tags).includes('Meeting'))

function myFunction(sectionLink) {  
    sectionLink.type = null
    sectionLink.subPath = null 
    return sectionLink

}
function queryList(pageQuery, listQueryString){
    const summaryList = pageQuery.file.lists.where(i => i.text.includes(listQueryString)).where(i => i.children.some(z=> z.text));
    summaryList.forEach(i => i.children.forEach(z=> z.text = z.text + " " + myFunction(z.link)));
    let summaryConsolidated = [{text: "**" + listQueryString + "**" , children: summaryList.children}]
    dv.taskList(summaryConsolidated, false);
}

queryList(pages, "Summary of topics discussed")
queryList(pages, 'Important notes')
queryList(pages, 'Actions')

Here's a preview of the output (redacted for privacy)

edit: typo/error in copy paste. Now fixed