Please avoid using the database, it's complex, messy and if you get it wrong, you can destroy your installation, and you will not technically be supported if anything goes wrong.
A far better option on the first one is really simple. Run and save a filter for "custom-field is not empty". Use that filter in a "filter statistics" gadget and group by the custom field. You'll get all the values, and a count of usage.
Nope, because you haven't really told me what data you think you want from the custom fields, so I'm guessing. And a filter is a far better, safer way to do it. SQL is a last resort and a terrible idea.
The SQL for the user changes is "update cwd_user with your changes". Remember to take a full backup before you run it, and have JIRA totally shut down when you do it.
I think there may be some confusion here.
The problem we have is that we’ve changed email address format for our users so for example where users used to be email@example.com is now firstname.lastname@example.org
Consequently we need to update approx. 2000 user records and was wondering what would be the best method to achieve this
We are not looking to update any custom fields
If doing this via sql is not recommended then that's fine – we will look at alternative methods (any suggestions you have will be appreciated)
There's no confusion, you're trying to change email addresses on user accounts. It's not advisable to do it with SQL, but you can do it. I don't know why you keep asking about it, or why you've suddenly started looking at the login ids when you're only interested in email.
Secondly, you specifically asked about custom fields. You've had an answer to that as well.
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs