Sorting has no effect on the order
Hi, i'm trying to process data in small batches and i have a hidden field called "
RecalcPending" that by default contains the value
TRUE. After the script processes one line it sets the value to
FALSE
. And setting the sort condition to Asc or Desc has no effect and the 130 or so lines of data never get processed by this script. I can see them in the view but so they have to be stored somewhere and the sort condition is not doing what it should do.
Here is the for each line where the sorting is with Desc condition
- for each data in Data [((Decision != "Yes" && Decision != "No") && Status == "Request for approval")] sort by RecalcPending desc range from 0 to 50
Here is the for each line where the sorting is without Desc condition
- for each data in Data [((Decision != "Yes" && Decision != "No") && Status == "Request for approval")] sort by RecalcPending range from 0 to 50