Custom Parameter (Static Parameter)

Version

Application Scenario

In the business process, sometimes you need to configure parameters according to the actual business situation to facilitate subsequent data processing and development. FineDataLink allows you to customize parameters, which can be directly referenced in Data Development.

Function Description

You can add task parameters (namely, custom parameters) on the Parameter List page. The defined parameters can be referenced in the current task, as shown in the following figure.

• The ${} symbol is not allowed in parameter names and values.

• The task parameters you added belong only to the current task.

• If the parameter is of integer, double, or Boolean type, reference the parameter directly using ${Parameter name}.

• If the parameter value is of character or date type, it must be enclosed in single quotes ('') in the form of '${Parameter name}'.

Customize a time parameter by increasing or decreasing the value of the built-in parameter ${cyctime} in a format of ${Time format + N} or ${Time format - N}.

You can flexibly combine yyyy, yy, mm, dd, hh, mi, and ss to form the time format such as yyyy, mm, dd, yyyymm, mmdd, yyyymmdd, yyyy-mm-dd, and yyyy-mm-dd hh:mi:ss.

Note:

The following parameter formats are not supported: mi:ss, mi, and ss.

For example, you can use yyyy-2 to customize a time parameter para_time, whose value defaults to the year two years before the year in the ${cyctime} value, as shown in the following figure.

Note:

The parameter is of the Date type by default.

A simple example of defining a time parameter is as follows:

1. Create an ETL task, and customize a para_time parameter with a default value of yyyy-mm-1 (the month before the value of ${cyctime}), as shown in the following figure.

Note:

Set the format of the parameter value consistent with that of the time field in the SQL statement. For example, if the value of the date field (to be used in SQL queries) is in the format of yyyy-mm-dd, the format of the parameter value should be set to yyyy-mm-1, instead of yyyy/mm-1..

2. Drag a Data Synchronization node to the design page, configure the data source, and enter SQL statements to fetch data with values of the Ordertime field earlier than the value of the para_time parameter.

3. Click Data Preview. The data where the Ordertime field value is at least one month earlier than the execution time has been fetched, as shown in the following figure.

In addition to customizing time parameters, you can also customize constant parameters, which can be numbers or text.

The following constant parameter types are supported: Text, Value, and Boolean.

The following is an example of defining constant parameters.

1. Create a scheduled task, and define a text-type parameter para_a whose value defaults to Sales Manager and Sales Representative. Separate parameter values by comma (,), as shown in the following figure.

2. You can use this parameter for SQL queries in other nodes. For example, you can use it in the Data Synchronization node to fetch data where the value of the Position field is Sales Manager or Sales Representative, as shown in the following figure.

3. Click Data Preview to view the fetched data. 

When the parameter type is Text, pay attention that:

• If the parameter includes a single value, enter the text directly in the Parameter Value bar. Enclose the parameter in single quotes (for example, '${a}') when using it.

• If the parameter includes multiple values, enclose each value in single quotes and separate values by comma (for example, 'apple','banana'). You do not need to add single quotes ('') when using the parameter.