DocumentDB helps a number of integrated capabilities for common operations that can be used inner queries. There are a gaggle of capabilities for appearing mathematical calculations, and additionally type checking functions which might be extraordinarily beneficial at the same time as operating with varying schemas. These capabilities can test if a positive assets exists and if it does whether or not it is various or a string, Boolean or item.
We additionally get these accessible functions for parsing and manipulating strings, as well as several features for running with arrays allowing you to do such things as concatenate arrays and take a look at to see if an array contains a selected detail.
Following are the specific styles of integrated functions −
|S.No.||Built-in Functions & Description|
The mathematical functions perform a calculation, usually based on input values that are provided as arguments, and return a numeric value.
Type Checking Functions
The type checking functions allow you to check the type of an expression within SQL queries.
The string functions perform an operation on a string input value and return a string, numeric or Boolean value.
The array functions perform an operation on an array input value and return in the form of numeric, Boolean or array value.
DocumentDB also supports the Open Geospatial Consortium (OGC) built-in functions for geospatial querying.