Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
1 Vastaa
2232 Näkymät

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

Avatar
Hylkää
Tekijä

Is this documented?

Paras vastaus

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
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
1
heinäk. 25
515
1
kesäk. 25
1085
0
toukok. 25
1204
2
huhtik. 25
3202
1
helmik. 25
1437