Task Schedule with Supported Formulas

parameter

User global parameters:

${ fine_username }

${ fine_position }

${ fine_role }

${ fr_username }

${ fr_userposition }

${ fr_authority }

It cannot be   used during the timed scheduling task setting process

User global   parameters can be used when adding SQL datasets

Common   functions

SUM, COUNT,   AVERAGE, CHAR, DATE, MAX, MIN, TIME, RANGE

dispatch object - file name

Scheduling Period - Execution   Conditions - Formula Judgment

File Handling - Email Notification -   Subject and Content

File Handling - Client Notification -   Subject and Content

Do not add ${} in "Scheduling   Period - Execution Condition - Formula Judgment", and add $ {} in other cases

For example, AND(1+7=8,5+7=12) should be written as ${AND(1+7=8,5+7=12)} in timing scheduling , do not add = sign

Math and   Trigonometry

ABS, ACOS,   ACOSH, ASIN, ASINH, ATAN, ATAN2, AVERAGE, CEILING, COMBIN, COS, SOSH, COUNT,   DECIMAL, DEGREES, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MAX, MIN, MOS,   ODD, PI, POWER, PRODUCT, PROMOTION, RADIANS, RAND, RANDB ETWEEN, ROUND,   ROUND5, ROUNDDOWN, ROUNDUP, SIGN, SIN, SINH, SQRT, SUM, SUMPRECISE, SUMSQ,   TAN, TANH, TOBINARY, TOHEX, TOOCTAL , TRUNC, WEIGHTEDAVERAGE

text function

CHAR, CNMONEY,   CODE, CONCATENATE, ENDWITH, ENMONEY, ENNUMBER, EXACT, FIND, FORMAT, INDEXOF,   LEFT, LEN, LOWER, MIN, NUMTO, PROPER, REGEXP, REPEAT, REPLACE, RIGHT, SPLIT,   STARTWITH, SUBSTITUTE, TODOUBLE, TOINTEGER, TRIM, UPPER

date and time   functions

DATE,   DATEDELTA, DATEDIF, DATEINMONTH, DATEINQUARTER, DATEINWEEK, DATEINYEAR,   DATESUBDATE, DATETONUMBER, DAY, DAYS360, DAYSOFMONTH, DAYSOFQUARTER,   DAYSOFYEAR, DAYVALUE, HOUR, LUNAR, MINUTE, MONTH, MONTHDELTA, NOW, SECOND,   TIME, TODATE, TODAY, WEEK, WEEKDATE, WEEKDAY, YEAR, YEARDELTA

Logical   function

AND, BITNOT,   BITOPERATION, IF, OR, REVERSE, SWITCH

array function

ADD2ARRAY,   ARRAY, GREPARRAY, INARRAY, INDEXOFARRAY, JOINARRAY, MAPARRAY, RANGE,   REMOVEARRAY, REVERSEARRAY, SLICEARRAY, SORTARRAY, UNIQUEARRAY

report function

COL, DECODE,   ENCODE, I18N, ROW, COLCOUNT, COLNAME, FIELDS, MAP, RECORDS, ROWCOUNT, SQL,   TABLEDATAFIELDS, TABLEDATAS, TABLES, VALUE

dispatch object - file name

Scheduling Period - Execution   Conditions - Formula Judgment

File Handling - Email Notification -   Subject and Content

File Handling - Client Notification -   Subject and Content

1) COL and ROW are written in the cell, although no error will be reported in   timing scheduling, but it is meaningless, and the return value is the   constant 0.

COL() returns the column number of the current cell.

For example, if the current cell is   A5, write in A5: =col() , return 1; if the current cell is C6,   write in A5: =col() , return 3

2) The parameters of COLCOUNT , COLNAME , MAP , ROWCOUNT , TABLEDATAFIELDS , and VALUE include data sets. In timing   scheduling, you can get server data sets

other functions

WEBIMAGE,   CLASS, CORREL, EVAL, INDEX, ISNULL, LET, MEDIAN, NVL, QUERY, RANK, SEQ, UUID,   LUNAR

dispatch object - file name

Scheduling Period - Execution   Conditions - Formula Judgment

File Handling - Email Notification -   Subject and Content

File Handling - Client Notification -   Subject and Content

1) Although SEQ is executed, it is always only once, so the value is always,   meaningless

2) WEBIMAGE is   used to   display pictures on web pages, and returns a format similar to com.fr.file.WebImage@23dd10da in timing scheduling

custom function

UBM, SUBSECTION

dispatch object - file name

Scheduling Period - Execution   Conditions - Formula Judgment

File Handling - Email Notification -   Subject and Content

File Handling - Client Notification -   Subject and Content

The function that takes the cell value   cannot be used in FineBI