Every week I need to produce a weekly report of active projects and completed work. Currently this is quite a messy process of triggering a particular perspective, reviewing what's in there, load a 'print-friendly' theme, saving to a file and then repeating for the completed actions. I'd like to be able to make this scriptable so that running a script creates a text/ markdown file as per the template below.
* Active Projects
* Get a list of active folders (excluding those that aren't relevant such as Personal & Someday/ Maybe)
* For each folder get a list of active projects (excluding SALs)
* If a sub folder is found, list the active projects within it
* Completed
* Query for any completed projects within the relevant folders. If any are found list them.
* Query for completed actions and list ordered by completed date
* Collect all produced above and create an .md file
Does this sound doable and, in addition to Rob Trew's great OF-AQL script, is there anything obvious that may be worth me looking at to get this kind of functionality.
---
##ACTIVE PROJECTS
###Folder 1
Project 1
Project 2
Project 3
###Folder 2
Project 4
Project 5
###Folder 3
Project 6
Project 7
####Sub Folder 3.1
Project 8
Project 9
####Sub Folder 3.2
Project 10
###Folder 4
Project 11
##COMPLETED FROM 7 DAYS
###Projects
####Folder 1
Project 12
####Folder 2
Project 13
###Actions
task name 1, project 8, completed date
task name 2, project 7, completed date
task name 3, project 7, completed date