This is an old revision of the document!
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=99999; //<- 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); //Now finally delete the record in primary table:// DELETE FROM AO_60DB71_RAPIDVIEW WHERE SAVED_FILTER_ID=999;