Why is change group author empty?

[Veera rdy]

Hello,

When I search using the below query, I get thousands of records out of which few have an empty change group author. Why is the change group author empty?

select *
from jira_app.changegroup

Please advice.

Thanks.

[Brittany Wispell]

Hey @Veera rdy

It could be that something other than a user made the change (integration, post function, etc.) 

Try getting the change history through the Jira API and see if you get the same results. 

actionManager.getChangeHistory(getIssue(), authenticationContext.getUser());

Here's some documentation on Database - Change History for reference. 

Database Change History 

Hope this helps. 

[Nic Brough -Adaptavist-]

There are a few reasons this can happen, but I am not going to write an essay on it here, as it's long, boring and utterly pointless.

Could you try looking properly instead?  Use the internal java api or external REST api to look at what you want (SQL is the worst possible way to look at Jira data, please don't use it)