These parameters can be used in GeniusConnect SQL queries (
Filter Rows ,
Custom Insert,Update,Delete etc...)
{DB_LOGIN_USER} runtime value:
Login used to connect to the database (NT User if NT security used)
{DB_USER_NAME} runtime value:
Username returned by the database
{WINDOWS_USER} runtime value:
Current windows (NT) user
{WINDOWS_NT_USER} runtime value:
Current windows (NT) user, (domain included)
Example runtime value: mydomain\John
{OUTLOOK_USER} runtime value:
Current Outlook user (only Outlook 2003 or higher)
{OUTLOOK_USER_EMAIL} runtime value:
The email address of the currently logged-on user
{OUTLOOK_FOLDER_FULL} runtime value:
Current Outlook folder full path and name
Example runtime value Outlook 2000: Calendar
Example runtime value Outlook 2002 or higher: \\Personal Folders\Calendar
{OUTLOOK_FOLDER_NAME} runtime value:
Current Outlook folder name
Example runtime value: Calendar (same us {OUTLOOK_FOLDER_FULL} in Outlook 2000)
*
{EXCHANGE_FOLDER_OWNER} runtime value:
Exchange only/Office 365 only! Name of a Mailbox Folder Owner. (Not for Public Folders)
Example runtime: John Smith
*
{EXCHANGE_FOLDER_OWNER_EMAIL} runtime value:
Exchange/Office 365 only! The email address of the exhange folder owner. (Not for Public Folders)
Example runtime:
user@domain.com*
{EXCHANGE_FOLDER_OWNER_ENTRYID} runtime value:
Exchange/Office 365 only! MAPI EntryID (unique identifier used by Outlook/Exchange) of a Mailbox Folder Owner. (Not for Public Folders)
Example runtime: 000000001A447390AA6611CD9BC800AA002FC45A03001C29EC2B445D7C4297
*
{EXCHANGE_FOLDER_USER_NAME} runtime value:
Exchange/Office 365 only! Name of a Mailbox Folder user.
Example runtime: John Smith
{COMPUTER_NAME} runtime value:
Current NetBIOS name of the local computer
*Value may not be available in Cached Exchange Mode