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.

Sign up for GitHub

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

Jump to bottom

Non distinct query on 1:N doesn't return all columns #804

Closed
paultisski opened this issue Oct 28, 2022 · 2 comments
Closed

Non distinct query on 1:N doesn't return all columns #804

paultisski opened this issue Oct 28, 2022 · 2 comments

Comments

@paultisski
Copy link

If you query two tables with a 1:N relationship then it doesn't return columns from the table that is on the many side of the relationship. If you run the same code in Fetch XML tester then it does return the columns.
So it seems it is only returning distinct records even though distinct isn't specified.
I've looked through all the settings but can't find anything to change this.
Any help would be appreciated, thanks.
@rappen rappen mentioned this issue Oct 29, 2022
Closed
@rappen
Copy link
Owner

rappen commented Oct 29, 2022

This is as intended...
Since Dynamics requires an alias on the link-entity, to be able to display the related columns.
I know, there is bad info, will be better for next version!

Please reopen if you have more issues with this!

@rappen rappen closed this as completed Oct 29, 2022
@paultisski
Copy link
Author

Seems obvious now you mention it! Thanks for the info

rappen added a commit that referenced this issue Nov 17, 2022
@rappen
Added warning about link alias with layout issues #771 #775 #803 #804 #…
c8d9896 
…819
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@rappen @paultisski