Finding Fields not on any layouts.

jerry_salem's Avatar


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.


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

    jay_g's Avatar

    Hi Jerry - Vince wrote:


    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.


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

    jay_g's Avatar

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

  3. jay_g closed this discussion on 10 May, 2022 07:55 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

11 Aug, 2022 10:29 PM
27 Jul, 2022 04:52 PM
25 Jun, 2022 05:29 AM
12 Jun, 2022 01:39 PM
10 May, 2022 07:45 AM