System Parameter

<< Click to Display Table of Contents >>

Current:  Parameter 

System Parameter

Previous pageReturn to chapter overviewNext page

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:

excelexportclip1

 

excelexportclip2