cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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
Workflow Hero

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
Accept as Solution Reply
Workflow Hero

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
Accept as Solution Reply
Workflow Hero

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
Accept as Solution Reply
Workflow Hero

Re: Query list for large lists

I have tried that and still get no records

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Query list for large lists

supply date in ISO format like YYYY-MM-DDTHH:MISmiley FrustratedS

see example -  

Accept as Solution Reply