Is there a way to combine the second and third post?
To get something like this
[SINGLE-ACTIONS LIST]
[SINGLE-ACTIONS LIST]: Action 1 (06/25/2011)(!!)
[SINGLE-ACTIONS LIST]: Action 2 (!!)
[Daily Projects]
[Daily Projects]: Action 1 (06/23/2011)
[Daily Projects]: Action 1 (06/23/2011)(!!)
[Daily Projects]: Action 2 (06/23/2011)(!!)
Most of the time I would probably just select the project but some actions I could probably spend the entire 25 minutes on one action in a project. The due date and flag is a very nice touch as well.
I spent a while trying to do this myself but post 3 boggles me in the voodoo it is doing.
Especially this part
Code:
set lstLines to paragraphs of (do shell script "sqlite3 -separator " & quoted form of pDelim & space & pstrDBPath & space & quoted form of ¬
"SELECT proj.name, tsk.name, tsk.effectiveFlagged, strftime('%m/%d/%Y', tsk.effectivedateDue + strftime('%s','2001-01-01'), 'unixepoch')\n\t\tFROM (task t left join projectinfo p on t.containingprojectinfo=p.pk) tsk join task proj on proj.projectinfo=tsk.pk\n\t\tWHERE (folderEffectiveActive is null or folderEffectiveActive = 1) and (status is null or status = \"active\") \n\t\t\tand tsk.dateCompleted is null and tsk.blocked=0 and (tsk.isDueSoon=1 or tsk.effectiveFlagged=1)\n\t\tORDER BY tsk.effectiveFlagged DESC, tsk.effectivedateDue, proj.name")