Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I am trying to set the Domain in Odoo Studio to filter results of a field in Sales Order Lines
Current syntax: [["x_studio_pricelist.id","=","order_id.pricelist_id.id"]]
I get an error message stating:
invalid input syntax for integer: "order_id.pricelist_id.id"
If I enter the ID manually as a number in the domain (in this case 113), everything is fine.
How can I modify my syntax so Odoo converts order_id.pricelist_id.id properly?
Hi Roeland,
yes. Odoo Studio doesn't allow this when editing one simple field. But you could edit the Odoo Studio View:
1) Activate Debug Mode
2) Open Studio
3) Enter the XML of the Odoo Studio View (Tab View -> XML)
4) Select the View "Odoo Studio"
5) Delete the quote marks of the mentioned domain filter.
6) Save.
As you'll edit the xml directly, you should be aware of and know what you're doing.
BR
Florian
Leave out the quote marks:
[["x_studio_pricelist.id","=",order_id.pricelist_id.id]]
Hi Chris,
Sounds logic, but Studio won't let me do just that...
Is there another way?
Or do i do something wrong?
thx
Roeland
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Oct 24
|
176 | ||
|
2
Oct 24
|
1142 | ||
|
1
Jul 24
|
457 | ||
|
0
Jun 24
|
249 | ||
|
2
Mar 24
|
571 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Sorry, This is not a answer. But how did you solved the problem in the end? Mine is showing "Domain not properly formed" if I edit in xml