Menu

Admin_howto

Kenneth Tanzer

(This page is for administrators, for various items that aren't yet documented elsewhere. As needed, they could be moved to other pages)

Staff emails show up as '@yourdomain.org'

The default email address for staff is controlled in the database, in the staff view. If an email address is specified in a staff record, it will be used. Otherwise, by default, this line is used to generate an email address:

COALESCE(
 tbl_staff.staff_email,
 tbl_staff.username_unix,
 tbl_staff.username||'@yourdomain.org')::varchar(60)
AS staff_email,

You can adjust that line in a manner that suits you, by editing the file database/pg/agency_core/create.view.staff.sql

You will then need to drop and recreate the view:

BEGIN;
DROP VIEW staff;
\i database/pg/agency_core/create.view.staff.sql
END;

[CATEGORY:admin]


Related

Wiki: Main_Page

MongoDB Logo MongoDB