Favorites in database

Mats_Svedberg_(bayoneuser3_-_(deleted))

Hi!Where in the database does it show that a user has added an livelink object as a favorite?Regards/Mats

Steve Brezina

Hi Mats, Favorites are stored in the KUAFPrefs table. The following SQL will retrieve the favorites for all users. PrefsID is the UserID, and PrefsValue is an string-ified Assoc containing the state of the user's favorites tabs. The value of the Contents key inside the PrefsValue Assoc contains the DataIDs of the actual favorites. SELECT PrefsID, PrefsValue FROM KUAFPrefs WHERE PrefsKeyword = 'PersonalFavoritesTabs'Hope this helps.Regards, Steve