Get our free guides to start using Jira and Confluence Cloud like a pro.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table Filter
hideControlstrue
inversefalse,false,false
numberingDynamic Ascending
ddSeparator\u0020
sparkNameSparkline
columnType
limitHeight
disableSavetrue
separatorPoint (.)
labels‚‚
default,,
cell-width,,
userfilterFunction / Keyword
datepatterndd M yy
globalFiltertrue
id1582791256193_1352306098
worklog365|5|8|y w d h m|y w d h m
isORAND
order0,1,2


Table Excerpt
hidetrue
nameSTATUSES

Status
subtletrue
colourGreen
titleDATA_MANIPULATING

Status
subtletrue
colourGreen
titleLOGIC

Status
subtletrue
colourGreen
titleLOOP

Status
subtletrue
colourGreen
titleMATH

Status
subtletrue
colourGreen
titleAGGREGATION

Status
subtletrue
colourGreen
titleORDERING

Status
subtletrue
colourGreen
titleKEYWORD

Status
subtletrue
colourGreen
titleMERGING

Status
subtletrue
colourGreen
titleVARIABLES

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Status
subtletrue
colourGreen
titleTIME

Status
subtletrue
colourGreen
titleCONVERTING

Status
subtletrue
colourGreen
titleSEARCHING


Function / KeywordTypeDescription
ABS

Status
subtletrue
colourGreen
titleMATH

Returns the absolute (positive) value of a number
ADDDATE

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleTIME
 

Adds time values (as intervals) to a date value
ALL

Status
subtletrue
colourGreen
titleLOGIC

Returns true if all of the subquery values meet the condition
AND

Status
subtletrue
colourGreen
titleLOGIC

Includes rows where all the conditions separated by AND are TRUE
ANY

Status
subtletrue
colourGreen
titleLOGIC

Returns true if any of the subquery values meet the condition
ARRAY

Status
subtletrue
colourGreen
titleDATA_MANIPULATING

Creates an array
AS

Status
subtletrue
colourGreen
titleDATA_MANIPULATING

Renames a column or table with an alias
ASC

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleORDERING
 

Ascending sorting order
AT

Status
subtletrue
colourGreen
titleTIME


AVG

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION

Returns the average value of a group
BEGIN

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleLOOP
 

Starts code block for WHILE and IF statements
BETWEEN

Status
subtletrue
colourGreen
titleMATH

Selects values within a given range
BY

Status
subtletrue
colourGreen
titleAGGREGATION
 

Status
subtletrue
colourGreen
titleORDERING
 

Used with ORDER BY, GROUP BY
CASE

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleLOGIC
 

Creates different outputs based on conditions (see an example)
CAST

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleCONVERTING
 

Converts a value (of any type) into a specified datatype
CEIL

Status
subtletrue
colourGreen
titleMATH

Gets the smallest integer which is greater than, or equal to, the specified numeric expression
CHECK

Status
subtletrue
colourGreen
titleLOGIC

Limits the value that can be placed in a column
COALESCE

Status
subtletrue
colourGreen
titleLOGIC

Returns the first non-null value in a list
CORRESPONDING

Status
subtletrue
colourGreen
titleMERGING

Matches the columns in table-expressions by name and not by ordinal position
COUNT

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Returns the number of rows that matches a specified criteria
CONCAT

Status
subtletrue
colourGreen
titleMERGING

Concatenates values
CROSS

Status
subtletrue
colourGreen
titleMERGING

One of the Join types. Returns all rows for all possible combinations of two tables
CUBE

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Generates subtotals for all combinations of grouping columns specified in the GROUP BY clause
CURRENT_TIMESTAMP

Status
subtletrue
colourGreen
titleVARIABLES
 

Status
subtletrue
colourGreen
titleTIME
 

Returns the current timestamp of the operating system of the server on which the SQL Server Database runs
DATE

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleCONVERTING
 

