Advanced Append Subquery Joins + Row Limits

Dean Flinter shared this idea ago

Idea Logged

Hi,

My understanding is that basic subqueries do not respect row limits on reports in order to make sure there is a match for the join i.e. the results of the subquery are not limited

However we have seen that in advanced subqueries with a view based on a different datasource, this is not the case. I can imagine that since the application fires off a separate query that it might treat it as another report/master level query and hence the limit the result before joining the 2 result sets together in memory.

Just wondering if this is intended behaviour or perhaps a bug?

Thanks

Dean

I like this idea 0

Replies (4)

Chris McCarthy ●

Hi Dean,

I hope you're well.

This is known behaviour for subqueries from different data sources and we have an enhancement open for it. If you like, I can add your support to it to help raise visibility with the developer team.

Let me know.

Kind regards,

Chris

Reply URL

Dean Flinter ●

Hi Chris,

Yes please do

In this case we managed to get around it by adding the tables from the other datasource to the same database as the original source. This was only possible as they were both Snowflake databases. However we likely would be looking to join up disparate databases in the future so definitely something we would like looked at

It might also be more important now with the CData connector integrations

Thanks

Dean

Reply URL

Chris McCarthy ●

Hi Dean,

Thanks for letting me know your reasoning. If that's everything I'll mark this as enhancement logged.

Kind regards,

Chris

Reply URL

Dean Flinter ●

Sounds good.

Thanks

Reply URL