This question has been flagged
1 Reply
3812 Views
databasepostgresqlupdatescript
Avatar
Dago Gallo

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:

--base_company_prefix.xml

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

<data>

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

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

</field>

</data>' where id=1067; 


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

Could anyone help me please?.

Avatar
Discard
Avatar
Temur
Best Answer

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.

Avatar
Discard