PawelWiki

Below is the list of SQL queries to perform tasks directly on the database. Please note that you should always shut down Jira & backup your database before performing any of these queries.

select * from sys.tables

select * from sys.columns

SELECT t.name AS table_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
order by table_name

select * from cwd_user where lower_user_name = 'abc'

SELECT * from cwd_group

select * from cwd_directory

select * from cwd_user where directory_id = 1 and (user_name != 'abc' and user_name != 'cde' and user_name != 'sysadmin');

select id, directory_name, active from cwd_directory;

Then you want to use this information to disable the directory

update cwd_directory set active=0 where id=123456;

SELECT *
FROM AO_60DB71_RAPIDVIEW
WHERE SAVED_FILTER_ID=55555; //<- this is the filter id mentioned in the error//
 
//Take a note of the ID field value (eg.: 999), and delete the reference records from the below tables as below://
 
DELETE
FROM AO_60DB71_BOARDADMINS
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_DETAILVIEWFIELD
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_ESTIMATESTATISTIC
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_QUICKFILTER
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_STATSFIELD
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_SWIMLANE
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_TRACKINGSTATISTIC
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_WORKINGDAYS
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_CARDCOLOR
WHERE RAPID_VIEW_ID=999;
 
DELETE
FROM AO_60DB71_SUBQUERY
WHERE RAPID_VIEW_ID=999;
 
//Take a note of the IDs from the table AO_60DB71_COLUMN//
SELECT * FROM AO_60DB71_COLUMN
WHERE RAPID_VIEW_ID=999;
 
Example results: 1,11,111.
 
//Delete these references in table: AO_60DB71_COLUMNSTATUS//
DELETE FROM AO_60DB71_COLUMNSTATUS
WHERE COLUMN_ID IN (1,11,111);
 
//Then delete the primary record of AO_60DB71_COLUMN table//
DELETE FROM AO_60DB71_COLUMN
WHERE RAPID_VIEW_ID=999;
 
//Now finally delete the record in primary table://
DELETE 
FROM AO_60DB71_RAPIDVIEW
WHERE SAVED_FILTER_ID=55555;

select distinct(U.display_name), U.lower_user_name, U.email_address, G.parent_name 
from cwd_membership G, cwd_user U 
where G.parent_name = <<group_name>>
and G.lower_child_name = U.lower_user_name
and U.active='1'
order by U.display_name;