A data type for storing a date (string like 'YYYYMMDD')
DATEADD

Status
subtletrue
colourGreen
titleMATH

Status
subtletrue
colourGreen
titleTIME

Adds time values (as intervals) to a date value
DATE_ADD

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleTIME
 

Adds time values (as intervals) to a date value
DATEADD

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleTIME
 

Adds time values (as intervals) to a date value
DATE_SUB

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleTIME
 

Subtracts a time/date interval from a date and then returns the date
DATEDIFF

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleTIME
 

Returns the difference between two dates
DAY

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Status
subtletrue
colourGreen
titleCONVERTING
 

Returns the day of the month for a date
DEFAULT

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleLOGIC
 

Provides a default value for a column
DESC

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleORDERING
 

Descending sorting order
DISTINCT

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Selects only distinct (different) values
ELSE

Status
subtletrue
colourGreen
titleLOGIC

Introduces another statement that is executed when the IF condition is not satisfied
END

Status
subtletrue
colourGreen
titleLOGIC

Completes code block for WHILE and IF statements
ESCAPE

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleSEARCHING
 

Equals to LIKE
ESCAPEMARKUP

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Escapes special characters for wiki markup
EXCEPT

Status
subtletrue
colourGreen
titleMERGING

Combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement
EXISTS

Status
subtletrue
colourGreen
titleLOGIC

Tests for the existence of any record in a subquery
EXP

Status
subtletrue
colourGreen
titleMATH

Returns e raised to the power of the specified number
FIRST

Status
subtletrue
colourGreen
titleAGGREGATION

Returns the first value in the group
FLOOR

Status
subtletrue
colourGreen
titleMATH

Returns the largest integer value that is smaller than or equal to a number
FORMATDATE

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Converts dates to the specified in the Table Transformer macro settings date format: FORMATDATE (calculated_date)
FORMATMARKDOWN

Status
subtletrue
colourGreen
titleFORMATTING

Applies Markdown syntax to table cells
FORMATNUMBER

Status
subtletrue
colourGreen
titleDATA_MANIPULATING

Status
subtletrue
colourGreen
titleFORMATTING

Format numbers according to the settings in the Table Transformer macro: FORMATNUMBER (calculated_number) .
FORMATTIME

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Converts time to the specified in the Table Transformer macro settings time format to the calculated time: FORMATTIME (calculated_time)
FORMATWIKI

Status
subtletrue
colourGreen
titleFORMATTING

Applies Confluence Wiki Markup to table cells
FORMATWORKLOG

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Converts worklogs to the specified in the Table Transformer macro worklog settings: FORMATWORKLOG (calculated_worklog)
FROM

Status
subtletrue
colourGreen
titleKEYWORD

Specifies which table to select or delete data from
FULL

Status
subtletrue
colourGreen
titleMERGING

FULL OUTER JOIN: returns all rows when there is a match in either left table or right table
GREATEST

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Returns the greatest value of the list of arguments
GROUP

Status
subtletrue
colourGreen
titleAGGREGATION

Groups the result set (used with aggregate functions: COUNT, MAX, MIN, SUM, AVG)
GROUPING

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Indicates whether the specified column in a GROUP BY Clause aggregated or not
HAVING

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Used instead of WHERE with aggregate functions
HOUR

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Returns the hour part of a datetime
IF

Status
subtletrue
colourGreen
titleLOGIC

Conditional statement
IFNULL

Status
subtletrue
colourGreen
titleLOGIC

Returns a specified value if the expression is NULL
IIF

Status
subtletrue
colourGreen
titleLOGIC

Accepts three arguments. It evaluates the first argument and returns the second argument if the first argument is true; otherwise, it returns the second argument
IN

Status
subtletrue
colourGreen
titleLOGIC

Allows you to specify multiple values in a WHERE clause.

INNER

Status
subtletrue
colourGreen
titleMERGING

INNER JOIN: returns rows that have matching values in both tables
INSTR

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Returns the position of the first occurrence of a string in another string
INTERSECT

