Hi @JMusson, There could be many approaches. If you are looking to fetch the work email which shows in the ‘Employee File’ window summary tab, then you can use a custom filed in the ‘Employees’ window to create a custom column to fetch data via the existing DB function Company_Person_API.Get_Work_Email(COMPANY_ID, EMP_NO). With that you can extract the details from the employees window with the work email. Otherwise, if you have a specific requirement & need to fetch all the emails for an employee, perhaps you could try out in the ‘SQL Query Tool’ window. A sample query could be written as below. you could modify it to filter by Address type to be Home & default methods etc, depending on your requirement - direct SQL output. SELECT CPA.COMPANY_ID, CPA.EMP_NO, CPA.FNAME, CPA.LNAME, PC.COMM_DATA, PC.COMM_DEFAULT_FLAG, PC.METHOD_ID, PIA.ADDRESS_TYPE_CODE, PIA.Address_id FROM PERSON_INFO_ADDRESS_TYPE PIA, COMPANY_PERSON_ALL CPA, PERS_COMMS2 PC WHERE PIA.PERSON_ID = CPA.PERSON_I
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.