This question has been flagged
4 Replies
5520 Views

i just disappear an employee by untick on the select box in hr setting on the employee form. What step shall do for bringing him back to the active stage..

Avatar
Discard
Best Answer

You can use additionnal filters ("plus" button next to "filter" drop down in GTK, or in V7, use advanced search in the drop down of search field at the top right of the screen). Then select "active" field in the drop down. In GTK 6.0 you must specify "contains", "False" in the two other fields. In other version it's most intuitive (just un-check or select "is False").

Avatar
Discard
Author

yes this method works for me..

in what column of what table is this active bit stored ?

Best Answer

Hi Charlesraj, you can reactive your employee by the following query :

UPDATE resource_resource SET active=True WHERE id=1

Avatar
Discard
Best Answer

When you set active field's value False, OpenERP will hide that record. active field allows you to hide the record without removing it.

You can run update query in postgresql.

UPDATE resource_resource SET active=True
Avatar
Discard
Best Answer

Hi Charlesraj, you can reactive your employee by the following query :

UPDATE resource_resource SET active=True WHERE id=1

Avatar
Discard