How to properly limit records in a View Delegate without breaking pagination on a Process Screen?

Hi ​@bihalivan15 

Try using PXDelegateResult. The text and code example below are from the T250 course documentation.
 

When you are implementing a data view delegate, we recommend that you store the results of its dynamic query in
an object of the PXDelegateResult class and specify whether the query results are already filtered, truncated
(to fit the page), and sorted. Repeated operations are not applied to the PXDelegateResult objects. So if you
do not set IsResultFiltered, IsResultTruncated, or IsResultSorted to true, the platform will, respectively, filter, truncate, or sort the retrieved data aer it is obtained from the database. The following code
shows an example of how to use the PXDelegateResult class in a data view delegate.

protected virtual IEnumerable ardocumentlist()
{
PXSelectBase<BalancedARDocument> cmd =
new PXSelectJoinGroupBy<BalancedARDocument,
...
//Set the necessary sorting fields: use the key fields
OrderBy<Asc<BalancedARDocument.docType,
Asc<BalancedARDocument.refNbr>>>>
(this);
PXDelegateResult delegResult = new PXDelegateResult
{
IsResultFiltered = true,
IsResultTruncated = true,
IsResultSorted = true
}
foreach (PXResult<BalancedARDocument> res_record in cmd.SelectWithViewContext())
{
// add the code to process res_record
delegResult.Add(res_record);
}
return delegResult;
}