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.

Continue reading

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.

Continue reading