search

stevebuik / Graphvizforce-Lightning

Automatic Entity-Relationship diagrams and SOQL queries for Salesforce
The Unlicense
31 stars 3 forks source link

Joins to user create a weird query #53

Closed stevebuik closed 6 years ago

stevebuik commented 6 years ago

The query with no fields selected is:

SELECT Id,LastModifiedBy.Account.LastModifiedBy.Account.LastModifiedBy.Id,LastModifiedBy.Account.LastModifiedBy.Account.Id,(SELECT Id FROM Users) FROM Account

Also get the "cannot use" warning when trying to select from User.

Fixing this is quite difficult so recording it here to see if it is important to users. If so, please add a comment below.

stevebuik commented 6 years ago

also handled the thrown error better and clearing the from entity for now