Skip to main content
Question

Tips on finding database fields

  • August 9, 2023
  • 1 reply
  • 133 views
J
Do Gooder (Customer)
Forum|alt.badge.img+2
  • JoshC
  • Do Gooder (Customer)

Hi all,

Does anyone have tips on finding where specific pieces of data are being stored & the functions that interact with them?

For example:

I’m looking for the Work E-Mail that is shown in the Contact Info Group of the Employee File page. Debug / Page Info tells me a few things;

  • It’s from view “COMPANY_PERSON_ALL”, but it isn’t a column. There is a function within “CompanyPerson” to “Get_Work_Email” that opens a rabbit whole of cascades functions.
  • It also tells me “Name: WorkEmail, Mandatory: false, Translation Path: PersonnelFile.group.ContactInfoGroup.groupcontent.field.WorkEmail” - but I can’t find PersonnelFile anywhere to follow that path.

Is there an easier way to identify where a piece of information on the page is ultimately being stored?

Kind regards,

Josh

D
Do Gooder
Forum|alt.badge.img

To locate specific data and related functions:

  1. Start with the view name ("COMPANY_PERSON_ALL").
  2. Search for "Get_Work_Email" function in "CompanyPerson".
  3. Follow cascading functions in the code.
  4. Note "Name: WorkEmail" and "Translation Path." Search for "PersonnelFile" in code to trace path. PapaSurvey
  5. Use debugging tools, code comments, or documentation for guidance.

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings