We have asked our user population to "change their avatar". Is there a way for me to query all users with the default avatar assigned to their profile?
Did some readin up.. This is how to display all users without a avatar picture:
select t1.lower_user_name from cwd_user t1 left join avatar t2 on t1.lower_user_name = t2.owner where t2.owner is null;
Enjoy!
If a user have not selected their own avatar they will not be in the JIRA avatar mysql-table. There is probably a nice nested query to see which users exist in the user table and cross reference it to the owner cell of the avatar table, but not being a great SQL ninja, i can only list the user that DID change their avatars by running
select distinct owner from avatar;
You should be able to do something like this:
select avatar.owner from avatar where avatartype='user' AND avatar.owner NOT IN (select cwd_user.lower_user_name from cwd_user);
Not sure where this breaks but if you have a DBA around maybe he can help you finetune it. Please post the answer here, it's good practice for my mysql-fu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.