Status
subtletrue
colourGreen
titleMERGING

Intersects two SELECT results
INTERVAL

Status
subtletrue
colourGreen
titleTIME

Defines a date/time interval
IS

Status
subtletrue
colourGreen
titleLOGIC


ISNULL

Status
subtletrue
colourGreen
titleLOGIC

Returns TRUE or FALSE depending on whether an expression is NULL

JOIN

Status
subtletrue
colourGreen
titleMERGING

Joins tables (see an example)
LCASE

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Converts a string to lower-case
LEAST

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Returns the smallest value of the list of arguments
LEFT

Status
subtletrue
colourGreen
titleMERGING

LEFT JOIN: returns all rows from the left table, and the matching rows from the right table
LENGTH

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Returns the length of a string (in bytes)
LIKE

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleSEARCHING
 

Searches for a specified pattern in a column
LOG

Status
subtletrue
colourGreen
titleMATH

Status
subtletrue
colourGreen
titleAGGREGATION

Returns the natural logarithm
MAX

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Takes the name of a column as an argument and returns the largest value in that column
MEDIAN

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Returns the median value of a group (see an example)
MID

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Extracts a substring from a string (starting at any position)
MIN

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Takes the name of a column as an argument and returns the smallest value in that column
MINUTE

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Returns the minute part of a datetime value
MONTH

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Returns the month part of a date
MULT

Status
subtletrue
colourGreen
titleMATH

Status
subtletrue
colourGreen
titleAGGREGATION

Takes the name of a column as an argument and returns multiplying of all the values in that column

NATURAL

Status
subtletrue
colourGreen
titleMERGING

NATURAL JOIN: analyzes columns in two joined tables and makes a join by columns with similar names
NOT

Status
subtletrue
colourGreen
titleLOGIC

Includes rows where a condition is not TRUE
NOW

Status
subtletrue
colourGreen
titleVARIABLES

Returns current date and time
NULL

Status
subtletrue
colourGreen
titleLOGIC

A field with no value
NULLIF

Status
subtletrue
colourGreen
titleLOGIC

Compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned
OF

Status
subtletrue
colourGreen
titleLOGIC

Allows you to specify multiple values in a WHERE clause
OFFSET

Status
subtletrue
colourGreen
titleSEARCHING

Skips the first N rows in a result set before starting to return any rows
ON

Status
subtletrue
colourGreen
titleMERGING


OR

Status
subtletrue
colourGreen
titleLOGIC

Includes rows where either condition is TRUE
ORDER

Status
subtletrue
colourGreen
titleORDERING

Sorts the result set in ascending or descending order
OUT

Status
subtletrue
colourGreen
titleLOGIC

Opposite to IN
OUTER

Status
subtletrue
colourGreen
titleMERGING

OUTER JOIN: returns all rows when there is a match in either left table or right table
PERCENT

Status
subtletrue
colourGreen
titleSEARCHING

Indicates that the query returns N percentage of rows
POWER

Status
subtletrue
colourGreen
titleMATH

Returns the value of a number raised to the power of another number
QUART

Status
subtletrue
colourGreen
titleMATH

Status
subtletrue
colourGreen
titleAGGREGATION

Returns the first quartile of a group
QUART2

Status
subtletrue
colourGreen
titleMATH

Status
subtletrue
colourGreen
titleAGGREGATION

Returns the second quartile of a group
QUART3

Status
subtletrue
colourGreen
titleMATH

Status
subtletrue
colourGreen
titleAGGREGATION

Returns the third quartile of a group
RANDOM

Status
subtletrue
colourGreen
titleVARIABLES


REGEXP_LIKE

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleSTRING_OPERATORS
 

Status
subtletrue
colourGreen
titleSEARCHING
 

Returns rows that match a regular expression pattern
REPLACE

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Replaces all occurrences of a substring within a string, with a new substring
RIGHT

