Specifies whether computed fields in Odoo are exposed as columns.

Syntax

Connect-Odoo -AllowComputedFields SwitchParameter

Data Type

bool

Default Value

false

Remarks

Odoo includes both stored and computed fields. Stored fields are retrieved directly from the database, while computed fields are generated dynamically at query time.

When this property is set to true, the cmdlet includes computed fields as columns in the exposed schema. This allows access to additional metadata or derived values that Odoo generates during runtime.

This property is useful when working with tools that rely on a complete set of available fields, but do not allow you to edit the schema or query structure manually.

Performance Considerations

Including computed fields can impact performance, especially when querying large tables. Since Odoo must evaluate computed fields at runtime, queries (particularly star queries or those involving joins) may take significantly longer to complete. Use this property only when you need access to specific computed fields that are not stored directly in the database.