Nintex Connect

The Official Community Site for Nintex Software Products, including Nintex Workflow 2007, 2010 and 2013; Nintex Workflow for Project Server 2010; Nintex Reporting 2008 and Nintex Analytics 2010; Nintex Forms 2010; Nintex Live and Nintex SmartLibrary.
Welcome to Nintex Connect Sign in | Join | Help

Re: Question: Query list action and CAML Editor

  •  06-03-2011, 10:12 AM

    Re: Question: Query list action and CAML Editor

    Hi Carmien,

    this is what I do in situations like this.

    Firstly, the Query List action will only return one field.  That is all it is built to return.  If you needed multiple fields, you'd have to have multiple Query List actions.  So that already helps.

    Next, what I do is open the Query List action and select a list that is similar to the one I'm going to query.  If you are going to be querying another site, just for this step, go to that site, go to the list and start creating a workflow.  (you won't be publishing it or saving it).  Add a Query List action, select your list and then you'll be able to configure the filter part.

    Once you have done this, click the CAML Editor check box, and you'll see the CAML that has been built for you.  You can now copy this CAML (xml) and go back to your real workflow, open your Query List action and in the CAML Editor mode, paste in your CAML query.

    The hard work is done.  Now you just need to make some small modifications to the filter part to make sure you are filtering based on information you currently have in your workflow.  eg. you may need to insert a workflow variable or a common property.

    I hope this helps.

View Complete Thread
Powered by Community Server, by Telligent Systems