Hi Tal,

Thank you for the question.

Unfortunately it is not possible to restore a user that has been deleted via the Yellowfin UI. If you would like to restore a user, you would have to run several queries against the Yellowfin configuration database.

If you are interested in pursuing this, you could run the below three queries. Please note, that the Yellowfin service will need to be restarted in order for these changes to take effect. Also, to run these queries you will need to know the <'UserID'> of the user you would like to restore. This can be found by running the following SQL against the Person table.

[code]
SELECT * FROM Person
WHERE LastName = ';
[/code]

The value listed under IpPerson will be used in place of <'UserId'>.

As always, we recommend that you backup the configuration database before modifying it.

[code]
UPDATE StaffMemberRole
SET EndDate = '9999-12-31'
WHERE IpEmployee = <'UserId'>;

UPDATE IpRltshp
SET EndDate = '9999-12-31', EndReasonCode = NULL
WHERE IpChild = <'UserId'>;

UPDATE IpClass
SET EndDate = '9999-12-31'
WHERE IpId = <'UserId'>;
[/code]

Hopefully this information is helpful. Please let us know if you have any other questions/concerns.

Kind Regards,

Dustin