[mailomid]

hello
how can receive a department manager (Department manager manual set In this address - Admin\Departments) with trigger or show in bitnami database?

[Bosatzu]

hello
how can receive a department manager (Department manager manual set In this address - Admin\Departments) with trigger or show in bitnami database?

You can use a query on your trigger like this (It is an example):

Code: Select all

select a.DEP_UID,a.DEP_TITLE,b.USR_UID,concat(b.USR_LASTNAME,' ',b.USR_FIRSTNAME) FROM DEPARTMENT a LEFT JOIN USERS b ON a.DEP_MANAGER=b.USR_UID

It will show you the manager of each department that was created.