Querying Swimlanes & Quick Filters

[Andrew Wolpers]

I'm writing a script to query where a custom field appears in a number of locations. This script will be used to identify dependencies and impacts when changing a custom field's name or type. 

I have been able to query filters/gadgets that contain custom fields, but I'm looking for other ways to query the following:

Jira Board Content

• Swimlanes containing Custom Field
• Quick filters containing custom field
• Card layouts containing custom field

I found a few other answers that had mentioned the boards don't actually store any information in the database or the API itself. Has anyone been able to find a different workaround?

[Andrew Wolpers · Accepted solution]

With the help of Atlassian, I was able to find the tables for these:

• Swim Lanes: AO_60DB71_SWIMLANE ("LONG_QUERY" column)
• Quick Filters: AO_60DB71_QUICKFILTER ("LONG_QUERY" column)
• Card Layouts: AO_60DB71_CARDLAYOUT ("FIELD_ID" column)