How to Query Function Google Spreadsheet - Data filtering based on multiple criteria (multiple columns to check at once)

How to Query Function Google Spreadsheet - Data filtering based on
multiple criteria (multiple columns to check at once)

I have a Google Spreadsheet that contains five (5) sheets, and we are
starting to use them as a basic CRM to manage tasks, projects, deadlines
and customers in a very basic fashion. We assign tasks to each other in
the first sheet "TaskRecords", and then we will populate the other sheets
with the information there. This the google spreadsheet (with mock data):
https://docs.google.com/spreadsheet/ccc?key=0AkB1z6YLt9N_dDU0VGgyZjN5cGt2UmtRb05FbWRRZ1E#gid=6
What I would like to achieve is to filter by means of a Query function or
so, to use the spreadsheet as a database and filter the following: Taks by
Team Member, by Customer, by Deadline, by Project, etc, and displaying the
on other sheets. I tried with Query formula: =QUERY(TaksRecords!A2:I17;
"select A, B, C, D, E, F, H, I where G="AL""; 1). Where I would like to
filter everything that Team Member "AL" has been assigned to do, but I'm
missing something. I also tried to pull data out to other sheets using
Arrayformula, but it only fetchs the cells I tell it to, and does no
filtering based on multiple criteria at the same time. Furthermore, there
will be new rows of data added every day.
Maybe there is some script already written that solves this, I've been
testing for several days with different options but couldn't get them to
work.
Any hints?
Thanks.