FM_OrgAdminCountry

Overview

FM_OrgAdminCountry is a FiLMS module that allows country-specific organization admins to administrate multiple organizations by country.

It is an automated process that is triggered when:

User's role is assigned / changed to one of the country-specific organization admins:
Organization's Detail Field "Primary Country" is modified

If the organization's Primary Country is not assigned yet, users with Organization Admin role will administer it.

Installation

Install FM_OrgAdminCountry globally. During installation, FiLMS will create:

2 roles with organization level: Organization Admin Canada & Organization Admin USA
Organization's Detail Field "Primary Country" with Lookup (Canada and USA as lookup choices)

Countries are limited to USA and Canada only.
Organization's Detail Field "Primary Country" must be manually filled in to keep everything updated (i.e. assigning country-specific org admins to respective organizations).

N/A.

Crescent Point

To find out what country is assigned to all organizations, run the following query:

SELECT

organizations.id,

organizations.name,

IF(organization_details.value=95,'Canada',IF(organization_details.value=96,'USA','')) AS 'Primary Country'

FROM organizations

LEFT JOIN organization_details ON organization_details.organization_id = organizations.id AND detail_field_id = 193

Page updated

Report abuse