The text in the wiki describes that the tool will hard delete all users that are marked IsDeleted in the Users table... Or at least that's the way I read it the first three times I tried working with it tonight... doesn't matter that last year when I tacked the same thing I instantly started in the UserPortals table, but anyhow, the thing that I was recommending is that you might point out that there's still an IsDeleted field in the primary Users table, but that value alone doesn't make a user Soft Deleted so that they'll show in the tool.
Suggest to people that if they have already marked the Users table record with IsDeleted = 1, then they can run this additional script to make the user's other important record match for the IsDeleted value
UPDATE UserPortals SET IsDeleted='True' WHERE (UserID IN( SELECT UserID FROM Users WHERE IsDeleted = 1) )
The text in the wiki describes that the tool will hard delete all users that are marked IsDeleted in the Users table... Or at least that's the way I read it the first three times I tried working with it tonight... doesn't matter that last year when I tacked the same thing I instantly started in the UserPortals table, but anyhow, the thing that I was recommending is that you might point out that there's still an IsDeleted field in the primary Users table, but that value alone doesn't make a user Soft Deleted so that they'll show in the tool.
Suggest to people that if they have already marked the Users table record with IsDeleted = 1, then they can run this additional script to make the user's other important record match for the IsDeleted value
UPDATE UserPortals SET IsDeleted='True' WHERE (UserID IN( SELECT UserID FROM Users WHERE IsDeleted = 1) )