Developer Documentation Library > Interviewer - Server Admin > User administration > Importing users and roles > Setting up the spreadsheet > GlobalFilters
 
GlobalFilters
The GlobalFilters worksheet defines global filters for a user or role for a particular project.
The worksheet must contain three columns called ProjectID, RoleOrUserNames, and Filter listing the filter to be applied for each user or role when working on a project. The ProjectID field must contain the project’s uppercase ID, not it’s name. By default, UNICOM Intelligence Interviewer - Server Admin creates projects with the same name and ID, except that the ID is in upper case. User and role names in a list must be separated by semicolons.
If a user who has a global filter is also a member of a role that has a different global filter, the filter at the user level overrides the role-level filter. The two filters are not combined.
For more information, see Setting up global filters.
Example
ProjectID
UserOrRoleNames
Filter
TRAVEL
ProjManEast;AnalysisEast
Region.ContainsAny({East})
TRAVEL
ProjManWest;AnalysisWest
Region.ContainsAny({West})
See also
Setting up the spreadsheet