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:

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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

12 Oct, 2021 05:29 PM
31 Aug, 2021 08:55 AM
25 Aug, 2021 11:08 PM
20 Jul, 2021 07:37 AM
24 Jun, 2021 07:15 AM