Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
filterdomain_filterdynamicfilter_domainStudio
3 Odgovori
3772 Prikazi
Avatar
IT Consultancy Sàrl

Hi, 


Hosting Variants: All Odoo hosting variants (Odoo SAAS, Odoo.SH, Odoo onPrem)

Versions: Odoo 15.0, Odoo 16.0 (other versions not tested)

App: Studio


Description: 

I try to create a dynamic domain using Studio but constantly receive a "Domain not properly formed" error. 

I have a field named "x_studio_species" which records the species of a record (e.g. "Cat"). 

I have a second field named "x_studio_shelter_box" which records the shelter/box where an animal is located (e.g. Shelter 1: Box 2). 

Both fields are their own models. The model for the shelter_box has a many_to_many (m2m) field named "x_studio_suitable_for" and records the species for which this box is suitable for (e.g. Shelter 1: Box 2 is suitable for Cats, Dogs, and Birds but Shelter 1: Box 1 is suitable only for Dogs). 


Suppose I'm trying to create a domain in Studio for the Animal form which selects only those boxes suitable for the selected species. Thus it should be a dynamic domain that should look like this: 


[["x_studio_suitable_for","like",x_studio_species]]


This however doesn't work, as you can't save the domain that way. It automatically creates it like this: (see quotes for x_studio_species")

[["x_studio_suitable_for","like","x_studio_species"]]


Thus the domain is created with a string instead of a variable. If I'm removing the quotes manually in the window, I get the message "Domain not properly formed"


How can I create a dynamic domain in Studio? ​Is this a bug and if so, is there a workaround?


Thanks in advance

Avatar
Opusti
Avatar
IT Consultancy Sàrl
Avtor Best Answer

Hi again, 


Well I finally found the solution. 

When looking at the XML code that gets generated, it looks like this: 

   


So the domain is between double quotes and the respective fields are escaped double-quotes. 


By changing the XML-code of it to: 

   


It works perfectly. The domain is between double quotes but the fields themselves are between single quotes and the variable doesn't have any quotes and is recognized as a variable and not as a string. 


The only downside: I cannot modify the domain using the domain-wizard as this is not parsed correctly now. The form and domain are working correctly though. 



Solution: To create dynamic domains, generate the domain as desired, go (using debug-mode) to the XML file in "View" and modify the escaped double quotes " to ' (single quote). 

Avatar
Opusti
Hardik Raval

Indeed, this worked for me. I tried to directly write the field name without single quote (') and it worked

Avatar
Eva@Ybo Services
Best Answer

Thanks a lot. I spent a lot of time before I found your answer and it also worked for me.

At the start I had " almost everywhere in my domain, then I changed according to your explanation and now it works perfectly.



Great.

Avatar
Opusti
Avatar
Adil Akbar
Best Answer

Hi, you can follow this: https://youtu.be/f3mq5fHRPT0

Hope it helps, Thanks

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
Add Filter inside the searchbar dynamically.
filter dynamic searchview filter_domain 17.0
Avatar
0
jun. 24
2266
Odoo 9.0 - Dynamic Custom Search Filter
filter search context dynamic filter_domain
Avatar
Avatar
2
okt. 16
8292
Default Domain Filter
filter domain_filter
Avatar
Avatar
Avatar
2
jun. 22
8213
Trying to filter a list using domain using studio (Odoo V14 Enterprise)
domain_filter Studio
Avatar
Avatar
1
jul. 21
3326
Filtration in xml view
filter domain_filter
Avatar
Avatar
2
feb. 16
4816