I’ve got a simple BAQ on our Part table which is returning 10k records, even though RemoveTestRowLimit is set to TRUE. We’ve got about 150k parts. It originally was joined to PartCost with a calculated field, with the default RemoveTestRowLimit execution setting (of FALSE). I deleted the PartCost table and calculated field, and set ‘RowsToReturn’ to 20000 (since set back to blank), but it’s still returning 10k records.
What else am I missing?
If you are running the BAQ in the analyzer, then you have to set the limit right there on the analyze tab, near the test button. In the “Rows to Return” drop down, type in your max number of rows.
That option you set only matters if you run the BAQ outside of the analyzer. (See @Banderson post below)
@NateS , that’s not true, this should work. There’s no limit outside of the tester even without that flag.
Start over. Maybe it’s possessed?
@NateS - It doesn’t matter if I have Rows to Return set to 20000 or blank. Still 10000 rows returned. I also tried different versions of true, TRUE, True in RemoveTestRowLimit. Neither has been an issue before.
Can you go on your server and check this setting?
@Banderson FTW! I’m checking why this was changed… Thank you!