What users observe
-
Fewer rows appear when running locally (preview mode)
-
Full dataset appears during full workflow execution
Why this happens
Select Records applies a local safety limit:
-
In local synchronous runs, output is capped (for preview performance)
-
This prevents large datasets from slowing down the UI
During full execution:
-
No artificial limit is applied
-
All matching rows are returned
Example
If selecting rows 1–100:
-
Preview mode → only first 20 rows shown
-
Full run → all 100 rows returned
Why this is correct
Preview mode is meant for:
-
Fast feedback
-
UI responsiveness
-
Configuration validation
Not full-scale processing
Recommendation
-
Trust preview for logic
-
Trust full run for volume