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; } } }

Get status of issues on a particular date -SQL Server

Pushparaj Bhask

I need to get the status of all issues on a particular date using SQL query .

Please suggest

Accepted answers

All comments

Norman Abramovitz

Here is a query that you can modify to get what you want. It gets status counts on a particular date.

https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindStatuscountsforaProjectonagivendate

Pushparaj Bhask

This is giving errors on SQL server as follows:

Operand type clash: ntext is incompatible with numeric

Norman Abramovitz

This query is closer to what you need.

https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA#ExampleSQLqueriesforJIRA-FindStatusesofallissuesinaprojectonagivendate

Frédéric Tardieu_huminder_

Hi Pushparaj,

If you want to get this in a visual way without writting any SQL, you can use Graphit plugin with its "status" view. It will show you statuses evolution of one issue or all issues of any project, over dates or over vesions. You can also display in the same view who authored the status changes.

Best regards,

Frédéric

Norman Abramovitz

You have to adjust the query for the database you are using since these queries are on MySql. You need a cast operation.