Hi folks,
We have one Account Entity having 200 fields. I want to know how i can know that which fields are not in use so that instead
of creating new fields we can reuse the unused fields.
Thanks
Hi Lu,
Thanks for your reply. I was looking the same kind of thing something automated because I have around 200 columns. Well same i achieved from SQL query.
But using XRM tool box seems to be very clean i will try this and let you know.
Thanks for your reply but I was looking solution to check if i have around 200 columns.
Hi windyMill,
If you mean fields that are not added to any component, such as being added to a form, in a view, or in a workflow, then you can only edit the fields one by one in the solution and click Show Dependencies to see if there are any Dependent components.
If you mean fields that do not contain data in all records, you can use Attribute Usage Inspector of XrmToolBox.
On the Field definition click the Show Dependencies button - if it is referenced in a Workflow, in a view, on a Form, or part of the trigger for a plugin they will be listed in the dependencies list.
Do an Advanced Find on the Entity and filter the field on contains data (will tell give you no results if the field is empty)
Daivat Vartak (v-9d...
225
Super User 2025 Season 1
Muhammad Shahzad Sh...
106
Most Valuable Professional
Eugen Podkorytov
102