Print  
Gray star Gray star Gray star Gray star Gray star --Not rated--
240 Visits 3 Comments
Created
Andreas Ollenburg Andreas Ollenburg
Kablink Component
  • Teaming

HI there,

I extended the user profile with some custom fields. Where are they stored? I have some SQL statements to export user informations but I cannot find the new fields in the SS_principals table. Any hints where to look at?

 

Greetings

Andreas

 

Workflow
Process State Action
Discussion workflow Active
This entry is currently active
Attachments(0)
Entry History
Tags
 
Replies
Thumbnail Image
Peter Hurley (Novell) Peter Hurley (Novell)

All of the custom attributes (which is what the additional elements are called) are stored in the ss_CustomAttributes table. You can get the list of custom attributes from that table by fetching all records where the "ownerId" is the id of the entry that you want and the "ownerType" is the type of the entry (e.g., folder, folderEntry, user). (You also have to specify the "zoneId" of your zone.) The results will include all of the additional data fields that you added to the profiles.

In the case of a user profile you must fetch records where the "ownerId" is the userId of the profile that you are looking for and the "ownerType" is "user". You then have to get the appropriate data from your results. Most of your profile information will be strings, so you get the "stringValue" data item. You may also have a block of text which might be stored in the "description_text" column.

Thumbnail Image
Andreas Ollenburg Andreas Ollenburg

Thanks Peter!

Thumbnail Image
Sea Sea

Hi there.

Where can I get Cablink Database Documentation?

I mean full Tables and Fields description.

 

Thanks.

Skip Footer Toolbar