Adding a report favorite via script

[Brandon_Brown]

Our organization has a need to take a series of reports and add them as a "report favorite" for a group of employees. What field marks a report as a report favorite (the star in the report system)? I looked the sys_report table and did not see a boolean field that would mark this.

What field in what table makes a report a 'favorite'?

[BalaG]

Hi @Brandon_Brown   it is stored in sys_user_preference table as list of comma separated report sys_ids under preference name "reporting_favorites"    Below is an example  record for admin user on my PDI

 

hope that helped

--

Bala Guthy