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?.
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.
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
|Asked: 5/8/15, 2:55 PM|
|Seen: 335 times|
|Last updated: 5/9/15, 3:33 AM|