Users query

See User role query for showing roles assigned to the user.

Contents:

Filters

There are no required filters for this query.

Data provider settings

There are no data provider settings for this query.

Columns

Column

Description

Example

Column

Description

Example

Display name

The user’s display name, defaults to show the user’s ‘Full name’, if blank then ‘User name’ is shown.

Adam Marriott

FBO location

User’s default FBO location. See 'Default FBO location' field for the user.

EGSS

FBO location ID

The Default FBO location unique ID in GUID format.

4e72f72c-b4bb-479f-b376-cb232c9947b4

Groups

The Group users the user is a member of. Each group user is separated by comma.

FBO One Support

Is active

Indicates if the user is marked as active See 'Is active' field for the user.

TRUE

Is read only

Indicates if the user is marked as having read-only access. See 'Is read-only' field for the user.

FALSE

LastLogin

Displays the last login date and time for the user in UTC.

10/06/2020 08:08:53

Ops FBO Location Set

User’s default OPS FBO location. See 'Default OPS FBO location set' field for the user. See OPS View For Multiple FBOs (Administration).

ALL LOCATIONS

Ops FBO Location Set Id

The Default OPS FBO location set unique ID in GUID format.

33acd253-e9c7-40ff-9d28-e94a85851223

Organization

User’s organization for audit logging. See 'Organization for audit log' field for the user.

Fbo One Users

Organization contact ID

The Organization for audit log contact’s unique ID in GUID format.

326a3316-50fb-41ed-ad42-7d97228ce951

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, Display name, FBO location, LastLogin, Is active (column format: Is active: {0})

Remarks

Remarks for the user, see ‘Remarks' field in Users (Administration).

External user

Use UTC

Indicates if the user’s times are displayed in UTC or local time. See 'Display times in UTC' field for the user.

TRUE

User ID

The User’s unique ID in GUID format.

ed4c40bd-5254-4e2e-b2d3-17435e71cbbb

User name

User’s username. See 'User name' field for the user.

AdamMarriott