Where favourite stored ?

[puja kumari]

Hi Team,

I have migrated bookmarked table records from different instance but when i am impersonating the user who has bookmarked any articles  but its not showing in their favorite. could you please help me with this. how this works.

Thanks

[James Chun]

Hey @puja kumari,

Are you referring to the 'favorite' functionality in the employee center?

If so, they are stored in Portal Favorites [sp_favorite] table.

Cheers

[puja kumari]

@James Chun  ,

Yes that is correct but actually I have migrated bookmarked table records from different instance but when i am impersonating the user who has bookmarked any articles  but its not showing in their favorite. could you please help me with this. 

[swathisarang98]

Hi @puja kumari ,

How are you moving the records from instance to instance ?and also there are other tables which holds favorite  please have a look below,

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[James Chun]

I believe the sys_id of the user record and the bookmarked record need to be identical in both instances for that to work. If you are simply migrating via XML, these references may break.

Can you post a screenshot of the Portal Favorite record in the target instance?