Skip to main content
Nintex Community Menu Bar

Query list for large lists

  • Dec 19, 2017 3:19 PM UTC
  • 5 replies
  • 55 views
  • Translate All

Forum|alt.badge.img+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

Forum|alt.badge.img+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?

Translate

Forum|alt.badge.img+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:

Translate

Forum|alt.badge.img+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:

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

Translate

Forum|alt.badge.img+1

I have tried that and still get no records

Translate

Forum|alt.badge.img+14
  • Scholar
  • Dec 20, 2017 10:03 PM UTC

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

see example -  

Translate