Forum Discussion
Filter Old Draft Folders
The grouping is currently set at the Draft folder level, which is why you’re seeing one file per Draft instead of one per PR folder.
You should group at the PR-26*** level so all Draft folders are considered together. Then, use the maximum modified date within each group and filter to that row. This will give you only the most recent file across all Draft folders for each PR.
If you still get multiple rows, sort within each group and keep just the top row to ensure a single result.
Please try this approach and let us know how it works for you.
I used the custom column that I described above and I'm still having the same issue. It's not getting rid of the "draft" folders that have older files in them. It's giving me the latest file that is in every "draft" folder.
Here is a screenshot of the folder structure when there are multiple draft folders.
I want the final result to show the most recent file path out of the "draft" folders. If draft 4 has the most recent file, show only that file path. If draft 02 has the most recent file show only the draft 02 file path.
The current result I am getting is the file path for the most recent file in ALL of the draft folders.
JPorterValmetal wrote:I want the final result to show the most recent file path out of the "draft" folders. If draft 4 has the most recent file, show only that file path. If draft 02 has the most recent file show only the draft 02 file path.
Dann verwende den oberen Beispielcode. Und wie ich schon sagte:
... solltest Du aus der Quelle in der Spalte Folder Path noch alle unerwünschten Ordner herausfiltern.