community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Hide Folder "People"

Alteryx Certified Partner

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

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 Connect
Alteryx Certified Partner

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

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 Connect
Alteryx Certified Partner

Correct - Hoping to restore as it was

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 Connect