<< Click to Display Table of Contents >> System Parameter |
❖System Parameter list
Name |
Instructions |
---|---|
_USER_ |
Return the current user name |
_USER_ALIAS_ |
Return the alias of the currently logged-in user. |
_GROUP_ |
Return the current user's group |
_GROUPS_ |
Return the current user's groups (multiple groups) |
_ROLE_ |
Return the current user's role |
_ROLES_ |
Return the current user's roles (multiple roles) |
_BLANK_ |
Return null value in data |
_NOW_ |
Return the current time (type is timestamp) |
_IP_ |
Return the IP of the currently logged-in user |
_NOW_LONG_ |
Return the current time (type is integer) |
_LAST_YEAR_ |
Return the previous year of the current time. The value is an integer. If this year is 2013, the return value is 2012. |
_THIS_YEAR_ |
Return the year of the current time and the value is an integer |
_NEXT_YEAR_ |
Return the next year of the current time, the value is an integer |
_LAST_QUARTER_ |
Return the previous quarter of the current quarter. The value is an integer |
_THIS_QUARTER_ |
Return the current quarter value as an integer |
_NEXT_QUARTER_ |
Return the next quarter of the current quarter. The value is an integer |
_LAST_MONTH_ |
Return the previous month of the current month. The value is an integer |
_THIS_MONTH_ |
Return the current month value as an integer |
_NEXT_MONTH_ |
Return the next month of the current month as an integer |
_LAST_WEEK_ |
Return the number of the previous week of the year. The value is an integer. If today is 2013-01-18, it is the third week in 2013, the return value is 2 |
_THIS_WEEK_ |
Return the number of the current week of the year, the value is an integer, as today is 2013-01-18, is the third week in 2013, the return value is 3 |
_NEXT_WEEK_ |
Return the number of the next week of the year. The value is an integer. If today is 2013-01-18, it is the third week in 2013, the return value is 4 |
_LAST_DAY_ |
Return the date of the previous day, the value is an integer, such as today is 2013-01-18, the return value is 17 |
_THIS_DAY_ |
Return the date of the current day, the value is an integer, such as today is 2013-01-18, the return value is 18 |
_NEXT_DAY_ |
Return the date of the next day, the value is an integer, such as today is 2013-01-18, the return value is 19 |
_LAST_YEAR_QUARTER_ |
Return the first day of the previous quarter. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-01-01 00:00:00 |
_THIS_YEAR_QUARTER_ |
Return the first day of the current quarter. The return value is a timestamp type, if today is 2013-04-18, the return value is 2013-04-01 00:00:00 |
_NEXT_YEAR_QUARTER_ |
Return the first day of the next quarter. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-07-01 00:00:00 |
_LAST_YEAR_MONTH_ |
Return the first day of the previous month. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-03-01 00:00:00 |
_THIS_YEAR_MONTH_ |
Return the first day of the current month. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-01 00:00:00 |
_NEXT_YEAR_MONTH_ |
Return the first day of the next month. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-05-01 00:00:00 |
_LAST_YEAR_WEEK_ |
Return the first day of the previous week. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-07 00:00:00. Note that the week is calculated according to the specifications provided by java, taking Sunday as the starting point of the week |
_THIS_YEAR_WEEK_ |
Return the first day of the current week. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-14 00:00:00 |
_NEXT_YEAR_WEEK_ |
Return the first day of the next week. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-21 00:00:00. |
_LAST_FULL_DAY_ |
Return the day before the current date. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-17 00:00:00 |
_THIS_FULL_DAY_ |
Return the current date. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-18 00:00:00 |
_NEXT_FULL_DAY_ |
Return the day after the current date. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-19 00:00:00 |
_LAST_WEEKDAY_ |
Return which day of the week for the day before the current date. The return value is an integer. If today is 2013-04-18, the return value is 4. Note that the week is calculated according to the specifications provided by java, taking Sunday as the starting point of the week |
_THIS_WEEKDAY_ |
Return which day of the week it is for the current date. The return value is an integer, such as today is 2013-04-18, the return value is 5 |
_NEXT_WEEKDAY_ |
Return which day of the week it is for the day after the current date. The return value is an integer. If today is 2013-04-18, the return value is 6. |
_CURRENT_LOCALE_ |
Return the region and language of the current environment. |
_EXECUTION_ID_ |
Used for process approval to get the branch id of the current process. |
_INSTANCE_ID_ |
Used for process approval to get the process id of the current process. |
❖Set Built-in Parameters
Name |
Value Type |
Instructions |
---|---|---|
_EXCEL_EXPORT_TYPE_ |
String/Integer |
Control the excel export content of the page 0——indicates that the Dashboard page and all details are exported at the time of export. 1——means that when exporting, only dashboard pages will be exported and the detail table will not be exported. 2——means that when exporting, only the component details table is exported, and the entire dashboard page is not exported. |
_EXCEL_EXPORT_SHEETNAME_ |
String |
Customize the name of the dashboard page when exporting Excel |
_RESULT_NOT_EMPTY_ |
Boolean |
When the dashboard is refreshed in real time, if the execution result is empty, get data from the cache to avoid the phenomenon of empty data |
_WARNING2HINT_ |
Boolean |
When an error box appears in the dashboard, the dashboard does not pop up the dialog for prompting (you need to manually click after popping up), and changes to hint for prompting |
_MAX_ROWS_ |
String/Integer |
Control the number of data lines of the components in the dashboard, and export data is also controlled, not related to max.export.control |
_MAX_LOAD_ROWS_ |
String/Integer |
Control the number of data lines of the components in the dashboard, and export data is also controlled. Max.export.control is used as a switch to control whether the exported data is controlled |
_M_REFRESH_ |
Boolean |
Used to control whether the data set synchronized to the market is processed by the market or non-market |
_REFRESH_ |
Boolean |
Used to control whether to refresh the data every time you open the data set and dashboard |
_KEEP_EXCEL_DATA_SPAN_ |
Boolean |
Used to control whether the data has merged cells when exporting excel. When true, the exported detailed data is also retained in the merged cell. The default is false which means the cells would not be merged |
_DISABLE_AUTO_LINK_ |
Boolean |
Controls whether data content is recognized as a hyperlink |
_SELF_CTRL_PAGE_ |
Boolean |
After setting the paging of the detailed table, whether to obtain the data by adding paging when viewing. Currently, Oracle, Oracle, SQL Server, MySQL, and DB2 have automatically supported paging. For database types that are not currently supported, the data set SQL statements are as follows: select * from coffee <_PAGE_> where ID BETWEEN (?{@_PAGE_} - 1) </_PAGE_> <_PAGE_LIMIT_> * ?{@_PAGE_LIMIT_} AND </_PAGE_LIMIT_> <_PAGE_> ?{@_PAGE_} </_PAGE_> <_PAGE_LIMIT_>* ?{@_PAGE_LIMIT_} </_PAGE_LIMIT_> Use with _SELF_CTRL_PAGE_=true to realize the function of adding paging. |
_PAGE_COUNT_AYSN_ |
Boolean |
Used in conjunction with the parameter _SELF_CTRL_PAGE_, the database that has not yet realized the increase of paging has set the above increase of paging, the total number and the first page of data will be returned in one request, after setting it to true, the data will be returned by development request. |
➢E.g: Set the parameter“_EXCEL_EXPORT_TYPE_” value to 1, and then export the dashboard. There is only the dashboard page, and the details of the data is not exported, as shown below: