Jira boards with missing filters
This insight checks if any of your boards use JQL filters that no longer exist.
What's the problem?
Boards using JQL filters that no longer exist won't block your migration, but might result in data loss or missing entities in Jira Cloud. To avoid these issues and keep your instance clean, we recommend that you fix the boards before you migrate.
What’s the recommendation?
To avoid issues with missing entities in Jira Cloud:
Review affected boards to know which ones you need to optimize
Update the board filters before you migrate. You can either do it in Jira by editing each board or modify your database to update the boards in bulk.
If some of the boards turn out to be old and no longer needed, you can also delete them to keep your instance clean.
Update the board filters
Follow these steps to update board filters.
Review affected boards
When viewing this insight from Portfolio insights, copy the SQL query (also pasted below). The query returns boards with missing filters, together with:
Board name, board owner, foreign key ID from the Board Admins table (which is the board ID when an admin row exists)
SELECT DISTINCT
rv.ID AS "Board ID",
rv.NAME AS "Board Name",
rv.OWNER_USER_NAME AS "Board Owner",
ba.RAPID_VIEW_ID AS "Foreign Key ID from the Board Admins table"
FROM AO_60DB71_RAPIDVIEW rv
LEFT JOIN searchrequest sr ON (rv.SAVED_FILTER_ID = sr.id)
LEFT JOIN AO_60DB71_BOARDADMINS ba ON (rv.ID = ba.RAPID_VIEW_ID)
WHERE NOT EXISTS (
SELECT *
FROM searchrequest
WHERE id = rv.SAVED_FILTER_ID
)
ORDER BY rv.ID;Fix 1: Update board filter in Jira UI
To update the board's main JQL filter:
In Jira, go to Boards > View all boards.
Search for the affected board returned by the SQL query.
Select ... > Configure.
Change the Saved filter to an existing filter. It can be one of your existing filters or you can create a dummy filter to be used by all affected boards.
Fix 2: Update board filters directly in the database
You can also update all affected boards to use a dummy filter directly in the database.
Create a dummy filter
Create a dummy filter in Jira UI and use the following query to retrieve its ID.
SELECT id FROM searchrequest WHERE filtername = '<dummy filter name>';Update the affected boards
Once you have the filter ID, use the following query to update all affected boards to use it.
PostgreSQL
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" );Oracle, MySQL, Microsoft SQL Server
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 );Alternative fix: Deleting affected boards
If the boards are old and not used, you can also delete them to keep your instance clean.
For more info on how to do it, see Boards with non-existent filters.
Was this helpful?