USER_INFO

SyntaxSyntax

USER_INFO( user_id, user_info_type )

DescriptionDescription

Returns the marked up text by user_id to display username or email depending on the user_info_type value:

• email: Returns email.
• name: Returns name.

If the user has not been found, the function will return the original string from the source.

Argument types:

• user_id — String
• user_info_type — String

Return type: Markup

ExamplesExamples

USER_INFO('b1ggmp8es27t********', 'name') = 'test_user'

USER_INFO([UserId], 'email') = 'test_user@example.com'

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.