Home → InspectorPro 6 & 7 →

Finding Fields not on any layouts.

• Edit

jerry_salem

08 May, 2020 03:08 PM

Is it possible too query the DDR too find any fields on zero or one layouts?

If I am trying to get rid of unused fields, there are many situations where a field is not on any layouts but is still being set by a number of scripts or being exported. So the number of references might be high (i.e. not zero) but the specific field might not be on any user facing layouts.

It would be easier to identify these fields if I could find fields by the number of layouts they are on.

TIA

1. Support Staff 1 Posted by jay_g on 09 May, 2020 10:09 PM

   

   Hi Jerry - Vince wrote:

   Jerry,

   Never an impossible thing…

   Currently all the dependencies are organized into the Dependency Table.

   So if a field is referenced by something it will have an intersection in that table.

   So your search would have to specifically or additionally search for any dependencies where the field is on a layout.

   Easy enough to do behind the scenes but will take a little bit of doing to get some elegant UI in place to pull this off.

   Then this could open up the door to all kinds of things… for example … we also have a green target icon showing up if the field is referenced and the data for that field can be modified.

   So you perform a field for any field where the dependency target flag is = TRUE

   Or in your case if the field dependency type is Field on layout.

   I’ll give this some serious consideration…

   Thanks for brining it up.

   Vince

   • Edit

2. Support Staff 2 Posted by jay_g on 09 May, 2020 10:10 PM

   

   Also see this screenshot, related to Vince's response:

   • Screen_Shot_2020-05-09_at_2.44.38_PM.png 929 KB
   • Edit