...
Solution
Jira Legacy |
---|
server | Jiwa ServiceSystem JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | f9231aec91fbcd9b-a65a5d0b-32ae3b97-94f3a585-7114fec5f2531a06ec62a231 |
---|
key | DEV-5192 |
---|
|
Warning |
---|
title | SQL skills are required |
---|
|
A sound knowledge of SQL is required to complete this task. |
...
A modified report and stored procedure is attached to the article to that excludes reversals from the report. This correction has been included in 7.01.00 and higher
Panel |
---|
|
Download and save the attached stored procedure and report and then
- Run the SQL script over the relevant database
- Run stored procedure Grant_All_User_Tables
- Login to the database
- System Settings > Report Configuration > Reports
- Click Refresh from Files
- Select the report to be imported and OK
- Message displays to indicate report has been successfully updated
NOTE: If you get the error 'Database vendor error code 229 ...' when running the report, then step 2 has been missed. |
...