Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Paged search results duplicate one result, skip another
I have an architecture of parent and child records such that Top(T) has one or more children records (M), each of which can have one or more children records (L).
I run a saved search paged. The search record type is M so I can find all L records associated with M's parent T.
I've created a set of test records such that a page size of 5 will ensure some L records end up on separate pages (most T records have three L records associated).
One test case works correctly, adding L records from a page not within the page range. However, on a particular page, an L record is duplicated and a third L record is lost. When I run the search such that the results are returned on a single page (by using a pagesize of 1000 say), all three records for that T record are found and there are no duplicates. Details below if you're interested.