[Finlay Boo]

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