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

CRM
e-Commerce
Бухоблік
Склад
PoS
Проект
MRP

All apps

All Posts Люди Значки

Мітки (View all)

odoo accounting v14 pos v15

Про цей форум

Допомога

What is the syntax of domain under Odoo Studio when referring to a another field

filter Studio Domain

4 Відповіді

4658 Переглядів

Pablo_1985

Hello there,

I am trying to connect Calendar events with specific tasks. For that I added 2 one2Many fields, one to select the project and one to select the task.

I can select the project.

When selecting the tasks I can see all the tasks of every project in Odoo

If I change the domain for the Task fields and put something like [["project_id","=","Project1 SO0001"]] they get filtered by only the tasks in "Project1 SO0001"

Now when I refer to the Project field that I created as [["project_id","=","x_studio_many2one_field_d6imT"]] it simply doesn't work. I tried many variations from similar things I've seen in the forums, but I don't manage to make it work.

And also, where could I find documentation about this?

Thanks in advance

Cybrosys Techno Solutions Pvt.Ltd

Hi,

If you can edit the code editor of the domain view, you can try it this way:

[["project_id", "=", x_studio_many2one_field_d6imT.id]]

I think this approach may meet your requirements.

Note: It may not be affected directly by using Studio. You can give it a try.

Hope it helps

Paresh Wagh

Hi Pablo: The domain editor built into Studio currently does not support referencing another field in the domain.

Krishna Bhalala

Hello, Syntax of the domain should be [["project_id", "=", x_studio_many2one_field_d6imT]] not [["project_id","=","x_studio_many2one_field_d6imT"]] , but this syntax not compatible with Studio, So it would better you will do this using custom development/ module.

Thanks let me know if we can help

Pablo_1985

Автор

I tried that and indeed it didn't work. I'm surprised about that. Thank you for sharing, I was driving myself crazy

Pablo_1985

Автор

Anyone?

Benjamín Jiménez

Hi Pablo,

I wanted to share a workaround I discovered for editing the Studio custom view, as the standard syntax isn't compatible in this case.

Here's what I found:

1. **Edit the Studio custom view on XML.**
2. **Locate the XPath expression related to your field.**
3. **Add the following code snippet:**

```xml
<xpath expr="/form[1]/sheet[1]/group[1]/group[2]/field[4]" position="attributes">
<attribute name="domain">[("project_id", "=", x_studio_many2one_field_d6imT)]</attribute>
</xpath>
```

**Important Note:** Make sure to use a tuple, not a list, inside the list for the "domain" attribute.

Apologies for the delay!

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Реєстрація

Related Posts	Відповіді	Переглядів
How to use the "Context" in the Studio? context Studio Domain	3 бер. 20	11099
cbbbbggf filter	0 лист. 25	2
Factura en estado "EN PROCESO DE PAGO" filter	0 лист. 25	2
Simultaneous search criteria across companies and persons Вирішено filter	1 жовт. 25	714
Extended "shop" controller executes (confirmed by log), but the view ignores the modified "qcontext" (even with request.render) filter	3 жовт. 25	832

Це запитання позначене

Enjoying the discussion? Don't just read, join in!