Access CMS_User table data inside Kentico related pages transformation

Question

I have a related pages Webpart to display key team members username and some details in CMS_User table. How can I access the CMS_User table data inside related page webpart transformation.

Answer 1

You can:

• Add a custom transformation method (I'd probably recommend this)
• Use a macro, e.g. CMSContext.Current.GlobalObjects.Users["username_of_your_choice"].FullName
• Use a transformation for a macro expression