[uportal-dev] SQL for users that customize layout

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[uportal-dev] SQL for users that customize layout

Benito Gonzalez-2
Hi folks,

If you wonder who has customized their uPortal layout, this SQL will list the user names:

select user_id, user_name from up_user_layout
left join up_user on up_user_layout.user_id = up_user.user_id
where user_name not like '%-lo'
and user_name <> 'system';

Hope this helps someone!

--
Benito J. Gonzalez
Software Architect
Unicon, Inc.
Voice:  209.777.2754
 Text:  209.777.2754
GitHub:  bjagg
GitLab:  bjagg
BitBucket:  bjagg

--
You received this message because you are subscribed to the Google Groups "uPortal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-dev/CAJ_1GkTRzZ7RzpwRn8HeuZGLwQdQW7LZZ2eQaOiLniOFj7F2dg%40mail.gmail.com.