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
Contabilitate
Inventar
PoS
Project
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

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

filter Studio Domain

4 Răspunsuri

3751 Vizualizări

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!

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

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

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
How to use the "Context" in the Studio? context Studio Domain	3 mar. 20	10253
Simultaneous search criteria across companies and persons filter	1 aug. 25	155
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers filter	0 iul. 25	977
Filters in multiple companies Rezolvat filter	1 mai 25	1677
ADD PROPERTIES Rezolvat filter	1 mai 25	3359

Această întrebare a fost marcată

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