Hide Folder "People"

[joshuaburkhow]

A user has deleted the people folder. How do we get it back? We see it in the inactive section of the admin console. 

[VojtechT]

Hi, the easiest way might be to do it in the db. 

Do you know how to connect to the db and do the changes there? Then it's mostly about updating few attributes in the 'entry' table.

[joshuaburkhow]

I think so, do you have scripts already for it or steps written?

[VojtechT]

 No, unfortunately I don't. I'm looking into some easier way of getting the folder back. But actually that would make the folder in the initial state, i.e. empty of users with the default groups. I guess you already had some users there and don't want to create them again, especially if they are already linked as owners, contributors, etc.?

[joshuaburkhow]

Correct - Hoping to restore as it was

[VojtechT]

This might be the solution, but I haven't had time to test it yet and probably will not have any until tomorrow. But if you feel confident, you can give it a try. 

I have to warn you though that any change right in the database can be really tricky and backup should always be created before any such change.

Update STD_XFORMS.ENTRY 
    set ENTRY_VALID_TO = 9999999999000, ENTRY_CURRENT = true
where ENTRY_PUBLIC is TRUE 
    and ENTRY_CURRENT is false
    and ENTRY_VALID_TO < 9999999999000