LoginContext query

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

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

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

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 secondary user.

Adam Marriott

Notes

  1. To show secondary users (group members) on 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"))

  2. 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.