Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
2395 Visualizzazioni

What filters does Odoo API support (for example: >, < ...ect)

Avatar
Abbandona
Autore

Is this documented?

Risposta migliore

The Odoo API supports various filters that you can use to query records based on specific conditions. Here are some commonly used filters in the Odoo API:

1. Equals (=): To filter records that match a specific value, you can use the equals operator. For example:
- `domain=[('field_name', '=', 'value')]`

2. Not Equals (!=): To filter records that do not match a specific value, you can use the not equals operator. For example:
- `domain=[('field_name', '!=', 'value')]`

3. Greater Than (>), Less Than ( - `domain=[('field_name', '>', value)]`
- `domain=[('field_name', '
4. Greater Than or Equal To (>=), Less Than or Equal To (<=): To filter records based on numerical or date fields, including the specified value, you can use greater than or equal to and less than or equal to operators. For example:
- `domain=[('field_name', '>=', value)]`
- `domain=[('field_name', '<=', value)]`

5. In: To filter records that match any value from a list of values, you can use the in operator. For example:
- `domain=[('field_name', 'in', ['value1', 'value2', 'value3'])]`

6. Not In: To filter records that do not match any value from a list of values, you can use the not in operator. For example:
- `domain=[('field_name', 'not in', ['value1', 'value2', 'value3'])]`

7. Like: To filter records based on a pattern or substring match, you can use the like operator. It supports wildcard characters: % represents any number of characters, and _ represents a single character. For example:
- `domain=[('field_name', 'like', 'abc%')]`
- `domain=[('field_name', 'like', '%xyz')]`
- `domain=[('field_name', 'like', '_a%b_')]`

8. Not Like: To filter records that do not match a specific pattern or substring, you can use the not like operator. For example:
- `domain=[('field_name', 'not like', 'abc%')]`

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
2
ago 25
2837
1
lug 25
1155
1
ago 25
1152
0
mag 25
1578
2
apr 25
3767