Nintex Connect

I am trying to read items stored in folders at multiple levels within a Document Library. I am using the CAML version of the Query List function using the following, but no data is being returned.  I have seen some other discussions on this subject in the forum, and tried various alternatives such as using 'RecursiveAll' for the scope, but there doesn't seem to be anything that works for me.  Have you any ideas?

 <Query>
    <Lists>
        <List ID="{C8C3F2F7-D243-4C91-9C38-1212AFD471D5}" />
    </Lists>
    <ViewFields>
        <FieldRef Name="ID" />
    </ViewFields>
    <Where>
        <Eq>
            <FieldRef Name="Contact_x0020_ID" />
            <Value Type="Text">{WorkflowVariable:ContactFromIDText}</Value>
        </Eq>
    </Where>
    <QueryOptions>
       
        <ViewAttributes Scope="Recursive" />
    </QueryOptions>
</Query>

Hi,

Try the following CAML without QueryOptions.

<Query>
    <Lists>
        <List ID="{C8C3F2F7-D243-4C91-9C38-1212AFD471D5}" />
    </Lists>
    <ViewFields>
        <FieldRef Name="ID" />
    </ViewFields>
    <Where>
        <Eq>
            <FieldRef Name="Contact_x0020_ID" />
            <Value Type="Text">{WorkflowVariable:ContactFromIDText}</Value>
        </Eq>
    </Where>
    <ViewAttributes Scope="Recursive" />
</Query>

Hello Peter,

I have tried your solution, this is my query:
<Query>
    <Lists>
        <List ID="{D069C0D4-09D8-4A93-9D80-0BC03378CD18}" />
    </Lists>
    <ViewFields>
        <FieldRef Name="ID" />
    </ViewFields>
    <Where>
       <And>
            <And>
                <Eq>
                    <FieldRef Name="ContentType" />
                    <Value Type="Text">test</Value>
                </Eq>
                <Eq>
                    <FieldRef Name="Start_x0020_Review_x0020_workflow_x0020_now" />
                    <Value Type="Boolean">No</Value>
                </Eq>
            </And>
            <Leq>
                <FieldRef Name="Review_x0020_Date" />
                <Value Type="DateTime">{WorkflowVariable:DateString}</Value>
            </Leq>
        </And>
    </Where>
    <ViewAttributes Scope="Recursive" />
</Query>

But it seems that after adding the ViewAttributes, it completely ignores the Where clause and returns all documents.

Any ideas?

Hi,

Can you please let us know which version of Nintex Workflow you are using, we found an issue where recursive was causing the Where clause to be ignored. This has been fixed in the latest builds.

There are two ways to determine which version and build of Nintex Workflow 2007 you have installed.

The first is to navigate to any list or library in a site that has Nintex Workflow 2007 activated.  Then load the Workflow Designer by choosing to create a new workflow or by editing an existing workflow.  Open the configuration dialog for any workflow action and a build number will appear at the bottom left in grey text. The number is comprised of 5 digits in the format “1XXXX”.

The other way to determine your version number is from within SharePoint Central Administration.  In Central Admin, click the “Application Management” tab, then scroll to the Nintex Workflow section and click the Licensing link.  The build number should be visible at the bottom of the licensing information that is displayed.

Hi Peter,

The version number appears to be 10905

Regards,
Klaas

Hi,

I have emailed you a link to the latest version and update instructions via support@nintex.com.