Is there a default limit to the amount of data displayed within a Record view? I have a view that has 235 rows and 40 columns. When I try to display the data from this view, only 42 rows appear. I can export the full dataset and I can search for and filter for the full range of values in the table. But the row count and pagination isn't showing the correct values.
Discussion posts and replies are publicly visible
Have you tried to debug this issue using a query entity to see how many rows it returns?
Yes. The all the rows are returned.
Is there any sort of filter logic at all in the query? Anything that would theoretically prevent some kind of row from being returned by the query, or is it just SELECT * FROM ; ?
Are there any conditions on JOINs that might prevent some rows from being joined when forming the VIEW? You might try switching from JOIN to LEFT JOIN to RIGHT JOIN to OUTER JOIN to see what that does to your results.
no logic applied. When exporting to excel, the full expected dataset is returned. The issue is the displayed data. Even when filters are applied they are applied to the entire dataset not just the 42 rows.