ReportSQL - Users

User's Style Template Preference

• Text formula field on a System Users report
• "Use site setting" is displayed if a user has never made a selection for Style Template

(SELECT COALESCE(lst.name, 'Use site setting')
FROM users u
JOIN prefs p ON p.key = 'style_template'
LEFT JOIN prefs_data pd ON pd.user_id = u.id AND pd.prefs_id = p.id
LEFT JOIN lookup_style_template lst ON lst.id::text = pd.value
WHERE u.login = %tableAlias%.login)