Skip to content
Docs
Initializing search
Home
Architecture
Center
Web
Relay
Data & Connectivity
Security
Operations
Reference
Docs
AMI Documentation
Home
Home
Getting Started
Getting Started
First Time Setup
Where Next
Supported Software
Contact Support
Architecture
Architecture
Upgrading 3forge
Source & Version Control
Multiple Environments
OMAS
WebManager & WebBalancer
Center Replication
Center Subscription
Scaling
Java Plugins
Center
Center
Realtime Tables
Historical Tables
Indexes
Triggers
Timers
Procedures
Methods
Tools
Custom Center Objects
Database Objects
Web
Web
Structuring Layouts
Structuring Layouts
Windows
Tabs
Dividers
Multiple Layouts
Panels
Panels
Tables
Trees
Charts
HTML
Other Panels
Relationships
Datamodels
Styling
Styling
Managing Styles
Tables
Trees
Users & Sessions
Callbacks
Transient Objects
Merge Tool
Spreadsheets
XML
Common Visualizations
Common Visualizations
Grouped Bar Chart
Multi Line Chart
Transpose Table
Dynamic Aggregation Table
Pivot Table
CRUD Table
Breadcrumb Filter
Super Filter
Data In Forms
Using AmiScript
Tools
Interoperability
Custom DNS
Custom HTML & JavaScript
None
Relay
Relay
Custom Relay Plugin
Data & Connectivity
Data & Connectivity
gRPC
B-PIPE Plugin
3forge REST Server
LoadFile
Datasource Adapters
Datasource Adapters
AMPS
Historical and Reference Bloomberg Data
Deephaven
Excel
Flat File
MongoDB
Parquet
Redis
REST
Shell & SSH
Snowflake
Custom Datasource Adapter
Feed Handlers
Feed Handlers
AWS SQS
Deephaven
Hazelcast
Kafka
KDB
Solace
TIBCO EMS
TIBCO Streambase
IBM Message Queue
Custom Feed Handler
AMI Client
AMI Client
Java Client
Python Client
.NET Client
OpenFin
Email and Calendar
Security
Security
Authentication
Authentication
OAuth
SAML
LDAP
Custom Authentication
Custom Entitlements
Data Filter
Encryption
Encryption
External Vaults
Properties Files
Center Tables
User Passwords
SSL
Custom Encryption
Operations
Operations
Configuration Guide
Configuration Guide
Common Properties
Center Properties
Web Properties
Relay Properties
WebManager & WebBalancer Properties
Advanced Setup
Advanced Setup
Instructions for SSL/TLS
Running 3forge with Docker
Running 3forge with Kubernetes
Running 3forge on a Distributed Kubernetes Cluster
Troubleshooting
Troubleshooting
f1 Console
Startup Failure
Security Warnings
Logs
Memory Overload
Timeouts
Reference
Reference
AmiScript
AmiScript
Language
String Templating
SQL Querying
Datasource Access
Schema and Data Modification
AmiScript: Custom Classes
Realtime Messages
Cheatsheets
Cheatsheets
AMIScript: Scripting
AMIScript: SQL
Security
Text Matching
AmiScript API
AmiScript API
Classes
Classes
BigDecimal
BigInteger
Binary
BlankPanel
Boolean
Byte
Calendar
Callback
Character
ChartPanel
ChartPanelAnnotation
ChartPanelAxis
ChartPanelCrosshair
ChartPanelLayer
ChartPanelLegend
ChartPanelPlot
ChartPanelRadialLayer
ChartPanelXYLayer
CodeCoverage
Collection
ColorGradient
CommandResponse
Comparable
Complex
Context
DashboardResource
Datamodel
DatamodelEditor
Date
Debugger
DecorateProcessor
DecorateProcessorIndex
DevTools
DispatchJob
DividerPanel
Double
Error
FileSystem
FilterPanel
Float
FormButtonField
FormCheckboxField
FormColorPickerField
FormDateField
FormDateRangeField
FormDateTimeField
FormDivField
FormField
FormGradientColorPickerField
FormImageField
FormMultiCheckboxField
FormMultiSelectField
FormPanel
FormPasswordField
FormRadioField
FormRangeSliderField
FormRelationshipButton
FormSelectField
FormSliderField
FormSwitchField
FormTextField
FormTextareaField
FormTimeField
FormTimeRangeField
FormTitleField
FormToggleButtonField
FormUploadField
Formula
FormulaSetEditor
HeatmapPanel
ICalendar
Image
Integer
Iterable
Iterator
JsonSettingsEditor
KeyEvent
Layout
LimitProcessor
List
Long
Map
MenuItem
MouseEvent
Number
Object
Panel
PanelEditor
Password
Point
Processor
Rand
RealtimeAggTablePanel
RealtimeEvent
RealtimeTablePanel
Rectangle
Relationship
RelationshipClause
Row
RpcRequest
RpcResponse
ScrollPanel
Session
Set
Short
SsoSession
StaticTablePanel
String
StringBuilder
StyleOptionDefinition
StyleSet
SubscribeProcessor
SurfacePanel
SurfacePanelAxis
SurfacePanelLayer
Tab
Table
TablePanel
TablePanelColumn
TablePanelColumnFilter
TablePanelColumnGrouping
TableSet
TabsPanel
TextEditor
TransposeProcessor
TreePanel
TreePanelColumn
TreePanelColumnGrouping
TreePanelGrouping
UTC
UTCN
UUID
VisualizationEditor
Window
XmlBuilder
XmlElement
XmlParser
XmlText
ZipBuilder
Methods
Methods
abs(value)
acos(value)
asin(value)
atan(value)
base64Encode(data)
binaryLen(data)
binaryToStr(data)
binaryToStr16(data)
binaryToStr64(data)
binaryToStr64Safe(data)
bitAnd(a,b)
bitOr(a,b)
bitShiftLeft(n,shiftAmount)
bitShiftRight(n,shiftAmount)
bitShiftRightUnsigned(n,shiftAmount)
bitwiseXor(a,b)
brighten(color,pctChange)
cksum(first,additional)
clrGetAlpha(color)
clrGetBlue(color)
clrGetGreen(color)
clrGetHue(color)
clrGetLum(color)
clrGetRed(color)
clrGetSat(color)
clrSetHsl(color,hue,saturation,luminance)
clrSetRgb(color,red,green,blue)
colorCycle(offset)
contrast(color,background)
cos(radians)
cycle(offset,choices)
datePart(unixEpochMillis,part,timezone)
datePartNum(unixEpochMillis,part,timezone)
decodeDouble64(value)
decodeFloat64(value)
diffSequence(l,r,lcol,rcol,options)
digamma(x)
encodeDouble64(value)
encodeFloat64(value)
eval(expression,variables)
exp(x)
formatDate(unixEpoch,pattern,timezone)
formatNumber(value,format,options)
formatNumberCompact(value)
getBestImageType(hexColor)
getContext()
getRawJavaStackTrace()
gradient(value,value1,color1,value2,color2,moreNumbersAndColors)
isSanitized(expression,vars,methods)
jsonExtract(json,xpath)
ln(value)
lnGamma(x)
log(Value,Base)
logInfo(message)
logWarn(message)
maximum(o)
minimum(o)
noNull(value1,value2,additionalValues)
parseCsv(text,firstLineIsHeader)
parseDate(text,format)
parseDate(text,format,timezone)
parseDateNano(text,format)
parseDateNano(text,format,timezone)
parseInt(num,radix)
parseJson(legalJson)
parseListOfMaps(mapsToParse,fields)
parseRawXlsx(data)
parseStats(text,tableNames)
parseXls(data,firstLineIsHeader)
parseXls(data,firstLineIsHeader,tableName)
parseXls(data,firstLineIsHeader,tableName,classes)
parseXls(data,firstLineIsHeader,tableName,classes,dimensions)
parseXlsx(data,firstLineIsHeader)
parseXlsx(data,firstLineIsHeader,tableName)
parseXlsx(data,firstLineIsHeader,tableName,classes)
parseXlsx(data,firstLineIsHeader,tableName,classes,dimensions)
percentChange(old,nuw)
percentDiff(a,b)
power(value,exponent)
quote(text)
rand()
rand(range)
randGaussian()
randSec()
randSec(range)
randSecGaussian()
round(value)
round(value,precision)
roundDown(value)
roundNearest(value,bucketSize)
roundNearestDown(value,bucketSize)
roundNearestUp(value,bucketSize)
roundUp(value)
scale(value,source1,target1,source2,target2,moreSourcesAndTargets)
signDataMac(data,key,algorithm)
sin(radians)
sleepMillis(millisToSleep)
splitLines(text)
strAfter(text,toFind,origIfNotFound)
strAfterLast(text,toFind,origIfNotFound)
strBefore(text,toFind,origIfNotFound)
strBeforeLast(text,toFind,origIfNotFound)
strCharAt(text,pos)
strCut(text,delim,fieldList)
strDecodeBytes(data)
strDecodeBytes(data,encoding)
strDistanceLev(left,right,ignoreCase)
strEncodeBytes(str)
strEncodeBytes(str,encoding)
strEndsWith(text,toFind,ignoreCase)
strEqualsIgnoreCase(left,right)
strIndexOf(text,toFind)
strIndexOf(text,toFind,start,ignoreCase)
strIs(text)
strIsnt(text)
strJoin(delimiter,associator,data)
strJoin(delimiter,data)
strLastIndexOf(text,toFind)
strLastIndexOf(text,toFind,last,ignoreCase)
strLen(text)
strLower(text)
strMatchesFilter(text,pattern)
strParseLong(text,base)
strRepeat(text,count)
strReplace(text,find,replace)
strSplice(text,start,charsToReplace,replacement)
strSplit(text,delim)
strSplitLines(text)
strSplitToMap(text,delim,associatorDelim)
strStartsWith(text,toFind,ignoreCase)
strStrip(text,prefix,suffix)
strSubstring(text,start,end)
strToBinary(text,base)
strTrim(text)
strUpper(text)
switch(key,defaultValue,keyValueChoices)
systemNano()
tan(radians)
timestamp()
timestampNano()
timezoneOffset(unixEpochMillis,timezone)
toHex(num)
toJson(mapListOrLiteral,isCompact)
urlDecode(url)
urlDecode(url,encoding)
urlEncode(url)
urlEncode(url,encoding)
urlPath(url)
verifyMac(data,key,algorithm,mac)
version()
versionDetails()
versionMap()
Aggregate Methods
Aggregate Methods
avg(value)
avgExp(value,decay,desc)
avgGauss(value,variance)
beta(value1,value2)
cat(value,delim,limit)
catUnique(value,delim)
catUniqueAsc(value,delim)
catUniqueDes(value,delim)
catUniqueLimit(value,delim,limit)
catUniqueLimitAsc(value,delim,limit)
catUniqueLimitDes(value,delim,limit)
cksumAgg(value)
cor(value1,value2)
count(value)
countUnique(value)
covar(value1,value2)
covarS(value1,value2)
first(value)
last(value)
linRegPoly(target,values)
linearRegression(value)
max(value)
median(value)
min(value)
mode(value)
percentileCont(value,percent)
percentileDisc(value,percent)
stdev(value)
stdevS(value)
sum(value)
var(value)
varS(value)
Prepare Methods
Prepare Methods
count(value)
dnorm(value)
emGmmCluster(nClusters,seed,values)
interpolate(x,y,method)
kmeansCluster(nClusters,seed,values)
lastNotNull(value)
movingAvg(value,sampleSize,options)
norm(value)
offset(value,offset)
rank(value)
resample(x,y,xq,linearOrSpline)
segmentByLocalExtrema(x,y,dx,dataFilterLength,derivedFilterLength)
shuffle(value)
stack(value)
unique(value)
urank(value)
viGmmCluster(nClusters,seed,values)
Relay Transforms
¶
gets its own dedicated page
Back to top