Hi everyone.
I have a field buried inside other fields on several pages. It is a page reference field I use for setting navigation links (navbar, footer, banners, etc.). I need to get the pages that ultimately "contain" this field. This is, the pages the user edit in the admin and from where they set its value. These pages can be anywhere in the pages tree.
These are two examples of pages and their fields structures:
footer (Page) -> footer_columns (Repeater) -> nav_items (Repeater) -> nav_item (FieldSetPage) -> page_selector (Page Reference)
home (Page) -> home_covers (Repeater) -> nav_item (FieldSetPage) -> page_selector (Page Reference)
I need to get the ids of all pages that "contain" the page_selector field buried in their fields "trees". Since the pages that can contain it are not of the same template and will be changing (any page can start using it), I am not sure it can be solved using the pages API find function. I have tried examining the DB directly (I have no problem with MySQL) but haven't been able to decipher the relations between fields, repeaters and pages.
Any help will be appreciated