Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Cannot delete field inside entity

Posted on by 5

I have a field called Region inside Contact entity.

I want to delete the field,however I cannot do so as the field has dependency,which is a view from Key Contact entity.

The view is called Key Contact Associated View. I have checked the view and the Region field cannot be seen inside the view: 

snip11.JPG

But when I try to open the xml using fetchxml, there is linking of Key Contact and Contact inside Key Contact Associated View :

snippp.JPG 

The attribute ads_region is the field I want to delete inside the view,so that I can delete the field inside Contact entity. However I cannot find the field when I try to edit the view but I can find attribute gendercode inside the view.

When I try to delete the relationship from fetchxml,it says that I cannot change the return attribute: 

snipppppp.JPG

How can I delete the field from the view (the dependency) so that I can delete the field in Contact entity?

  • NurNina Profile Picture
    NurNina 5 on at
    RE: Cannot delete field inside entity

    Thank you so much for the help!

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Cannot delete field inside entity

    Hi NurNina,

    I reproduced you issue:

    I created a view which is based on contact, it displays contact fields and its related country(a lookup field) information.

    In country entity, there is a field called "Continent", I want to remove it from the view.

    pastedimage1599533016964v1.png

    The reason for your issue would be that you were using FetchXML Builder to remove attributes, however, the plugin only updates the query of the view(only fetchXml), which means that the query must contain the expected set of columns, otherwise the view will "crash".

    Instead, you should use View Designer to edit view and remove attributes, it will change column(layoutXml) of view at same time.

    Your issue might be similar to following issue on GitHub:

    https://github.com/rappen/FetchXMLBuilder/issues/139

    Regards,

    Clofly

  • NurNina Profile Picture
    NurNina 5 on at
    RE: Cannot delete field inside entity

    yes, i directly tried to delete the attribute

  • cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Cannot delete field inside entity

    How did you delete the relationship from fetchxml?

    Would it be by removing ads_region attribute from fetchxml query directly?

    Regards,

    Clofly 

  • NurNina Profile Picture
    NurNina 5 on at
    RE: Cannot delete field inside entity

    Hi there,thank you for the respond. I use XrmToolBox because I want to see the link inside the view. I cannot see the dependent column from the OOB editor.

  • cloflyMao Profile Picture
    cloflyMao 25,198 on at
    RE: Cannot delete field inside entity

    Hi NurNina,

    We can also check dependencies of field in legacy web client:

    Top right gear icon > Advanced settings > Customizations > Customize the system > Entities > Fields

    pastedimage1599465298642v1.png

     When deleting a field which has dependencies, associated components can be also found in Details link of error prompt window.

    pastedimage1599465359355v2.png 

    Could you tell me why did you use XrmToolBox to remove field of view?

    You can remove the column of the view in OOB editor directly.

    pastedimage1599465694182v3.png

    Regards,

    Clofly

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans