"Features" referenced in meeting notes

Questions & Help Queries
1

Hey folks!

Found LogSeq recently and absolutely loving it for both managing my work and personal life. Todays venture brings me here regarding the work side where I am using LogSeq as a daily journal where I document all my interactions, tasks, etc.

Below is a example note of what I might take with a customer from my Journal page.

## Meetings
- Customer call with [[Acme Corp]] regarding #Automations #meeting
   - **Participants**: Josh, George, Amy
   - **Topics**: 
       - A
       - B
       - C
   - **Blockers**: 
   - **Decisions**: 
   - **Action Items**: 
   - **Notes**: 
       - Customer uses #SFTP for external partners
       - Has #AzureFiles with #SharePoint

In the above example, the page references for #SFTP, #AzureFiles, and #SharePoint all have a custom property of type: feature.

Along with this, I have a page for each Customer, [[Acme Corp]] and I would love to have a query where I can see all “features” that have been referenced in past meetings with that customer.

Does this make sense?

Essentially, on the [[Acme Corp]] page I would like to have a query that returns #SFTP, #AzureFiles and #SharePoint (in this example). Bonus if I can show a count or heatmap of sorts with frequency mentions of these “tags” in the notes for that customer.

TYIA!

2

Welcome. Something like this:

#+BEGIN_QUERY
{:query [:find ?name
   :in $ ?current-name %
   :where
     [?current :block/name ?current-name]
     [?meeting :block/name "meeting"]
     [?root :block/refs ?current]
     [?root :block/refs ?meeting]
     (ancestor ?root ?b)
     [?b :block/refs ?ref]
     [?ref :block/properties ?props]
     [(get ?props :type) ?type]
     [(= ?type "feature")]
     [?ref :block/original-name ?name]
 ]
 :inputs [:current-page
   [
     [
       [ancestor ?a ?b]
       [?b :block/parent ?a]
     ]
     [
       [ancestor ?a ?b]
       [?parent :block/parent ?a]
       (ancestor ?parent ?b)
     ]
   ]
 ]
}
#+END_QUERY
3

Thanks!

I tried to use it as is and get “No Matched Results” but, I’v also only been working with simple queries so I am going to watch a few videos and read more on these to try and better understand what and how its working before I come back. Gonna be out the next few days, so might be next week though. Thanks again!

4

Interestingly enough, after opening the .md file in a text editor, it caused a reload and now works great. :joy:

Thanks! :vulcan_salute:

1 Like