Odoo Help


Update file "arch" in a view

Dago Gallo
on 5/8/15, 2:55 PM 728 views

I need to do an update to a view in the  field "arch", but when an error occurs I try me by my content has single and double quotes, so postgres does not know where it begins and where it ends.

For example thats what I want to update:


update ir_ui_view set arc='<?xml version="1.0"?>


<field name="name" position="before" >

<field name="prefix" nolabel="1" class="oe_inline"/> -


</data>' where id=1067; 

This is a mistake, but not how to do the update of the arch field.

Could anyone help me please?.




| 6 5 7
Tbilisi, Georgia
On 5/9/15, 3:31 AM

option1: you can cange this from user interface of odoo, in developer mode.

option2: you customize the view by inheriting a view you need to change (in XML - in your module)

option3: you find out the XML file where it comes from, change it there and then update corresponding module.

option4 (NOT recomended): manipulate database through postgresql, you've to escape string properly in this case.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/8/15, 2:55 PM
Seen: 728 times
Last updated: 5/9/15, 3:33 AM