Where are user favorites stored?

Favorite records always have a login node (root node) based on the user’s login id.
It is stored in the F9000 table and has the taskname (TMLNGTASK) “@userid”.
The user’s Favorites tasks are stored in the F9000 table, but the fact that they are components of the user’s Favorites is stored in the F9001 relationship table.

A lil bit of search on metalink and there u go !!
 
I brought this up at Collaborate last year as a modification they need to put in. When you remove a user, orphan records related to the userid are left in various files.
 
Back
Top