User roles query

The User roles query is used to export each User and the Roles that have been assigned for authorization access in FBO One.

Report example:

You can download the User Roles using the default ‘User roles’ report.

Report tips:

When used in combination with the Role authorization query, you can get an overview of what each user is authorized to do in FBO One.

Using an Excel pivot table you can see if multiple roles have been assigned to a user.

Pivot table examples for User Roles:

Useful Pivot table examples:

'User name' or 'User display name' as Row labels as there are usually many users
‘Role code’ in the Column labels as there are usually just a few
'Is active' in the values
The user’s default FBO location or employee organization in the filter, using ‘User FBO location’ or ‘User organization’

Filters:

There are no required filters for this query.

Data provider settings:

The following ‘Data provider settings’ can be set in Reports (Administration) for the query, if not specified the default applies. All settings must be separated by a semi-colon ';'.

Data provider settings example:

Setting

Type

Default

Description

CommandTypes

String

Entity command, Simple command

Allows filtering on which command types are shown in the report. If adding multiple to the setting, each should be separated by a comma. Possible values:

Admin
AircraftAdmin
Entity command
MsgCategory
Order report
Product
Simple command
Workflow
WorkflowTransition

Columns:

Column	Description	Example
User name	User’s username.	Handling
User display name	The user’s display name, defaults to show the user’s ‘Full name’, if blank then ‘User name’ is shown.	Handling Department
User FBO location	User’s default FBO location.	FBO
User organization	User’s organization for audit logging.	FBO One
Employee name	The secondary user’s display name, defaults to show the user’s ‘Full name’, if blank then ‘User name’ is shown. Applies to users that are group members for a group user. Each group member will show as a new row for each role.	Neil Butler
Role code	Role code for the role.	OPS Layout Handlings
Role description	Role description for the role.	Show handlings in the OPS page
Is active	Indicates if the user is marked as active.	TRUE
Is read only	Indicates if the user is marked as having read-only access.	FALSE
QRCode	Allows generating a QR code using data from other columns, see How to add a QR code to a report. Example shown: Settings: ShowBarCodeOnEveryRow=true; MultipleValuesSeparator=" \| " Columns: Username, Role code, Command Name, View (column format: View: {0}), Add (column format: Add: {0}), Edit (column format: Edit: {0}), Delete (column format: Delete: {0})
Command Name	Authorization function command name.	Payment
Add	Indicates if the user has ‘Add’ access for the command.	TRUE
View	Indicates if the user has ‘View’ access for the command.	TRUE
Edit	Indicates if the user has ‘Edit’ access for the command.	TRUE
Delete	Indicates if the user has ‘Delete’ access for the command.	TRUE
Admin	Indicates if the user has ‘Admin’ access for the command.	FALSE
Command Type	Authorization function command type. Possible values: Admin AircraftAdmin Entity command MsgCategory Order report Product Simple command Workflow WorkflowTransition	Simple command
Station ID	The station’s unique ID in GUID format for the user’s default FBO location set. For OPS FBO location view the primary FBO station ID is shown.	89bbfe6a-c876-4fb9-9bcb-b4d52cb1f242
User Ops Fbo Location Set	User’s default OPS View For Multiple FBOs (Administration) if set.	ALL LOCATIONS
User Id	User’s unique ID in GUID format.	0a038fcf-08a1-4ea2-b276-df14aa8d4836
User remarks	Remarks for the user.	External user

Search

Welcome to our Support Portal

Contents:

Report tips:

Filters:

Data provider settings:

Columns:

Comments