UserPrincipalName (PQL)

Returns the user's principal name of the currently logged in user (deprecated). 

  • Returned Output: Text
  • Library: PQL \ Granular \ Identity
  • Version: 2023.00.000
  • Compatibility: Pyramid Query Language (PQL) data sources

Syntax

UserPrincipalName()

Comments
  • The function returns a value, rather than performing an operation on a given column.The value can then be used to drive derivative logic. The various Identity values are often used to secure data based on the current end user or create personalized values for the end user.
  • Principal names are associated with SAML, OpenID and Active Directory
  • For details on how to employ and use this function see the custom column overview.
Different Function types
  • This function is similar to the PQL common functions of the same name. However, it operates inside the query at the grain.
  • As a granular function, it is used in the base SQL query itself.

Examples

This example injects the current user's principle name into a another function (IF) to derive each items values in a column. If the values in the UPN column of the security table match the current user's principle name, then it returns true, otherwise it returns false.

If([Security].[UPN]==UserPrincipalName(), true, false)