Status
subtletrue
colourGreen
titleMERGING

RIGHT JOIN: returns all rows from the right table, and the matching rows from the left table
ROLLUP

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Creates subtotals and grand totals for a set of columns (GROUP BY ROLLUP)
ROUND

Status
subtletrue
colourGreen
titleMATH

Rounds a number to a specified number of decimal places
ROWNUM

Status
subtletrue
colourGreen
titleDATA_MANIPULATING

Adds row numbering to a table
SECOND

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Return the seconds part of a datetime value
SELECT

Status
subtletrue
colourGreen
titleDATA_MANIPULATING

Selects data from a database
SOME

Status
subtletrue
colourGreen
titleLOGIC

Compares a value to each value in a list or results from a query and evaluates to TRUE if the result of an inner query contains at least one row
SQRT

Status
subtletrue
colourGreen
titleMATH

Returns the square root of a number
STDDEV

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Returns the population standard deviation of expression (see an example)
STDEV

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Returns the sample standard deviation of expression (see an example)
SUBDATE

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleTIME
 

Subtracts a time/date interval from a date and then returns the date
SUBSTR

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Extracts a substring from a string (starting at any position)
SUBSTRING

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Allows to extract a substring from a string
SUM

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Takes the name of a column as an argument and returns the sum of all the values in that column (see an example)
THEN

Status
subtletrue
colourGreen
titleLOGIC

A result expression in a search condition
TIME

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Extracts the time part from a given time/datetime

Status
subtletrue
colourGreen
titleCONVERTING

Returns a datetime value based on a date or datetime value

TO

Status
subtletrue
colourGreen
titleKEYWORD


Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Removes the space character or other specified characters from the start or end of a string
UCASE

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Converts a string to upper-case
UNION

Status
subtletrue
colourGreen
titleMERGING

Combines the result set of two or more SELECT statements (only distinct values)
UPPER

Status
subtletrue
colourGreen
titleSTRING_OPERATORS

Converts a string to upper-case
USING

Status
subtletrue
colourGreen
titleLOGIC

Matches only one column when more than one column matches
VAR

Status
subtletrue
colourGreen
titleMATH
 

Status
subtletrue
colourGreen
titleAGGREGATION
 

Returns the statistical variance of all values in the specified expression
VAR_POP

Status
subtletrue
colourGreen
titleAGGREGATION

Population variance. Returns 0 if all of the values in the data set have the same value (no variability). Returns 0 if the data set consists of only one value (no possible variability). Returns NULL if the data set has no values
VAR_SAMP

Status
subtletrue
colourGreen
titleAGGREGATION

Sample variance. Returns 0 if all of the values in the data set have the same value (no variability). Returns NULL if the data set consists of only one value (no possible variability). Returns NULL if the data set has no values
VARCHAR

Status
subtletrue
colourGreen
titleKEYWORD

Accepts character strings of a variable length is up to the maximum length specified in the data type declaration
VARP

Status
subtletrue
colourGreen
titleAGGREGATION

Returns the Variance for the population of the total number of records present in the specified column
WEEKDAY

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Returns the weekday number for a given date
WHEN

Status
subtletrue
colourGreen
titleLOGIC

A condition expression in a search condition
WHERE

Status
subtletrue
colourGreen
titleLOGIC
 

Status
subtletrue
colourGreen
titleSEARCHING
 

Filters a result set to include only records that fulfill a specified condition
WHILE

Status
subtletrue
colourGreen
titleLOOP

Sets a condition for the repeated execution of an SQL statement or statement block
YEAR

Status
subtletrue
colourGreen
titleDATA_MANIPULATING
 

Status
subtletrue
colourGreen
titleTIME
 

Returns an integer value which represents the year of the specified date
FALSE

Status
subtletrue
colourGreen
titleLOGIC

Logical false value
TRUE

Status
subtletrue
colourGreen
titleLOGIC

Logical true value


...