CiviCRM Sprint Berlin Day 2

Greenpeace staff presented the new version of the SQL Task Manager and it is amazing stuff - every nerds dream ^^ We hope for a bit more detailed documentation soon but here's a teaser:

• Flexible multi actions: use more than one one action within a task e.g. two api calls
• Add & rearrange actions in SQL-task edit UI
• Global token: define token in a config UI to use in your SQL-tasks e.g. to avoid including a password in an SQL-task
• Templates for SQL Tasks ans Actions: Avoid copy & paste when creating new tasks by using templates for tasks & actions
• Input parameter support: Provide any input parameter when using an SQL Task that can be used within the task (e.g. in the SQL query)
• CiviRules integration: Calls an SQL task from CiviRules and use the parameters provided by CiviRules within your task
• Use the API for everything: Use the API to manage, create, run etc. your SQL Tasks or parts thereof. One use case is that extensions automatically create and use SQL tasks - woopwoop!
• Use your task's action results for other actions of the same tasks. For example if you want action 1 of your task to create an activity, action 2 another activity and your task is supposed to link those two.
• Improved error handling: Tasks will by default no longer process actions after there has been an error but utilize the error handling routine and cleanup script instead. Also there are now more options for error handling.