Adding a widget in OpenERP Web Client

Recently I came across a post in a forum about adding a widget in OpenERP Web Client. I thought it would be nice to share the information through our blog.
In the OpenERP v6 Web Client, at the right handside we can see a twitter widget by default. Also, we can add more widgets like google maps, facebook etc. which are available by default. Our aim is to add a custom Search box widget which will search the blogs in Zesty Beanz website.
We can do this via PostgreSQL phppgadmin. In the database, we can find a table named res_widget. This is the table where the widgets are defined. We can add another row to create our new widget. Here we have some values to be entered in the table.
First of all, it asks for an id. The id field have a default expression ” nextval(‘res_widget_id_seq’::regclass) “. We leave this field as such. The following fields are also entered as given below:
create_uid – 1
create_date – the date when it is created
write_date – the field is left blank and the Null field is checked.
write_uid – the field is left blank and the Null field is checked.
content – The following code is entered here.

title – The title of the widget. I’ve given the title as Zesty Beanz Search.
Now our new widget will be available in the Homepage Widgets Management in the web client. We can add the widget from here and the widget will be available at the right hand side of the web client.