FQL function reference

condition1 and condition2

value1 > 18 and value1 < 100 -> true
value1 > 18 and value1 > 100 -> false

condition1 or condition2

value1 < 18 or value1 < 100 -> true
value1 < 18 or value1 > 100 -> false

$assert($cond: bool, $msg: string) => error

$assert(user.age <18, “error: user can’t vote!“)

$average($array: array<num>) =< number

$average([1,2,3,4,5]) -> 3

$boolean($arg: any) => bool

$boolean(0) ->  false$boolean(10) ->  true
$boolean("") ->  false$boolean(“abc”) ->  true

$contains($str: string, $pattern: string | regex) => bool

$contains("hello, world", "lo") -> true$contains(“hello world”, “ab”) -> false

$decodeUrl($val: string) => string

$decodeUrl(“https://mozilla.org/?x=%D1%88%D0%B5%D0%BB%D0%BB%D1%8B”) -> “https://mozilla.org/?x=шеллы”

$decodeUrlComponent($val: string) => string

$decodeUrlComponent(“%3Fx%3Dtest”) -> “?x=test”

$each($obj: object, func: ($val,$key) : any)

$encodeUrl($val: string) => string

$encodeUrl(“https://mozilla.org/?x=шеллы”) -> “https://mozilla.org/?x=%D1%88%D0%B5%D0%BB%D0%BB%D1%8B”

$encodeUrlComponent($val: string) => string

$encodeUrlComponent(“?x=test”) -> “%3Fx%3Dtest”

$eval($val:string) => any

$eval("[1,$string(2),3]”) -> [1,“2”,3]

$exists($val: any) => bool

$filter($arr: array, $func: ($e, $index?: number?,$ar: array )=> boolean) => array

$filter([1,2,3,4,5], fn($e){ $e>3}) -> [4, 5]

$join(["hello", "world"]) -> "helloworld"$join([“hello”, “world”], ”-”) → “hello-world”
$join([1,2,3], ”..”) -> “1..2..3”

$json($val:any) => string

$jsonParse($val:string) => object

$length($str: string) => number

$lookup($obj: object, $key: string) => any

$lowercase($str: string) => string

$lowercase(“Hello World”) -> “hello world”

$map($arr: array, $func: ($e, $index?: number?,$ar: array ) : array

$map([1,2,3,4,5], fn($e){ $e *2}) -> [2,4,6,8,10]

$max($array) => number

$max([9,2,17,3]) -> 17

$not($x: any) => bool

$not(true) -> false$not(false) -> true
$not(null) -> true$not(0) -> true
$not(100) -> false$not("") -> true
$not(“hello”) -> false

$pad($str: string, $length: number,$pad?: string) => string

$pad("example", 5) -> "example  "$pad(“example”, 5, ”-”) -> “example—“

$partition($array:any, $n: numbers) => array

$partition([1,2,3,4,5,6,7,8,9,10], 2) -> [[1,2], [3,4], [5,6], [7,8], [9,10]]$partition([1,2,3,4,5,6,7,8,9,10], 3) -> [[1,2,3], [4,5,6], [7,8,9], [10]]

$replace($str: string, $pattern: string | regex,$replacement: string) => string

$string($value: any, $prettify? true | false) => string

$substring($str: string, $start: number,$length?: number) => string

$substring("hello world", 0, 5) -> "hello"$substring(“hello world”, -5, 5) -> “world”

$substringAfter($str: string, $separator: string) => string

$substringAfter(“abc@gmail.com”, ”@”) -> “gmail.com”

$substringBefore($str: string, $separator: string) => string

$substringBefore( “john@gmail.com”, ”@”) -> “john”

$sum($array) => number

$sum([1,2,3,4]) -> 10

$trim($str: string) => string

$trim(” Hello \n World ”) -> “Hello World”

$type($val: any) => string

$type("hello") -> "string"$type(1) -> “number”
$type({}) -> "object"$type([]) -> “array”
$type(null) -> “null”

$uppercase($str: string) => string

$uppercase(“hello”) -> “HELLO”

$uuid => string

$uuid -> “503c5a9f-b8fb-402a-b0d7-fae17490bdf6”

$append($arr: array, $val: any) => array

$append([1,2,3], [5,6]) -> [1,2,3,4,5,6]$append([1,2,3], 5) -> [1,2,3,5]

$count($array) => number

$count([1,2,3,4,5]) -> 5$count([]) -> 0

$distinct($arr: array) => array

$distinct([“a”, “b”, “b”, “c”]) -> [“a”, “b”, “c”]

$reverse($arr: array) => array

$reverse([1,2,3,4,5]) -> [5,4,3,2,1]

$shuffle($arr: array) => array

$shuffle([1,2,3,4]) -> [3,1,4,2]

$sort($arr: array, $swapFn: ($l, $r)) => boolean

$sort([13,2,8,6,15], fn($l, r) { l > r }) -> [2,6,8,13,15]
sort([13,2,8,6,15], fn($l,$r) { $l < $r }) -> [15,13,8,6,2]

$zip($ar1:Array, $ar2:Array,$ar3;Array, …) => Array

$zip([1,2,3],[4,5,6]) -> [[1,4],[2,5],[3,6]]

$abs(n:number) : number

$abs(-1) -> 1

$acos($num: number) => number

$acos(1) -> 0

$acosh($num: number) => number

$acosh(1) -> 0

$asin($num: number) => number

$asin(1) -> 1.5707963267948966

$asinh($num: number) => number

$asinh(1) -> 1.5707963267948966

$atan($num: number) => number

$atan(1) -> 0.7853981633974483

$atanh($num: number) => number

$atanh(1) -> inf

$atan2($x: number, $y: number) => number

$atan2(-1, -1) -> -2.356194490192345

$cbrt($num: number) => number

$cbrt(27) -> 3

$ceil($num: number) => number

$ceil(3.4) -> 4

$constant($name: string ) => number

$constant(‘e’) -> 2.718281828459045

$cos($num: number) => number

$cos(1) -> 0.5403023058681398

$cosh($num: number) => number

$cosh(1) -> 1.5430806348152437

$exp($num: number) => number

$exp(16) -> 8886110.520507872

$floor($num: number) => number

$floor(3.4) -> 3

$formatBase($num: number, $base?: number) => string

$formatBase(100, 2) -> “1100100”

$isFinite($num: number ) => number

$isFinite(1) -> true$isFinite(inf) -> false

$log($num: number) => number

$log(16) -> 2.772588722239781

$log10($num: number) => number

$log10(16) -> 1.2041199826559248

$log2($num: number) => number

$log2(16) -> 4

$number($x: string | number | bool) => number

$number("-0.05") -> -0.05$number(false) -> 0
$number(true) -> 1

$power($num: number, $exp: number) => number

$power(2, 3) -> 8$power(3,4) -> 81

$round($num: number, $precision?: number) => number

$round(123.456) -> 123$round(123.456, 2) -> 123.46
$round(123.456, -1) -> 120$round(123.456, -2) -> 100
$round(125, -1) -> 120$round(125.456,-1) -> 130

$sin($num: number) => number

$sin(1) -> 0.8414709848078965

$sinh($num: number) => number

$sinh(1) -> 1.1752011936438014

$sqrt($num: number) => number

$sqrt(16) -> 4

$tan($num: number) => number

$tan(1) -> 1.5574077246549023

$tanh($num: number) => number

$tanh(1) -> 0.7615941559557649

$afterDate($timestamp1: string |number, $timestamp2: string |number) => boolean

$afterDate("2023-02-09", "2023-02-08") -> true$afterDate(“2023-02-08”, “2023-02-08”) -> false

$beforeDate($timestamp1: string |number, $timestamp2: string |number) => boolean

$beforeDate("2023-02-07", "2023-02-08") -> true$beforeDate(“2023-02-08”, “2023-02-08”) -> false

$dateEquals($timestamp1: string |number, $timestamp2: string |number) => boolean

$dateEquals("2023-02-08", "2023-02-08") -> true$dateEquals(“2023-02-08”, “2023-02-07”) -> false

$datePlus($timestamp1: string |number, $duration: number,$units, ) => number

$datePlus("2023-02-07", 2, "days") -> 1675900800000$datePlus(“2023-02-07”, 2, “months”) -> 1680825600000

$day($timestamp: string |number) => number

$day(“2023-02-08”) -> 8

$dayOfTheWeek($timestamp: string |number) => number

$dayOftheWeek("2023-02-08") -> 3$dayOftheWeek(“2023-02-07”) -> 2

$diffDate($timestamp1: string |number, $timestamp2: string |number,$units : string, ) => number

$diffDate("2023-02-08", "2023-01-22", "days") -> 17$diffDate(“2023-02-08”, “2023-01-22”,“hours”) -> 408

$fromMillis($val:number, $picture?: string) => string

$fromMillis(1521801216617, "dd/M/yyyy") -> "23/3/2018"$fromMillis(1522616700000, “E EEEE”) -> “7 Sunday”

$hours(“2023-02-08T07:56:14.747+00:00”) -> 7

$milliSeconds($timestamp: string |number) => number

$milliSeconds(“2023-02-08T07:56:14.747+00:00”) -> 747

$minutes($timestamp: string |number) => number

$minutes(“2023-02-08T07:56:14.747+00:00”) -> 56

$month($timestamp: string |number) => number

$month(“2023-02-08”) -> 2

$seconds($timestamp: string |number) => number

$seconds(“2023-02-08T07:56:14.747+00:00”) -> 14

$toMillis($val:string, $picture?: string) => number

$toMillis("1970-01-01T00:00:00.001Z")  -> 1$toMillis(“2018-03-27”, “yyyy-MM-dd”) -> 1522108800000
$toMillis(“21 August 2017”, “dd MMMM yyyy”) -> 1503273600000

$year($timestamp: string |number) => number

$year(“2023-02-08T07:56:14.747+00:00”) -> 2023