Solved

Query List Action Won't Parse Variable Item Limit

  • 7 February 2022
  • 1 reply
  • 25 views
N
Badge +1

I am using Sharepoint/ Nintex 2013.  I have a list with 12 items.  It's named List A.  I am only interested in one column, the Daily Rate.

21756iBB93FA2357A7A0AA.png

I wish to extract a variable number of items between 1 and 12. So I am using Query List with a Collection variable called vCollItems.  Since the item limit is variable, I am using a Number type variable called itemLimit.

 

21757i41798CCA73630DA0.png

 

The Query List configuration says:  Use List A, select all records, don't filter them, extract the variable Item Limit number of records, and store the in the collection variable.

 

21758i26E5EE84D71FEB69.png

When I go to run the query I see the following:

21759iFE98983215774C26.png

 

After I run the query I get the following result:

21760iDFAD76EEBAFC90CE.png

 

If I enter an actual number in the Item Limit field, the query returns the correct results.

21761i2FBCAA6F8B084F82.png

 

Has anyone seen this behavior?  Any ideas on how to fix this?

Thanks for any help you can provide.

Pat

icon

Best answer by Rainer-Straub 8 February 2022, 16:31

View original

1 reply

R

As you defined the item limit as a variable which is empty at the time you click the execute query button, an error message is shown that the result cannot be limited as the value isn´t defined. But if you replace the empty variable string {WorkflowVariable:ItemLimit} through a valid value like a number, then it works as expected. This behaviour is just within the action to execute the query. This shouldn´t appear when you start the workflow and set the number of items to limit.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings