Forum

This content is now out of date.

Visit Our Community

Restore a deleted user

Hi,

We delete a user, and now we would like to restore his user.
is there a way to do so through the YF tool (not repository).

Thanks,
Tal
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

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.