[DEFECT] pullRelatedField fails to return last "page" of results

Problem Statement

I'm getting 0 results when using $dotcontent.pullRelatedField() on the last "page" of results.

Steps to Reproduce

Log into dotAdmin on demo.dotcms.com.

At the time of writing, there are 4 blog contentlets associated with author f851e34a-d128-408e-a75a-4fa1c33201b8. If we set the limit to 3 and offset to 3 we should get 1 result, but get 0 instead.

#set ($blogs = $dotcontent.pullRelatedField("f851e34a-d128-408e-a75a-4fa1c33201b8", "BlogAuthor.blog", "+contentType:Blog ", 3, 3, "modDate"))

$blogs.size()

I noticed that using a higher limit (e.g. 30) does not trigger the bug, allowing us to receive the result set.

Acceptance Criteria

• $dotcontent.pullRelatedField() returns results as expected

dotCMS Version

• 23.10.24_lts_v0 (version first noticed on)
• dotcms-core 25.09.18-1 (demo.dotcms.com at the time of writing)

Severity

Medium - Some functionality impacted