Tasks - filter and group by file.linked


  • I try to filter only those tasks that have a link to another note that has the tag #project.
  • I additionally need a ‘group by’ that linked file
  • I need a ‘group by’ the inline ‘assigned’

I tried the following

	regexreplace(Tasks.text, "\[.*$","") as "Tasks",
	Tasks.due AS "Due Date",
	Tasks.priority AS "priority",
	Tasks.assigned AS "assigned to",
	file.link AS "found in:"

FLATTEN file.tasks AS Tasks
sort priority asc
group by file.linked

The filter of those linked files with tags #project, has not worked so far. Any suggestions more than welcome.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.