When we want to access views via web client, we go into : Configuration/Technical/User interface/Views.
We select the desired view, in my case : res.users.form and we have Architecture Tab, containing the XML Code, wich we can modify.
I no longer have this possibility, because I'm unable to connect to my openerp account via the web client.
So I decided to do it by accessing the table ir_ui_views containing all the views, via postgresql, and modify the XML architecture via SQL Query.
I am right know connected to my desired database, on shell, and my question is :
What is the SQL query to perform ?
@yassine why do you want to change the view at the database end. Is it that due to any view the client is not starting? If yes, and if you know which view is the culprit then just remove that view from the '__openerp__.py' file and restart the server. This may start your client.
I am unable to connect top my openerp account, because of the XML architecture error, the fact is I deleted a custom field from user interface, via the configuration module, and not from the view, so when he looks for the field from the XML architecture he doesn't find it. The Probleme is that when we add a custom field from the debugger mode ( User interface ), it loads the view from the database, and not from the source code, the view from the openerp file does not contain the custom field that I added, so I dont' have any point of access apart of the database.
I removed the view from the openerp.py file, same probleme ..., the server loads always the XML code on the database ...