rappen / FetchXMLBuilder

FetchXML Builder for XrmToolBox and Microsoft Dynamics 365 / CRM
https://fetchxmlbuilder.com/
GNU General Public License v3.0
133 stars 55 forks source link

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

Closed AzzaTsy closed 2 months ago

AzzaTsy commented 5 months ago

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 commented 5 months ago

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 commented 2 months ago

Added an option to show both DisplayName and LogicalName:

image

image