niota

Below a list of placeholders or system wildcard and the info where you can use this strings. If this string is used in another string, then the placeholder/the wildcard is replaced by the current value of this placeholder. You can not set the value of the placeholder on your own. It's set only be the system itself. Therefore it's just a placeholder, not a variable.

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

$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'