Odoo Help


This community 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.


Update file "arch" in a view

Dago Gallo
on 5/8/15, 2:55 PM 335 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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


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