The users query is used to show user data and last login, showing each user per row.
See User roles 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 |
|---|---|---|
|
Display name |
The user’s display name, defaults to show the user’s ‘Full name’, if blank then ‘User name’ is shown. |
Adam Marriott |
|
|
User’s email. See 'Email address' field for the user. |
adam@fboone.com |
|
Enable two factor auth |
Indicates if the user can login with two factor authorization. |
FALSE |
|
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 |
|
Group member passcode |
The user member passcode used when the user is logged in as a group user for actions. See 'Group member passcode' field for the user |
AMA |
|
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:
|
|
|
Recovery email |
Recovery email for the user. See 'Recovery Email' field for the user. |
adam@fboone.com |
|
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 |
|
User type |
User’s type. See 'Type' field for the user. |
Private |
Comments
0 comments
Please sign in to leave a comment.