op functions (Value Processing Functions)
The following functions are used to support builtin functions within a plan. These include datatype constructors, datetime, duration, numeric, sequence, and string functions. Builtins that read documents or indexes, such as fn.doc, and that change the server state in any way are deliberately excluded from this list for performance reasons.
Each function namespace is a separate property on the object returned by requiring the
plan library.
For example, the fn property has an object with a lowerCase property for the
lowerCase function.
- cts.partOfSpeech
- cts.tokenize
- cts.stem
- fn.abs
- fn.adjustDateTimeToTimezone
- fn.adjustDateToTimezone
- fn.adjustTimeToTimezone
- fn.analyzeString
- fn.avg
- fn.baseUri
- fn.boolean
- fn.ceiling
- fn.codepointEqual
- fn.codepointsToString
- fn.compare
- fn.count
- fn.concat
- fn.currentDateTime
- fn.currentDate
- fn.currentTime
- fn.contains
- fn.dayFromDate
- fn.dayFromDateTime
- fn.daysFromDuration
- fn.deepEqual
- fn.defaultCollation
- fn.distinctValues
- fn.documentUri
- fn.empty
- fn.encodeForUri
- fn.endsWith
- fn.escapeHtmlUri
- fn.exists
- fn.false
- fn.floor
- fn.formatDate
- fn.formatDateTime
- fn.formatNumber
- fn.formatTime
- fn.generateId
- fn.head
- fn.hoursFromDateTime
- fn.hoursFromDuration
- fn.hoursFromTime
- fn.implicitTimezone
- fn.indexOf
- fn.inScopePrefixes
- fn.insertBefore
- fn.iriToUri
- fn.lang
- fn.localName
- fn.localNameFromQName
- fn.lowerCase
- fn.matches
- fn.max
- fn.min
- fn.minutesFromDateTime
- fn.minutesFromDuration
- fn.minutesFromTime
- fn.monthFromDate
- fn.monthFromDateTime
- fn.monthsFromDuration
- fn.name
- fn.namespaceUri
- fn.namespaceUriForPrefix
- fn.namespaceUriFromQName
- fn.nilled
- fn.nodeName
- fn.normalizeSpace
- fn.normalizeUnicode
- fn.not
- fn.number
- fn.prefixFromQName
- fn.QName
- fn.remove
- fn.replace
- fn.resolveQName
- fn.resolveUri
- fn.reverse
- fn.root
- fn.round
- fn.roundHalfToEven
- fn.secondsFromDateTime
- fn.secondsFromDuration
- fn.secondsFromTime
- fn.startsWith
- fn.string
- fn.stringJoin
- fn.stringLength
- fn.stringToCodepoints
- fn.subsequence
- fn.substring
- fn.substringAfter
- fn.substringBefore
- fn.sum
- fn.tail
- fn.timezoneFromDate
- fn.timezoneFromDateTime
- fn.timezoneFromTime
- fn.tokenize
- fn.translate
- fn.true
- fn.unordered
- fn.upperCase
- fn.yearFromDate
- fn.yearFromDateTime
- fn.yearsFromDuration
- geo.approxCenter
- geo.arcIntersection
- geo.bearing
- geo.boundingBoxes
- geo.boxIntersects
- geo.circleIntersects
- geo.circlePolygon
- geo.countDistinctVertices
- geo.countVertices
- geo.destination
- geo.distance
- geo.distanceConvert
- geo.ellipsePolygon
- geo.geohashDecode
- geo.geohashDecodePoint
- geo.geohashEncode
- geo.geohashNeighbors
- geo.geohashPrecisionDimensions
- geo.geohashSubhashes
- geo.interiorPoint
- geo.parseWkt
- geo.regionAffineTransform
- geo.regionApproximate
- geo.regionClean
- geo.regionContains
- geo.regionDe9im
- geo.regionIntersects
- geo.regionRelate
- geo.removeDuplicateVertices
- geo.shortestDistance
- geo.toWkt
- geo.validateWkt
- json.array
- json.arraySize
- json.arrayValues
- json.object
- json.objectDefine
- json.subarray
- json.toArray
- map.contains
- map.count
- map.entry
- map.get
- map.keys
- map.map
- math.acos
- math.asin
- math.atan
- math.atan2
- math.ceil
- math.correlation
- math.cos
- math.cosh
- math.cot
- math.covariance
- math.covarianceP
- math.degrees
- math.exp
- math.fabs
- math.floor
- math.fmod
- math.frexp
- math.ldexp
- math.linearModel
- math.linearModelCoeff
- math.linearModelIntercept
- math.linearModelRsquared
- math.log
- math.log10
- math.median
- math.mode
- math.modf
- math.percentile
- math.percentRank
- math.pi
- math.pow
- math.radians
- math.rank
- math.sin
- math.sinh
- math.sqrt
- math.stddev
- math.stddevP
- math.tan
- math.tanh
- math.trunc
- math.variance
- math.varianceP
- rdf.langString
- rdf.langStringLanguage
- sem.bnode
- sem.coalesce
- sem.datatype
- sem.defaultGraphIri
- sem.if
- sem.invalid
- sem.invalidDatatype
- sem.iri
- sem.iriToQName
- sem.isBlank
- sem.isIRI
- sem.isLiteral
- sem.isNumeric
- sem.lang
- sem.langMatches
- sem.QNameToIri
- sem.random
- sem.rulesetStore
- sem.sameTerm
- sem.store
- sem.timezoneString
- sem.typedLiteral
- sem.unknown
- sem.unknownDatatype
- sem.uuid
- sem.uuidString
- spell.doubleMetaphone
- spell.levenshteinDistance
- spell.romanize
- sql.bitLength
- sql.collatedString
- sql.dateadd
- sql.datediff
- sql.datepart
- sql.day
- sql.dayname
- sql.glob
- sql.hours
- sql.ifnull
- sql.insert
- sql.instr
- sql.left
- sql.like
- sql.ltrim
- sql.minutes
- sql.month
- sql.monthname
- sql.nullif
- sql.octetLength
- sql.quarter
- sql.rand
- sql.repeat
- sql.right
- sql.rtrim
- sql.rowID
- sql.seconds
- sql.sign
- sql.soundex
- sql.space
- sql.strpos
- sql.timestampadd
- sql.timestampdiff
- sql.trim
- sql.week
- sql.weekday
- sql.year
- sql.yearday
- xdmp.add64
- xdmp.and64
- xdmp.base64Decode
- xdmp.base64Encode
- xdmp.castableAs
- xdmp.crypt
- xdmp.crypt2
- xdmp.daynameFromDate
- xdmp.decodeFromNCName
- xdmp.describe
- xdmp.diacriticLess
- xdmp.elementContentType
- xdmp.encodeForNCName
- xdmp.formatNumber
- xdmp.fromJson
- xdmp.getCurrentUser
- xdmp.hash32
- xdmp.hash64
- xdmp.hexToInteger
- xdmp.hmacMd5
- xdmp.hmacSha1
- xdmp.hmacSha256
- xdmp.hmacSha512
- xdmp.initcap
- xdmp.integerToHex
- xdmp.integerToOctal
- xdmp.keyFromQName
- xdmp.lshift64
- xdmp.md5
- xdmp.monthNameFromDate
- xdmp.mul64
- xdmp.nodeCollections
- xdmp.nodeMetadata
- xdmp.nodeMetadataValue
- xdmp.nodeKind
- xdmp.nodePermissions
- xdmp.nodeUri
- xdmp.not64
- xdmp.octalToInteger
- xdmp.or64
- xdmp.parseDateTime
- xdmp.parseYymmdd
- xdmp.path
- xdmp.position
- xdmp.QNameFromKey
- xdmp.quarterFromDate
- xdmp.random
- xdmp.resolveUri
- xdmp.rshift64
- xdmp.sha1
- xdmp.sha256
- xdmp.sha384
- xdmp.sha512
- xdmp.step64
- xdmp.strftime
- xdmp.timestampToWallclock
- xdmp.toJson
- xdmp.type
- xdmp.urlDecode
- xdmp.urlEncode
- xdmp.wallclockToTimestamp
- xdmp.weekdayFromDate
- xdmp.weekFromDate
- xdmp.xor64
- xdmp.yeardayFromDate
- xs.anyURI
- xs.base64Binary
- xs.boolean
- xs.byte
- xs.byte
- xs.dateTime
- xs.dayTimeDuration
- xs.decimal
- xs.double
- xs.duration
- xs.float
- xs.gDay
- xs.gMonth
- xs.gMonthDay
- xs.gYear
- xs.gYearMonth
- xs.hexBinary
- xs.int
- xs.integer
- xs.language
- xs.long
- xs.Name
- xs.NCName
- xs.NMTOKEN
- xs.negativeInteger
- xs.nonNegativeInteger
- xs.nonPositiveInteger
- xs.normalizedString
- xs.positiveInteger
- xs.QName
- xs.short
- xs.string
- xs.time
- xs.token
- xs.unsignedByte
- xs.unsignedInt
- xs.unsignedLong
- xs.unsignedShort
- xs.untypedAtomic
- xs.yearMonthDuration
1 function
| Function name | Description |
|---|---|
| op:call | This function to calls a built-in function on every row. |