Nintex Connect

I have a Nintex workflow that contains a Query List action against a list in SP2010 containing approximately 2700 items.  I have no filters on the query and my objective is to capture all the IDs of the items in the list in a Collection variable.  Very simple stuff but for some reason I'm only getting about 400 IDs of the most recent items.  It is like there is some limit or threshold on how many values the collection variable can hold or the size of the list I can query.  When I run the very same query against a smaller list, about 100 items, I get all the IDs.  Any idea why it's not working? 

Hi David K,

what build of NW are you on?  You may need to upgraded to the latest as I think I've encountered this before and it's something the devs have looked into.

We are using NW 2010 (2.3.1.0).  I've been told there is a 2.3.4.0 release but we haven't installed or tested this release.  Do you know if there is documentation with a later release that documents and addresses this issue?

Hi David,

I'm not seeing anything that has been fixed specifically in later builds.

I did see in the build just before the one you have, there was an extra option put in to allow you to specify an item limit.

Can you please try putting a large number in there and see if you get the the number of items you expect?

Entered 5000 in the Specify an Item Limit. It had no impact on the result. 

I modified my filter in the Query Item action on other properties and values and compared results with a View that i created on the same list using the same filters so I would know what the Query Item result should return.  When the filter returned a small set the Query Item action gave correct results.  When the filter in the View began to return result over 500, the Query Item action results using the same filter began truncating and only returning approximately 400 IDs (the exact number would vary).  Any other thoughts?  I'm a Owner of the Site so permissions on any items shouldn't be a factor.

Hi David K,

can you please email Nintex Support?

Hi David,

scratch that.  I have just found a note that stated that this was an issue prior to build 2.3.2.

You are currently on 2.3.1, so you are encountering this issue.

I'd recommend upgrading to the latest build and that should fix it.

We upgraded to the latest release and it resolved the problem.  Thank you.

Hi David K,

awesome.  Thanks for letting us know.

I am encountering the same issue in NW 2007, build 11200(?).  Is there an update for 2007 that fixes this?

Vadim, I don't know if you will see new replies to old threads, but I have something to add.  I created a test workflow that limits its query to 300 or fewer items on each iteration.  It filters so that 1 <= ID < 301, tne next time, 301 <= ID < 601, etc.  I had hoped that this would be a workaround, but it retrieved only 911 of the 3000+ items, same as it did when I queried the list for all items:

Workflow is finished.  Items in collection at each iteration:

259
------------------
300
------------------
300
------------------
52
------------------
0
------------------
0
------------------
0
------------------

 

 

You indicated that this is fixed in a newer build of WF 2010, but is there a fix in WF 2007?

 

Hi ledlincoln,

off the top of my head, I'm not sure if it's resolved in NW2007.

I'd recommend you email Nintex Support and we can take a closer look.