nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find which are the users which perform actions in Jira using SQL ?

Hi All,

Can you please help me identify the SQL query to find the following information :

In the last 3 month who are the users which Created Issues OR Updated Issues OR Being assigned to Issues

Thanks a lot in advance

Naama

Accepted answers

Hello,

Look at the jiraissue, changegroup and changeitem tables.

All comments

Hello,

Look at the jiraissue, changegroup and changeitem tables.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

sql

jira

database

user-management