Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

How to filter on a list of values ?

filter listview filtering filters lists

2 Ответы

15223 Представления

Sylvain RAUCY

I'm a user of Odoo 9.0 and I manage a list of 5000 people.

In the list view I have a search box on top, and I would like to perform a search that would give me people whose ID is in a specific list of values. For instance, I'd like to get people number 3, 4, 8, 12, 15, 18, 22, 321, 432, 923, 945, 971, 1434 and 3942.

In SQL it would be something like select * from people where ID in (3, 4, 8, 12, 15, 18, 22, 321, 432, 923, 945, 971, 1434, 3942).

I've looked in the filters where I can add a user-defined filter but it only allows me to filter on 1 specific value, or exclude 1 value, or even return people whose ID < or > to 1 specific value. Not what I'm looking for.

I'd be very grateful if you could help.

Sylvain

Ray Carnes

Лучший ответ

The trick is to modify the search view so that ID is searchable without needing a Custom Filter.

You can add the ID field to the search view, or combine it with the default (first) search view field.

Adding this to the top of the search view would make ID the default search field:

<field name="id" filter_domain="[('id','=',self)]"/>

Then, enter all of the numbers:

Sylvain RAUCY

Автор

Hi Ray,

Thanks for the prompt answer.

I'm just a Odoo user, I'm not an admin and therefore I can't add the field you're mentioning.

Here's what I have :

Search field on top of my "membres" list :

I can search 1 ID (the field to search in is "Base du barre code" which translate as "bar code base" and is an int)

But if I try to enter 2 IDs like that with a "or" (which is a string), the "Base du barre code" option disapears :

I tried to check if I'd search on names :

But nothing comes out this way :

And finaly, in the user-defined filters, I can't type "or" in an int field :

(sorry I couldn't find how to insert images)

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
Change default list view count listview productlist lists	2 мая 23	9722
Unable to filter by unpaid vendor bills by default Решено filter filtering Odoo13.0	1 апр. 22	2444
Expand "group by" filter by default filter group_by filtering	1 авг. 21	12290
Filter one2many with dynamic values filter one2many filters	0 июн. 21	3304
how to add default filter in Search: Product view? filter filtering odoo10	1 апр. 20	4265

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!