| Both sides previous revisionPrevious revision | |
| en:help:v2:maps:on-demand-create [2025/06/16 10:32] – psyberia | en:help:v2:maps:on-demand-create [2025/06/24 18:24] (current) – new function as of 2.4.0 psyberia |
|---|
| | ''**^**'' | Power operator. | | | ''**^**'' | Power operator. | |
| | ''**==**'' | Equal to operator (also used for string). | | | ''**==**'' | Equal to operator (also used for string). | |
| | ''**!=**'' <sup>1</sup> | Not equal to operator (also used for string). | | | ''**!=**'' | Not equal to operator (also used for string). | |
| | ''**>**'' | Greater than operator. | | | ''**>**'' | Greater than operator. | |
| | ''**> =**'' | Greater than or equal to operator. | | | ''**> =**'' | Greater than or equal to operator. | |
| | ''**< <**'' | Signed left shift operator. | | | ''**< <**'' | Signed left shift operator. | |
| | ''**> >**'' | Signed right shift operator. | | | ''**> >**'' | Signed right shift operator. | |
| <sup>1. Available from AQ 2.2.8c</sup> | |
| |
| |
| | ''**hypot**(double,double)'' | ''double'' | Returns ''sqrt(x²+y²)'' without intermediate overflow or underflow. | | | ''**hypot**(double,double)'' | ''double'' | Returns ''sqrt(x²+y²)'' without intermediate overflow or underflow. | |
| | ''**iif**(double,mixed,mixed)'' | ''mixed'' | If the first parameter is different from ''0.0'', return the second parameter, else the third one. | | | ''**iif**(double,mixed,mixed)'' | ''mixed'' | If the first parameter is different from ''0.0'', return the second parameter, else the third one. | |
| | | ''**indexOf**(string,string)'' | ''long'' | Returns the position of the first occurrence of the second parameter inside the first parameter. | |
| | | ''**lastIndexOf**(string,string)'' | ''long'' | Returns the position of the last occurrence of the second parameter inside the first parameter. | |
| | ''**len**(string), **length**(string)'' | ''long'' | Returns the length of a string. | | | ''**len**(string), **length**(string)'' | ''long'' | Returns the length of a string. | |
| | ''**ln**(double)'' | ''double'' | Returns the natural logarithm (base ''e'') of a double value. | | | ''**ln**(double)'' | ''double'' | Returns the natural logarithm (base ''e'') of a double value. | |
| | ''**log**(double)'' | ''double'' | Returns the base 10 logarithm of a double value. | | | ''**log**(double)'' | ''double'' | Returns the base 10 logarithm of a double value. | |
| | | ''**lower**(string)'' | ''string'' | Returns parameter as lower case. | |
| | ''**md5**(string)'' | ''string'' | Returns the [[https://en.wikipedia.org/wiki/MD5|MD5 hash]] of the string parameter. | | | ''**md5**(string)'' | ''string'' | Returns the [[https://en.wikipedia.org/wiki/MD5|MD5 hash]] of the string parameter. | |
| | ''**not**(double)'' | ''long'' | If the parameter is different from ''0.0'', return ''0'', else return ''1''. | | | ''**not**(double)'' | ''long'' | If the parameter is different from ''0.0'', return ''0'', else return ''1''. | |
| | ''**round**(double)'' | ''long'' | Returns the closest long to the argument, with ties rounding to positive infinity. | | | ''**round**(double)'' | ''long'' | Returns the closest long to the argument, with ties rounding to positive infinity. | |
| | ''**sha1**(string)'' | ''string'' | Returns the [[https://en.wikipedia.org/wiki/SHA-1|SHA-1 hash]] of the string parameter. | | | ''**sha1**(string)'' | ''string'' | Returns the [[https://en.wikipedia.org/wiki/SHA-1|SHA-1 hash]] of the string parameter. | |
| | ''**sin**(double)'' <sup>1</sup> | ''double'' | Returns the trigonometric sine of an angle. | | | ''**sin**(double)'' | ''double'' | Returns the trigonometric sine of an angle. | |
| | ''**sqrt**(double)'' | ''double'' | Returns the correctly rounded positive square root of a double value. | | | ''**sqrt**(double)'' | ''double'' | Returns the correctly rounded positive square root of a double value. | |
| | ''**substr**(string,long)'' | ''string'' | Returns a string that is a substring of the string given in the first parameter. The substring begins with the character at the index specified by the second parameter and extends to the end of the string. | | | ''**substr**(string,long)'' | ''string'' | Returns a string that is a substring of the string given in the first parameter. The substring begins with the character at the index specified by the second parameter and extends to the end of the string. | |
| | ''**unixtime**()'' | ''long'' | Returns the current time in seconds. | | | ''**unixtime**()'' | ''long'' | Returns the current time in seconds. | |
| | ''**unixtime**(long)'' | ''long'' | If the parameter is ''1'', returns the current time in milliseconds, otherwise returns the current time in seconds. | | | ''**unixtime**(long)'' | ''long'' | If the parameter is ''1'', returns the current time in milliseconds, otherwise returns the current time in seconds. | |
| | | ''**upper**(string)'' | ''string'' | Returns parameter as upper case. | |
| | ''**valueAt**(long,mixed...)'' | ''mixed'' | Returns the value at the index (starting from zero after the first parameter) specified by the first parameter. | | | ''**valueAt**(long,mixed...)'' | ''mixed'' | Returns the value at the index (starting from zero after the first parameter) specified by the first parameter. | |
| <sup>1. Available from AQ 2.2.8c</sup> | |
| |
| \\ | \\ |
