niota

Below a list of placeholders or system wildcard and the info where you can use this strings. If this string is used in other string, than the placeholder/the wildcard is replaced by the current value of this placeholder.

For example: log_$date.txt.
Logfiles are saved into the application folder /log subfolder.

$userName - actual user's name
$firstName - actual user's firstname
$lastName - actual user's lastname
$fullUsername - actual user's fullname
$email - actual user's email address
$phone - actual user's phone number

$installation - current niota instance. Uses the value of INSTALLATION_NAME constant, defined in conf/my_formatting.php file
$client - actual niota-client which was chosen before log in act
$connectionType - type of the connection where that table is placed where the callable object was executed (eg.: 'oci805'. Makes no sense in the dynamic menu)
$domain - connection name
$dbName - database name. In the case of SQL Server it contains schema name too.
$fullDbName - prefix which needs to fully qualify a table. Oracle: db_username, SQL Server: db_name.schema_name, Teradata, MySQL: db_name. Ends without a dot character.
$callableFullDbName - prefix which needs to fully qualify the current callable object
$fullTableName - the actual table name substitution (with db (and schema) name. In the case of Oracle it is equals with $tableName.)
$tableName - actual table name substitution (without db name and schema name)
$catalogId - catalog id of the table
$instanceName - instance name of the table
$catalogInstanceId - catalog id and instance name of the loaded (or master) table concatenated with a '.' (dot) character
$catalogId_1 - catalog id of the of the loaded (or master) table, master grid in a master-detail configuration
$catalogId_2 - catalog id of the 1st detail table
$catalogId_3 - catalog id of the 2nd detail table
$catalogId_4 - catalog id of the 3rd detail table
$instanceName_1 - instance name of the loaded (or master) table, master grid in a master-detail configuration
$instanceName_2 - instance name of the 1st detail table
$instanceName_3 - instance name of the 2nd detail table
$instanceName_4 - instance name of the 3rd detail table
$catalogInstanceId_1 - catalog id and instance name of the loaded (or master) table, master grid in a master-detail configuration
$catalogInstanceId_2 - catalog id and instance name of the 1st detail grid in a master-detail configuration
$catalogInstanceId_3 - catalog id and instance name of the 2nd detail grid in a master-detail configuration
$catalogInstanceId_4 - catalog id and instance name of the 3rd detail grid in a master-detail configuration
$catalogIdCurrent - catalog id of the table where last row-selection happened. It can be the master or a detail grid.
$instanceNameCurrent - instance name of the table where last row-selection happened. It can be the master or a detail grid.
$catalogInstanceIdCurrent - catalog id and instance name of the table where last row-selection happened. It can be the master or a detail grid.
$rowWhere - primary key values concatenated with AND operator - useable in SQL queries
$lang - language setting of the user
$langSystem - active admin area language
$langGrid - active grid area language

$par.{<parameter name>} - substitute with the value of the parameter - only in case of parameter set bind to callable object
$uca - content of user communication area - in case of callable object

$sessionId - current session, given by the web server
$msgGuid - GUID of the message
callableFullDbName - database name of the callable object. It contains schema name also in the case of MSSQL

$uploadPath - path of the file
$uploadFolder - path of the target folder
$uploadFile - only the file name (with extension)

$col.{colName} - substituted with column value of the selected row (eg.: delete from example_table where column_name like '$col.{example_column}' )

$sys.Date = current date in format 'YYYY-MM-DD'
$sys.Timestamp = current timestamp in format 'YYYY-MM-DD-HH:MM:SS'