Degraded performance Customers may experience issues using Community search. Our team is investigating.
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.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...
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