Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Hide Folder "People"

joshuaburkhow
ACE Emeritus
ACE Emeritus

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

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
5 REPLIES 5
VojtechT
Alteryx
Alteryx

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.

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
joshuaburkhow
ACE Emeritus
ACE Emeritus

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

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
VojtechT
Alteryx
Alteryx

 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.?

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
joshuaburkhow
ACE Emeritus
ACE Emeritus

Correct - Hoping to restore as it was

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
VojtechT
Alteryx
Alteryx

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
Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY