Work log author name wrong

Hi Support,

We tried to get work log from Jira API. However, we found that certain work log throw wrong author name as the it's username.I found that in the app_user table, the user's user_key is the same as the author name so I changed that to be the same as current username. 

However, it still doesn't update in the work log. 

Please advise,

1 answer

0 vote

So the app_user.user_key field will match the username in JIRA when the account is first created in JIRA.  But if that account has ever been renamed in JIRA, then the cwd_user table gets updated with the new values (along with the app_user.lower_user_name value) while the app_user.user_key field is expected to remain the same in JIRA, forever.   

If you modified that field directly via SQL then I fear you might have messed with the way JIRA is storing that historical information such as worklogs and issue edit history.

But back to the worklog problem, I think you are seeing a known bug in JIRA JRASERVER-36642

The good news is that there is a workaround for this on that bug ticket:


Use the /rest/api/2/user endpoint to retrieve the user's username based on its key. This should return something like:


    "active": true,
    "avatarUrls": {
        "16x16": "http://localhost:8080/jira/secure/useravatar?size=xsmall&avatarId=10122",
        "24x24": "http://localhost:8080/jira/secure/useravatar?size=small&avatarId=10122",
        "32x32": "http://localhost:8080/jira/secure/useravatar?size=medium&avatarId=10122",
        "48x48": "http://localhost:8080/jira/secure/useravatar?avatarId=10122"
    "displayName": "Matheus Fernandes",
    "emailAddress": "",
    "expand": "groups",
    "groups": {
        "items": [],
        "size": 7
    "key": "matheus",
    "locale": "en_US",
    "name": "mfernandes",
    "self": "http://localhost:8080/jira/rest/api/2/user?username=matheus",
    "timeZone": "Brazil/East"

Suggest an answer

Log in or Join to answer
Community showcase
Maarten Cautreels
Posted Thursday in Off-topic

Friday Fun: What's your favourite beer/drink

As a Belgian, beer-lover and home brewer, beer is one of my great passions. I love the fact that with just a few ingredients (usually just water, hop and malt) you can create so many different tastes...

285 views 38 9
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot