CAML Query to pull list items only if their approved?

Question

Although the solution seems relatively strightforward it doesnt seem to work.

Here is my CAML query to pull all items from a list that have been approved through the OOTB Sharepoint Approval Workflow.

I have named the workflow "Approval", but when I build the queries in U2UCAML Query Builder or CAML Designer they seem to display "Announce" in place of "Approval"....weird. I tried replacing it with Approval and executing it but it dint fly.

Please advise.

<Query>
<Where>
  <Eq>
     <FieldRef Name='Announce' />
     <Value Type='WorkflowStatus'>Approved</Value>
  </Eq>
</Where>
</Query>

Answer 1

Instead of using U2U CAML Query Builder in a lot of cases it's easier to build the query by creating a view using the SharePoint UI. When you get the view right the use SharePoint Manager to look at the Query of the View.

In case of the status of the Approval workflow it may be a little complicated as what you want to check for isn't the text Appoved, but the status value of 16

So you query ends up something like:

<Where>
  <Eq>
    <FieldRef Name="Approval" />
    <Value Type="WorkflowStatus">16</Value>
  </Eq>
</Where>