What does this PR do

Before this PR, the from/size pagination parameters were applied before filtering, which could lead to incorrect query results in certain cases.

For example, suppose there are 10 files in total, and the first 5 do not match the filter criteria. If the query uses from = 0 and size = 5, applying pagination before filtering would select the first 5 files, all of which would then be filtered out — resulting in an empty result set, even though 5 matching files do exist.

This PR fixes the issue by ensuring that filters are applied first, and then pagination (from and size) is applied to the filtered results.

Rationale for this change

Standards checklist

• The PR title is descriptive
• The commit messages are semantic
• Necessary tests are added
• Updated the release notes
• Necessary documents have been added if this is a new feature
• Performance tests checked, no obvious performance degradation