BAQ Subqueries Limit

Is there a limit to the number of subqueries in a BAQ?

Your server performance is likely the limit. I doubt there is a hard limit coded in. At least I haven’t hit a limit, I think my worst query is 10 deep

I have one with 13 total subqueries (including the top-level query). So the limit is higher than that if there is one.

I came across a BAQ using 75 sub queries a couple of weeks ago. It ran.

1 Like

out of curiosity, what question was that one trying to answer!?

I was making some criteria changes for a customer and chose not to dig too deep into their original intentions. I think the author was essentially isolating all calculations into separate sub queries (lots of PartTran instances).