How to bulk modify the column format of reports

Heng Yu shared this question 42 days ago
Answered

I have over 200 report that needs to modify. For those reports that have the ItemRSN field need to modify that column filed format to "Link to URL"

Which tables contain that info, so I can write the SQL to modify the bulk report instead of do it one by one.

Thanks

Comments (1)

photo
1

Hi Heng,

You might want to take a look at the tables reportfield, reportfieldtemplate and reportfieldparameter. However making such changes are not recommended by us and outside the scope of support.

Please make sure you back up your Yellowfin configuration database before making changes. We cannot assist with any system instability introduced by making changes to the database.

Kind regards,

Chris

photo
1

Thanks for your help!

photo
1

No worries! I'll mark this as answered.

photo