Axelor icon

Axelor

Integrate with Axelor Open Platform

Actions16

Record → Search Records

AI-generated

Summary

Searches an Axelor model for records matching an optional query and returns each result as an n8n item. Advanced settings can limit or shape the results, filter archived records, add domain context, and specify sort order.

Inputs

  • Model Name or ID (required) — Axelor model to search; choose from the loaded models or supply its ID.
  • Search Query — Optional Axelor search domain expression. When provided, it is sent as the search data’s _domain; when empty, no domain is added.
  • Advanced Settings — When enabled, reveals optional result and search controls.
  • Limit — Maximum number of records requested. Defaults to 50 when advanced settings are enabled; with advanced settings disabled, the operation requests 10.
  • Field Name Names or IDs — Optional fields to return. If none are selected, the operation requests all fields returned by Axelor model metadata.
  • Show Archived — Choose Yes or No to filter by archived status. Unset (the default) omits the archived filter.
  • Context — Optional key/value pairs sent as _domainContext with the search data.
  • Sort By — Optional field and ascending or descending rule pairs. Descending fields are sent with a leading minus sign.

Output shape

A list of n8n items, one per returned record.

An empty Axelor result produces no items. Selected custom JSON fields are expanded into their own properties. Search errors are thrown unless the node is configured to continue on fail, in which case an item with an error property is returned.

Links

Discussion