1. Getting the ID:

1. From Issue Navigator, it will be in the URL as given in the below example:

   http://yourserver/issues/?filter=36633

   The filter id is 36633 in this example.

2. Or through the database:

SELECT id FROM searchrequest WHERE filtername = '<dummy filter name>';

2. Updating the database:

UPDATE "AO_60DB71_RAPIDVIEW" rv
   SET "SAVED_FILTER_ID" = <filter ID from the SELECT above>
 WHERE NOT EXISTS ( SELECT id FROM searchrequest WHERE id = rv."SAVED_FILTER_ID" );

UPDATE AO_60DB71_RAPIDVIEW
   SET SAVED_FILTER_ID = <filter ID from the SELECT above>
 WHERE NOT EXISTS ( SELECT id FROM searchrequest WHERE id = AO_60DB71_RAPIDVIEW.SAVED_FILTER_ID );

3. Refreshing the cache:

Since manual intervention on the database doesn't not automatically refresh the cache related to these configuration, you have two options:

• Option A:

Restart Jira. This will recreate all cache.

• Option B:

run the following command on a terminal:

Or you can paste that on a browser where you have already authenticated:

<JIRA_BASE_URL>/rest/greenhopper/1.0/configuration/cache/flushAll

This is the expected output:

GreenHopper caches flushed%

In case there are a large number of boards that you want to delete and prefer to go with fix 2, with the dummy filter provided above, please try the following:

1. Before the second step to update the database with the dummy filter ID, run the below query to note down the IDs for the boards which have lost their corresponding filter with a query as follows. 

   PostgreSQL

   SELECT DISTINCT rv."ID" AS "Board ID"
    FROM "AO_60DB71_RAPIDVIEW" rv
    LEFT JOIN searchrequest sr ON (rv."SAVED_FILTER_ID" = sr.id)
    WHERE NOT EXISTS (SELECT * FROM searchrequest WHERE id = rv."SAVED_FILTER_ID") 
    ORDER BY rv."ID";

2. Copy the output of the above query to a file called data.txt. Remember to remove the column name "Board ID" from the file.

3. Then follow the rest of the steps in the Fix 1 section above starting from step 2 to update the boards with a dummy filter. Proceed to refresh the cache

4. Finally run the below curl command to delete all the rapid boards that have been associated with the new dummy filter, after substituting for username and password and JIRA_BASE_URL. It should be run from the directory where the data.txt file was stored. It should return a 204 for every successful deletion.

   Delete Boards

   xargs -I{} curl -v -u user:pass -X DELETE -H "Content-Type: application/json" JIRA_BASE_URL/rest/agile/1.0/board/{} < data.txt