MongoDB $literal

In MongoDB, the $literal aggregation pipeline operator returns a value without parsing.

It accepts any valid expression, and returns the unparsed expression.

The $literal operator can be useful for when you have a value that MongoDB could inadvertently interpret as an expression, but you don’t want it to.

For example, if you have a monetary amount that includes a dollar sign, MongoDB might inadvertently interpret that as a field name. You can use $literal to prevent MongoDB from interpreting such expressions.

Read more

MongoDB $indexOfCP

In MongoDB, the $indexOfCP aggregation pipeline operator searches a string for an occurrence of a substring and returns the UTF code point index of the first occurrence.

The UTF code point index is zero-based (i.e. it starts at 0).

Read more

MongoDB $indexOfBytes

In MongoDB, the $indexOfBytes aggregation pipeline operator searches a string for an occurrence of a substring and returns the UTF-8 byte index of the first occurrence.

The UTF byte index is zero-based (i.e. it starts at 0).

Read more

MongoDB $trunc

In MongoDB, the $trunc aggregation pipeline operator truncates a number to a whole integer or to a specified decimal place.

You have the option of specifying how many decimal places for which to truncate the number. To do this, pass a second argument. The first argument is the number to truncate, and the second (optional) argument is the number of decimal places to truncate it to.

Omitting the second argument truncates all digits to the right of the decimal and returns the whole integer value.

Read more