Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Adding a filter on a virtual attribute bypasses check of total join number #158

Closed
olaf-matthes opened this issue Feb 1, 2022 · 0 comments

Comments

@olaf-matthes
Copy link

When joining more than 10 entities and querying a virtual attribute, this error message occurs:
Number of link entity: 11 exceed limit 10. isReport=False.

Example:

select top 10 a.name from account a
join contact c1 on c1.accountid = a.accountid
join contact c2 on c2.accountid = a.accountid
join contact c3 on c3.accountid = a.accountid
join contact c4 on c4.accountid = a.accountid
join contact c5 on c5.accountid = a.accountid
join contact c6 on c6.accountid = a.accountid
join contact c7 on c7.accountid = a.accountid
join contact c8 on c8.accountid = a.accountid
join contact c9 on c9.accountid = a.accountid
join contact c10 on c10.accountid = a.accountid
join contact c11 on c11.accountid = a.accountid
where a.primarycontactidname = ‘Test’
@MarkMpn MarkMpn closed this as completed in bc3f7da Apr 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant