DECIBEL DEFINITION FREE

can't be used as computed property names.Ī computed property name can't match a property path that is already indexed. Reserved system property names such as id, _rid, _ts etc. The value of name property represents the top-level property name that can be used to reference the computed property.

The constraints on computed property names are:Īll computed properties must have unique names. This is because wildcard projection does not automatically include computed properties.

Queries will always use the computed property instead of the persisted property, with the exception of the persisted property being returned instead of the computed property if there is a wildcard projection in the SELECT clause. Regardless of whether the computed property is indexed, values from persisted properties that share a name with a computed property won't be included in the index. This article uses the prefix cp_ in all name definitions.ĭefining a computed property with the same name as a persisted property won't give an error, but it may lead to unexpected behavior. To avoid overlapping property names, you can add a prefix or suffix to all computed property names. It's strongly recommended that computed properties are named in such a way that there's no collision with a persisted property name. 'query': 'SELECT VALUE LOWER(c.name) FROM c' Every container can have a maximum of 20 computed properties. Computed properties are scoped to an individual item and therefore can't use values from multiple items or rely on other computed properties.

The name is the computed property name, and the query defines logic to calculate the property value for each item. Each computed property definition has two components: a name and a query.

DECIBEL DEFINITION FREE

Do you have any feedback about computed properties? We want to hear it! Feel free to share feedback directly with the Azure Cosmos DB engineering team: Computed property definitionĬomputed properties must be at the top level in the item and can't have a nested path.

Decibel definition