User Tools
niota-docs:niota_variables
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_variables [2025/12/04 16:13] admin |
niota-docs:niota_variables [2025/12/05 10:05] (current) admin |
||
|---|---|---|---|
| Line 44: | Line 44: | ||
| |''$lastName''|user's lastname |X|X|-|-|-| | |''$lastName''|user's lastname |X|X|-|-|-| | ||
| |''$msgGuid''|GUID of the message |X|-|-|-|-| | |''$msgGuid''|GUID of the message |X|-|-|-|-| | ||
| + | |''$product''|software product name |X|X|-|-|-| | ||
| |''$phone''|user's phone number |X|X|-|-|-| | |''$phone''|user's phone number |X|X|-|-|-| | ||
| |''$rowWhere''|primary key values concatenated with AND operator |X|-|-|-|-| | |''$rowWhere''|primary key values concatenated with AND operator |X|-|-|-|-| | ||
| Line 55: | Line 56: | ||
| |''$year''|year of system date |-|-|X|-|-| | |''$year''|year of system date |-|-|X|-|-| | ||
| |''$yyyymm''|year+month of system date |-|-|X|-|-| | |''$yyyymm''|year+month of system date |-|-|X|-|-| | ||
| - | |||
| |qualified placeholders||||||| | |qualified placeholders||||||| | ||
| |''$par.{<parameter name>}''|substitute with the value of the parameter |X|-|-|-|-| | |''$par.{<parameter name>}''|substitute with the value of the parameter |X|-|-|-|-| | ||
| - | |''$col.{colName}''|column value of the selected row |X|-|-|-|-| | + | |''$col.{<colName>}''|column value of the selected row |X|-|-|-|-| |
| |''$sys.Date''|current date in format 'YYYY-MM-DD' |X|X|-|-|-| | |''$sys.Date''|current date in format 'YYYY-MM-DD' |X|X|-|-|-| | ||
| |''$sys.Timestamp''|current timestamp in format 'YYYY-MM-DD-HH:MM:SS' |X|X|-|-|-| | |''$sys.Timestamp''|current timestamp in format 'YYYY-MM-DD-HH:MM:SS' |X|X|-|-|-| | ||
| ==== Substitutions in logfile filenname ==== | ==== Substitutions in logfile filenname ==== | ||
| - | For example: log_$date.txt.\\ | + | |
| + | {{:niota-docs:pasted:20251205-100500.png}} | ||
| + | |||
| + | For example: admin_action_$yyyymm.log.\\ | ||
| Logfiles are saved into the application folder /log subfolder. | Logfiles are saved into the application folder /log subfolder. | ||
| - | |||
| - | ==== Substitutions for callable objects ==== | ||
| === Database and catalog object related variables === | === Database and catalog object related variables === | ||
| - | ''$installation'' - current niota instance. Uses the value of INSTALLATION_NAME constant, defined in conf/my_formatting.php file\\ | + | ''$installation'' defined in conf/my_formatting.php file\\ |
| ''$client'' - actual niota-client which was chosen before log in act\\ | ''$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)\\ | + | ''$connectionType'' - type of the connection eg.: 'oci805'. |
| ''$domain'' - connection name\\ | ''$domain'' - connection name\\ | ||
| ''$dbName'' - database name. In the case of SQL Server it contains schema name too.\\ | ''$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\\ | ||
| - | |||
| - | |||
| - | === Variables (mainly) for calling a callable object === | ||
| - | |||
| - | ''$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\\ | ||
| - | |||
| - | |||
| - | |||
| - | === Variables (mainly) for messaging feature === | ||
| - | |||
| - | ''$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\\ | ||
| - | |||
| - | === File upload related substitutions === | ||
| - | |||
| - | ''$uploadPath'' - path of the file\\ | ||
| - | ''$uploadFolder'' - path of the target folder\\ | ||
| - | ''$uploadFile'' - only the file name (with extension)\\ | ||
| - | |||
| - | === Possible substitutions also for line level stored procedures === | ||
| - | |||
| - | ''$col.{colName}'' - substituted with column value of the selected row (eg.: delete from example_table where column_name like '$col.{example_column}' ) | ||
| - | |||
| - | |||
| - | === Available system information === | ||
| - | ''$sys.Date'' = current date in format 'YYYY-MM-DD'\\ | ||
| - | ''$sys.Timestamp'' = current timestamp in format 'YYYY-MM-DD-HH:MM:SS'\\ | ||
niota-docs/niota_variables.1764861194.txt.gz · Last modified: 2025/12/04 16:13 by admin