Fetch XML Builder does not retain the correct table if there are multiple entities with the same display name.
Closed this issue · 2 comments
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
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.
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!