cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Query list for large lists

I am trying to archive the data from one list to another.  I use the query list and it returns zero record but when I put the same filters on the list, it will return records.  I am trying to figure out how to use the query list to run the workflow to move certain items in the list.  Can someone help me?

Labels: (2)
Reply
5 Replies
Highlighted
Automation Master
Automation Master

Re: Query list for large lists

can you add some screenshots as to how your query list action is configured and how your filters are configured on your list?  what are the column types you are filtering on?

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Query list for large lists

Here is the view from the workflow:

 

Here is the view:

 

Here is what the view returns:

Here is what the query list returns:

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: Query list for large lists

I would say that the query list is not recognising your input date as a date.

I would suggest using this action first - then using the date variable in your filter for the query list:

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Query list for large lists

I have tried that and still get no records

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: Query list for large lists

supply date in ISO format like YYYY-MM-DDTHH:MI:SS

see example -  

Reply