AMI Documentation
Initializing search
AMI Documentation
Home
Getting Started
Getting Started
What is 3forge?
First Time Setup
Where Next?
Architecture
Architecture
3forge Architecture
Upgrading 3forge
Configuration Guide
Configuration Guide
How Do You Configure 3forge?
Common Properties
Center
Web
Relay
WebBalancer / WebManager
Source & Version Control
Custom Java Plugins
WebBalancer / WebManager
Center Replication
Center Subscription
Scaling
Authentication
Authentication
OAuth
SAML
LDAP
Custom Authentication
Custom Entitlements
Data Filter
Encryption
Encryption
External Vaults
Properties Files
Center Tables
User Passwords
SSL
Custom Encryption
OMAS
Advanced Setup
Advanced Setup
Advanced Configurations for 3forge
Instructions for SSL/TLS
Running 3forge with Docker
Running 3forge with Kubernetes
Running 3forge on a Distributed Kubernetes Cluster
Web
Web
What is the Web?
Structuring Layouts
Structuring Layouts
Windows
Tabs
Dividers
Multiple Layouts
Panels
Panels
Displaying Data
Tables
Trees
Charts
HTML
Other Panels
Relationships
Datamodels
Styling
Styling
Styling and Customizing 3forge Dashboards
Managing Styles
Tables
Trees
Users & Sessions
Callbacks
Transient Objects
Interoperability
Merge Tool
Spreadsheets
XML
Common Visualizations
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
Custom DNS
Custom HTML & JavaScript
Center
Center
What is the Center?
Realtime Tables
Historical Tables
Indexes
Triggers
Timers
Procedures
Methods
Tools
Custom Center Objects
Database Objects
Data
Data
How is data brought into 3forge?
What is the Relay?
Delta Processing
Datasource Adapters
Datasource Adapters
Setting Up Datasource Adapters
AMPS
Deephaven
Excel
Flat File
MongoDB
Redis
REST
Shell & SSH
Snowflake
Historical and Reference Bloomberg Data
Custom Datasource Adapter
Feed Handlers
Feed Handlers
Setting Up Feed Handlers
AMPS
AWS SQS
Deephaven
Hazelcast
Kafka
KDB
Solace
TIBCO EMS
TIBCO Streambase
IBM Message Queue
Custom Feed Handler
Clients
Clients
AMI Client
Java
.NET
Python
gRPC
B-PIPE Plugin
3forge REST Server
JDBC
Replay
LoadFile
Custom Relay Plugin
Reference
Reference
AmiScript: Scripting
AmiScript: SQL
AmiScript: Custom Classes
Realtime Messages
Classes
Classes
BigDecimal
BigInteger
Binary
Boolean
Byte
Callback
Character
ChartPanel
ChartPanelAxis
ChartPanelLayer
ChartPanelLegend
ChartPanelPlot
Collection
ColorGradient
CommandResponse
Comparable
Complex
Context
DashboardResource
Datamodel
Date
DevTools
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
FormTextField
FormTextareaField
FormTimeField
FormTimeRangeField
FormUploadField
Formula
HeatmapPanel
ICalendar
Image
Integer
Iterable
Iterator
KeyEvent
Layout
List
Long
Map
MenuItem
MouseEvent
Number
Object
Panel
Password
Point
Processor
Rand
RealtimeEvent
Rectangle
Relationship
Row
RpcRequest
RpcResponse
ScrollPanel
Session
Set
Short
SsoSession
String
StringBuilder
StyleOptionDefinition
StyleSet
SurfacePanel
SurfacePanelAxis
SurfacePanelLayer
Tab
Table
TablePanel
TablePanelColumn
TablePanelColumnFilter
TableSet
TabsPanel
TreePanel
TreePanelColumn
TreePanelGrouping
UTC
UTCN
UUID
Window
XmlBuilder
XmlElement
XmlParser
XmlText
ZipBuilder
Methods
Methods
abs(value)
acos(value)
asin(value)
atan(value)
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)
cos(radians)
cycle(offset,choices)
datePart(unixEpochMillis,yMdHmsS,timezone)
datePartNum(unixEpochMillis,part,timezone)
decodeDouble64(value)
decodeFloat64(value)
diffSequence(l,r,lcol,rcol,options)
digamma(x)
encodeDouble64(value)
encodeFloat64(value)
exp(x)
formatDate(unixEpoch,pattern,timezone)
formatNumber(value,format,options)
formatNumberCompact(value)
getBestImageType(hexColor)
getContext()
getRawJavaStackTrace()
gradient(value,value1,color1,value2,color2,moreNumbersAndColors)
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)
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()
readBinaryFile(fileName)
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()
writeBinaryFile(filename,data,append)
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)
Cheatsheets
Cheatsheets
AMIScript: Scripting
AMIScript: SQL
Security
Text Matching
Troubleshooting
Troubleshooting
Startup Failure
Security Warnings
Logs
Memory Overload
Timeouts
Supported Software
Contact Support
404 - Not found