It’s interesting to see that adjusting the stored procedure fixed your issue, Azhar. I’ll try reviewing my backend queries as well to ensure the filtered data returns the correct total count.
Just wondering: for Remote filtering, do you always need to reset the pageIndex to 0 after a search to avoid missing records on the next pages? Any tips would be appreciated!