Fix Invalid JQL

Invalid JQL can be part of different objects. In some cases, you need to fix it directly in the database because the operation cannot be performed in the UI.

Filters

A filter can cause problems not only in the single filter but also in the Board Filter and in the filter of Dashboard Filter Result Gadget.

The database table which contains information about Filters is SEARCHREQUEST. To see all available filters in the database you can perform this query:

SELECT * FROM SEARCHREQUEST;

Example query for fixing the broken JQL can be found below:

UPDATE SEARCHREQUEST
SET REQCONTENT = 'new JQL query'
WHERE ID = 'id of the broken filter';

Board Quick Filters

The database table which contains information about Board Quick Filters is AO_60DB71_QUICKFILTER. To see all available board quick filters in the database you can perform this query:

SELECT * FROM AO_60DB71_QUICKFILTER;

Example query for fixing the broken JQL can be found below:

UPDATE AO_60DB71_QUICKFILTER
SET LONG_QUERY = 'new JQL query'
WHERE ID = 'id of the broken board quick filter';

Board Card Colors

The database table which contains information about Board Card Colors is AO_60DB71_CARDCOLOR. To see all available board card colors in the database you can perform this query:

SELECT * FROM AO_60DB71_CARDCOLOR;

Example query for fixing the broken JQL can be found below:

UPDATE AO_60DB71_CARDCOLOR
SET VAL = 'new JQL query'
WHERE ID = 'id of the broken board card color';

Board Subquery

The database table which contains information about Board Subquery is AO_60DB71_SUBQUERY. To see all available board subqueries in the database you can perform this query:

SELECT * FROM AO_60DB71_SUBQUERY;

Example query for fixing the broken JQL can be found below:

UPDATE AO_60DB71_SUBQUERY
SET LONG_QUERY = 'new JQL query'
WHERE ID = 'id of the broken board subquery';

Service Desk Queues

The database table which contains information about Service Desk Queues is AO_54307E_QUEUE. To see all available queues in the database you can perform this query:

SELECT * FROM AO_54307E_QUEUE;

Example query for fixing the broken JQL can be found below:

UPDATE AO_54307E_QUEUE
SET JQL = 'new JQL query'
WHERE ID = 'id of the broken service desk queue';