Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Searching ALL Swimlanes (and Quick Filters) for String

Andrew Wolpers January 24, 2023


A while back I built a script console tool to assist with identifying when a custom field appears in:

  • User Filters
  • Swimlanes
  • Quick Filters
  • Board Gadget configurations

This mostly worked with some caveats for formatting. I'm looking to make some improvements and convert most of these queries from SQL queries to using the API.

I am looking to make this more useful (and stay away from the DB) when identifying fields to combine/merge and assess the impacts of making a change like that.

The current database queries look something like:

def swimlaneQuery = """


""" //todo: update these to account for variables

def gadgetQuery = """

SELECT, portalpage.pagename, portalpage.username FROM portalpage INNER JOIN portletconfiguration ON = portletconfiguration.portalpage INNER JOIN gadgetuserpreference ON = gadgetuserpreference.portletconfiguration WHERE userprefvalue = '${CUSTOM_FIELD_ID};


def quickFilterQuery = """




I'm being reminded why I initially went with the Database queries for the boards. I'm finding ways to make updates to a specific board (using, but I'm not finding a great/obvious way to gather and search all Swimlanes and Quick filters like I am filters (where I am essentially just opening each filter, looking for a match, and returning various data about the filters).

Can anyone point me in the right direction for what I need to be using to get ALL quick filters/Swim lane configurations in the app without specifying a board?

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
0 votes
Answer accepted
Andrew Wolpers March 2, 2023

Ended up being:

def filterQuery = """
SELECT "id","reqcontent","filtername" from "searchrequest" WHERE "reqcontent" ilike ${formattedCustomField};
AUG Leaders

Atlassian Community Events