Retrive Data from us_Data (SFSUsers)


Author
Message
Malcon M. Mikami
Malcon M. Mikami
StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
How can I recover data from the field us_data the table SFSUsers?
As I understand it, the field us_data, has the password, the history of passwords, where he is administrator, account is active and so forth.
Is there a method that returns this information?
If there are, some other member of the forum has done some function for that?

Como posso recuperar os dados do campo us_data da tabela SFSUsers?
Pelo que entendi, o campo us_data, possue a senha, o histórico de senhas, se ele é administrador, conta está ativa, etc.
Há algum metodo que retorne esta informação?
Caso não haja, algum outro membro do forum já fez alguma função para isso?

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
You are welcome to look at the SF source code, this is why you get the source with an active subscription.  But this is not intended to be broken apart.  It is encrypted so as not to be dismantled or compromised.  If you have this desire, then you are going to need to look at the SFSUsersBO source and start at the us_Data field and go from there.  That would be my only suggestion at this point.
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.4K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Malcon,



All of that data is available via the SFSUsersBO, via the us_XXX properties. If you need this data, just load the BO for a user via the FillByPrimaryKey() method then you will have access to it (there are several other FillBy methods too).



Also, the user user PK (use this to load SFSUsersBO for a user), user name and flag if the user is an administrator are available for the current user (SecurityBasics.CurrentUser), via the UserPK, UserName and IsAdministrator properties, respectively.



As Trent said, I'd be careful about getting this data directly from the us_data field. If SF changes anything within this table (like the structure or how they encrypt it), for whatever reason, any code you have will likely break. Be sure to comment these sort of changes so you can find them easily!
Malcon M. Mikami
Malcon M. Mikami
StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
OK, tanks.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search