{{fscript dueDate := NSDate date. arrayOfOpps := {}. incompleteTasks := objectContext objectsForEntityNamed:'Task' qualifierLocum:'(statusCode < 7)' bindings:nil. opsForTask := incompleteTasks opportunities. globals setFetchedOpportunities:(opsForTask flattenArrayOfArrays) distinct. globals setIncompTasks:incompleteTasks. }}
{{localize 'Task Name'}} | {{localize 'Due Date'}} | {{localize 'Status'}} | {{localize 'Owner'}} | {{fscript globals setIncompTasksForOpp:nil. incomptasksForOpportunity := {}. allTasksForOpportunity := opportunity tasks. allTasksForOpportunity do:[:task | (task statusCode < 7) ifTrue: [ incomptasksForOpportunity addObject:task. ]. ]. incomptasksForOpportunity := incomptasksForOpportunity sortedArrayUsingDescriptors:{(NSSortDescriptor sortDescriptorWithKey:'dueDate' ascending:true)}. globals setIncompTasksForOpp:incomptasksForOpportunity. }} {{foreach task incompTasksForOpp do}}
{{task.name}} | {{fscript (task dueDate) mcShortDate.}} | {{fscript (task statusString).}} | {{fscript task assignedTo contact derivedFullname.}} |