worklog table in Jira database contains rows that aren't displayed in reports

Piotr Lebryk March 31, 2021

I use sql queries to get data for worklog reports. What I've noticed is that there are some worklogs that appear in table public.worklog but are somehow filtered by plugins like timesheets Plugin. The results from plugin are correct. I suspect that the problem is with edited worklogs. I can't find a way to tag rows from public.workflow that should be skipped. Is anybody have similar problem? Is there any other table in database that contains information that can be helpful in pointing affected rows?

0 answers

Suggest an answer

Log in or Sign up to answer