I have a few CQWP's in SP2010 Enterprise that I ma using to display tasks from task lists in the same site collection. At the moment they are simply filtered on 'Assigned to [me]' and they are working fine. Only issue is that the query will display all completed tasks too and I want all but completed! I have tried adding another filter that looks at the status field for if the task item is completed. The query looks like this: Assigned to Equals [Me] AND Status is not equal to [Completed]. Problem is the CQWP now displays nothing unless I remove that second filter! What am I doing wrong?? Thanks
This below CAML works fine...
However I cannot replace 'my name' with the [Me] value so its works for all users! Also I have created a new CQWP and used only one filter of Status is not equal to Completed and this still does not work even though there are tasks set to In Progress and Not started!