How can I retrieve list of all views in a organization? - to detect duplicate view

(0) Share

Report

Posted on by Community Member

How can I retrieve list of all views in a organization?

Somehow CRM messed up with duplicate views (views with same name).

If possible, I like to query against DB and retrieve all views in a organization. It will be easy for me to identifies the duplication.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

razdynamics 17,308 User Group Leader on at

Like (0)

Report

Hi Sky

The XRM Toolbox provides free utilitites to help you solve your issues www.xrmtoolbox.com/download.html

•View Layout Replicator

•View Transfer Tool

github.com/.../Available-plugins-for-XrmToolBox

Hope that helps :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for the quick response!!!

Your suggestion is one way to resolve the issue. Thank you.

But, I have to click each entity one by one. If I can query against DB, I can export to excel and identify the duplicate right away on entire organization.

Somehow duplicate happens often due to big project with multiple developers, I need quick solution to monitor :)

Was this reply helpful? Yes No
Turlapati Vishnu Na... 336 on at

Like (0)

Report

You can go to advanced find in CRM and search for views. There you can find all the list of views. You may delete them accordingly from them. If you want to do batch deletion you may try leveraging the APIs.

Do let me know if you need further help.

Was this reply helpful? Yes No
Thomas Daly 10 on at

Like (0)

Report

I noticed this view doesn't tell you the primary entity the view is associated to. There is however an attribute you can add to a custom fetch that will include the primary field: "fetchxml". If you parse the contents of this field, you should see a reference to the primary entity for most views.

Here's an example of the custom fetch:

<fetch mapping="logical" output-format="xml-platform" version="1.0" distinct="false">

<entity name="savedquery">

<attribute name="fetchxml" />

<attribute name="name" />

<attribute name="description" />

</entity>

</fetch>

Was this reply helpful? Yes No