We have department master folder called Criminal Cases that has a master folder for each active case.  Those master folders have a template.  Folder name is based on the template information populated by staff through a workflow.

Then inside of each of those master folders are two subfolders called OPEN and REST and they have the same template as the master but the default values for some fields is %parent so staff can just drag and drop docs in there without having to do data entry).  Again all designed through workflow.

We have created a SQL statement that in test updates the master folder name and metadata based on new information from the state's new schema.  Works like a charm at the master level.  Now I want to take the template information on the master to update my subfolders.

I have tried retrieve field value... I have tried find entry .... I have tried for each entry.  What is the most efficient way of stepping through all 18000 case files?  I don't want to search... just want to step through each folder until I get to the end.  I would even add another field that can be populated if need be once the rename is done.  So the wf would say if x-field <>.