StrataFrame Forum

Custom Fields to SFSUser table

http://forum.strataframe.net/Topic5853.aspx

By Guillermo Vilas - 1/16/2007

Hello

What is the best way to extend the SFSUser Table to add custom user fields (eg. EmployeeID, Title, Phone Numbers)

Thanks
By StrataFrame Team - 1/16/2007

You best bet would probably be to add table to your database to store that information and tie the records to the SFSUsers table through the us_pk field.  Then, you would just need to create a business object for that table and a form to allow the information to be edited/maintained.
By Larry Caylor - 1/16/2007

I don’t know what others are doing, but as Ben suggests, I started out by adding a table to the data base to hold the additional user fields that contained a foreign key from SFSuser.  As Ben would probably not recommend, I modified the SF user maintenance dialog by adding a tab to maintain the added info along with a BO that mapped to my new table. It looked and worked great, however keeping my version of Role Based Security in sync the SF release quickly got old. I ended up building my own “Additional User Info” maintenance screen that has the same look and feel of the SF user maintenance dialog. On my main form I have a User maintenance menu with “Security” and “User Info” sub menus to bring up the proper dialog.

 

I also added some logic to AppMain that checks to make sure the additional user info fields are populated when the user logs in and exposes those fields via public properties of a static class.  

 

-Larry

By Guillermo Vilas - 1/16/2007

Thanks for the advices

I was thinking of two approaches:



1) Creating a separate security assembly that contains the custom field depending on client request (I did it similar when enhacing the inherited ui assembly for a third party control suite not supported) it will be easier to maintain between StrataFrame releases.



2) The approach of creating another table at application level.



what do you think?