LoginContext query

The LoginContext query is used to show the currently logged-in user details.

Report example:

The LoginContext query can be used in conjunction with other queries to show the currently logged-in user in a report.

Filters

There are no required filters for this query.

There are no data provider settings for this query.

Column	Description	Example
Primary username	Shows the current logged-in primary user name. This may be the group user name if a group user.	FBO One Support
Primary full name	Shows the current logged-in primary user's full name. This may be the group user’s full name if a group user.	FBO One Support
Primary email	Shows the current logged-in primary user's email. This may be the group user’s email if a group user.	support@fboone.com
Primary remarks	Shows the current logged-in primary user's remarks. This may be the group user’s remarks if a group user.	Main Support account
Secondary username	Shows the secondary user name if a group member user. Note: User passcode is required to show secondary user.	AdamM
Secondary full name	Shows the secondary user’s full name if a group member user. Note: User passcode is required to show the secondary user.	Adam Marriott
Secondary email	Shows the secondary user's email if a group member user. Note: User passcode is required to show secondary user.	adam@fboone.com
Secondary remarks	Shows the secondary user's remarks if a group member user. Note: User passcode is required to show secondary user.	AMS Support member

To show secondary users (group members) on RDL reports instead of primary users (group user) where applicable use RDL expression: =IIF(IsNothing(First(Fields!SecondaryFullName.Value, "LoginContext")),First(Fields!PrimaryFullName.Value, "LoginContext"),First(Fields!SecondaryFullName.Value, "LoginContext"))
In order to insert the Username within an RDL report table using a different query, use the expression: =First(Fields!EmployeeFullName.Value, "LoginContext"). The same expression will be created if insert placeholder is used.

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.
Users query — The users query is used to show user data and last login, showing each user per row.