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

Fetch XML Builder does not retain the correct table if there are multiple entities with the same display name. #1015

Closed
AzzaTsy opened this issue Feb 11, 2024 · 2 comments
Assignees

Comments

@AzzaTsy
Copy link

AzzaTsy commented Feb 11, 2024

In our implementation we have renamed the standard account table to 'entity'.

Upon selecting a table in the query builder and with the fetch XML open we can see the schema name of the table, below are the options our system.

-DisplayName: Entity, Schema Name: entity
-Display Name: Entity, Schema Name: msdyn_entityroutingconfiguration
-Display Name: Entity, Schema Name: account

FetchXml Builder Bug with Accounts

After making our selection for account then trying to select columns or adding a filter in the query builder window, it seems to revert back to the first table with the display name of 'Entity' and were unable to select columns from the account table.

D365 system allows for the same display names on tables if that is what it is getting confused about. The work around I have discovered is to disable friendly names or filter by your solution.

image

@rappen
Copy link
Owner

rappen commented Feb 12, 2024

Oh, I see that issue...!
I'll try to find a good solution that can make it very clear which table (and columns) you are really working on.

Thanks for the info!

@rappen
Copy link
Owner

rappen commented Apr 20, 2024

Added an option to show both DisplayName and LogicalName:

image

image

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

2 participants