Substr | biorate

Properties

$substr

$substr: [StringExpression<string>, number, number]

Deprecated. Use $substrBytes or $substrCP.

Deprecated

3.4

Alias

See

https://www.mongodb.com/docs/manual/reference/operator/aggregation/substr/#mongodb-expression-exp.-substr

default
Error
Expression
- Abs
- Accumulator
- Acos
- Acosh
- Add
- AddToSet
- AllElementsTrue
- And
- AnyElementsTrue
- ArrayElemAt
- ArrayToObject
- Asin
- Asinh
- Atan
- Atan2
- Atanh
- Avg
- BinarySize
- BsonSize
- Ceil
- Cmp
- Concat
- ConcatArrays
- Cond
- Convert
- Cos
- Cosh
- Count
- CovariancePop
- CovarianceSamp
- DateAdd
- DateDiff
- DateFromParts
- DateFromString
- DateSubtract
- DateToParts
- DateToString
- DateTrunc
- DayOfMonth
- DayOfWeek
- DayOfYear
- DegreesToRadians
- DenseRank
- Derivative
- Divide
- DocumentNumber
- Eq
- Exp
- ExpMovingAvg
- Filter
- First
- Floor
- Function
- GetField
- Gt
- Gte
- Hour
- IfNull
- In
- IndexOfArray
- IndexOfBytes
- IndexOfCP
- Integral
- IsArray
- IsNumber
- IsoDayOfWeek
- IsoWeek
- IsoWeekYear
- Last
- Let
- LinearFill
- Literal
- Ln
- Locf
- Log
- Log10
- Lt
- Lte
- Ltrim
- Map
- Max
- MergeObjects
- Meta
- Millisecond
- Min
- Minute
- Mod
- Month
- Multiply
- Ne
- Not
- ObjectToArray
- Or
- Pow
- Push
- RadiansToDegrees
- Rand
- Range
- Rank
- Reduce
- RegexFind
- RegexFindAll
- RegexMatch
- ReplaceAll
- ReplaceOne
- ReverseArray
- Round
- Rtrim
- SampleRate
- Second
- SetDifference
- SetEquals
- SetField
- SetIntersection
- SetIsSubset
- SetUnion
- Shift
- Sin
- Sinh
- Size
- Slice
- Split
- Sqrt
- StdDevPop
- StdDevSamp
- StrLenBytes
- StrLenCP
- Strcasecmp
- Substr
- SubstrBytes
- SubstrCP
- Subtract
- Sum
- Switch
- Tan
- Tanh
- ToBool
- ToDate
- ToDecimal
- ToDouble
- ToInt
- ToLong
- ToLower
- ToObjectId
- ToString
- ToUpper
- Top
- TopN
- Trim
- Trunc
- Type
- UnsetField
- Week
- Year
- Zip
PipelineStage
Schema
Types
mongo
ConnectionStates
Aggregate
Connection
Cursor
Document
Error
MongooseError
NativeBuffer
Query
Schema
SchemaType
SchemaTypeOptions
VirtualType
mquery
AcceptsDiscriminator
AggregateOptions
AnyObject
AsyncValidateFn
Collection
CollectionBase
ConnectOptions
CreateOptions
DefaultSchemaOptions
DiscriminatorOptions
DocumentSetOptions
EachAsyncOptions
GeoSearchOptions
IndexManager
IndexOptions
IndexesDiff
InsertManyOptions
LegacyAsyncValidateFn
MapReduceOptions
MixedSchemaTypeOptions
Model
Models
ModifyResult
MongooseBulkWriteOptions
MongooseOptions
PopulateOption
PopulateOptions
QueryOptions
QueryTimestampsConfig
RemoveOptions
SaveOptions
SchemaOptions
SchemaTimestampsConfig
SessionOperation
SessionOption
SessionStarter
SyncIndexesOptions
TagSet
ToObjectOptions
ValidateFn
ValidateOpts
Validator
ValidatorMessageFn
ValidatorProps
VirtualTypeOptions
AccumulatorOperator
AggregateExtract
AggregationVariables
AnyArray
AnyExpression
AnyKeys
ApplyBasicQueryCasting
ApplySchemaOptions
ArithmeticExpressionOperator
ArrayExpression
ArrayExpressionOperator
ArrayExpressionOperatorReturningAny
ArrayExpressionOperatorReturningArray
ArrayExpressionOperatorReturningBoolean
ArrayExpressionOperatorReturningNumber
ArrayExpressionOperatorReturningObject
BinaryExpression
BooleanExpression
BooleanExpressionOperator
BooleanSchemaDefinition
Callback
CallbackError
CallbackWithoutResult
CallbackWithoutResultAndOptionalError
CastError
ClientSession
ClientSessionOptions
CodeExpression
ComparisonExpressionOperator
ComparisonExpressionOperatorReturningBoolean
ComparisonExpressionOperatorReturningNumber
CompileModelOptions
Condition
ConditionalExpressionOperator
ConnectionSyncIndexesResult
CursorFlag
CustomAggregationExpressionOperator
CustomAggregationExpressionOperatorReturningAny
DataSizeOperator
DataSizeOperatorReturningNumber
Date
DateExpression
DateExpressionOperator
DateExpressionOperatorReturningDate
DateExpressionOperatorReturningNumber
DateExpressionOperatorReturningObject
DateExpressionOperatorReturningString
DateSchemaDefinition
DateUnit
Decimal128
DefaultType
DefaultTypeKey
DiscriminatorModel
DiscriminatorSchema
ErrorHandlingMiddlewareFunction
ErrorHandlingMiddlewareWithOption
Expression
ExtractMongooseArray
FilterQuery
FlatRecord
FlattenMaps
FormatString
FunctionExpression
GetLeanResultType
HydratedArraySubdocument
HydratedDocument
HydratedDocumentFromSchema
HydratedSingleSubdocument
IfAny
IfEquals
IfUnknown
IndexDefinition
IndexDirection
InferId
InferSchemaType
InsertManyResult
IsItRecordAndNotAny
LiteralExpressionOperator
LiteralExpressionOperatorReturningAny
LiteralExpressionReturningAny
MergeType
MiddlewareOptions
MiscellaneousExpressionOperator
MiscellaneousExpressionOperatorReturningNumber
Mixed
Mongoose
MongooseDefaultQueryMiddleware
MongooseDistinctDocumentMiddleware
MongooseDistinctQueryMiddleware
MongooseDocumentMiddleware
MongooseQueryAndDocumentMiddleware
MongooseQueryMiddleware
MongooseQueryOptions
MongooseQueryOrDocumentMiddleware
MongooseRawResultQueryMiddleware
NullExpression
Number
NumberExpression
NumberSchemaDefinition
ObjectExpression
ObjectExpressionOperator
ObjectExpressionOperatorReturningArray
ObjectExpressionOperatorReturningObject
ObjectId
ObjectIdExpression
ObjectIdSchemaDefinition
ObtainDocumentType
ObtainSchemaGeneric
OneCollectionSyncIndexesResult
Path
PathsToValidate
PipelineStage
PopulatedDoc
PostMiddlewareFunction
PreMiddlewareFunction
PreSaveMiddlewareFunction
ProjectionElementType
ProjectionFields
ProjectionType
QueryOpThatReturnsDocument
QuerySelector
QueryWithHelpers
RefType
RegexOptions
Require_id
ResolveSchemaOptions
ResolveTimestamps
ReturnsNewDoc
RootQuerySelector
SchemaDefinition
SchemaDefinitionProperty
SchemaDefinitionType
SchemaDefinitionWithBuiltInClass
SchemaOptionsVirtualsPropertyType
SchemaPostOptions
SchemaPreOptions
SchemaValidator
SetExpressionOperator
SetExpressionOperatorReturningArray
SetExpressionOperatorReturningBoolean
SortOrder
SortValues
SpecialPathVariables
StartOfWeek
StringExpression
StringExpressionOperator
StringExpressionOperatorReturningArray
StringExpressionOperatorReturningBoolean
StringExpressionOperatorReturningNumber
StringExpressionOperatorReturningObject
StringExpressionOperatorReturningString
StringSchemaDefinition
SyncIndexesError
TVirtualPathFN
TextExpressionOperator
TreatAsPrimitives
TrigonometryExpressionOperator
TypeExpressionOperator
TypeExpressionOperatorReturningBoolean
TypeExpressionOperatorReturningDate
TypeExpressionOperatorReturningNumber
TypeExpressionOperatorReturningObjectId
TypeExpressionOperatorReturningString
TypeKeyBaseType
UTCOffset
Unpacked
UnpackedIntersection
UpdateAggregationStage
UpdateQuery
UpdateQueryKnownOnly
UpdateWithAggregationPipeline
UpdateWriteOpResult
VariableExpressionOperator
VariableExpressionOperatorReturningAny
VirtualPathFunctions
WindowOperator
WindowOperatorReturningAny
WindowOperatorReturningArray
WindowOperatorReturningNumber
WriteConcern
_FilterQuery
_pickObject
actualPrimitives
hh
mm
pathsToSkip
pathsToValidate
tzExpression
Collection
Model
Mongoose
Promise
STATES
SchemaTypes
connection
connections
models
version
connect
createConnection
deleteModel
disconnect
get
isObjectIdOrHexString
isValidObjectId
model
modelNames
now
plugin
pluralize
sanitizeFilter
set
setDriver
startSession
syncIndexes
trusted

Interface Substr

Hierarchy

Index

Properties

Properties

$substr

Deprecated

Alias

See

Settings

Member Visibility

Theme

On This Page