Query list for large lists

  • 19 December 2017
  • 5 replies
  • 15 views
F
Badge +1

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?

5 replies

C
Badge +16

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?

F
Badge +1

Here is the view from the workflow:

 

Here is the view:

 

Here is what the view returns:

Here is what the query list returns:

C
Badge +16

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:

‌‌‌‌‌‌‌‌‌‌‌‌‌

F
Badge +1

I have tried that and still get no records

E
Userlevel 5
Badge +14

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

see example -  

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings