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

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

CRM
e-Commerce
Financeiro
Inventário
PoS
Project
MRP

All apps

Todas as publicações Pessoas Emblemas

Marcadores (Ver tudo)

odoo accounting v14 pos v15

Sobre este fórum

Ajuda

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

filter Studio Domain

4 Respostas

3735 Visualizações

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

Autor

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

Autor

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!

Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Publicações relacionadas	Respostas	Visualizações
How to use the "Context" in the Studio? context Studio Domain	3 mar. 20	10251
Simultaneous search criteria across companies and persons filter	1 ago. 25	148
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers filter	0 jul. 25	958
Filters in multiple companies Resolvido filter	1 mai. 25	1674
ADD PROPERTIES Resolvido filter	1 mai. 25	3357

Esta pergunta foi sinalizada

Está gostando da discussão? Não fique apenas lendo, participe!