---
title: "Fix Invalid JQL"
canonical: "https://support.appfire.com/space/SUPPORT/80117823/Fix%20Invalid%20JQL"
format: markdown
---
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:

```sql
SELECT * FROM SEARCHREQUEST;
```

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

```sql
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:

```sql
SELECT * FROM AO_60DB71_QUICKFILTER;
```

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

```sql
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:

```sql
SELECT * FROM AO_60DB71_CARDCOLOR;
```

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

```sql
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:

```sql
SELECT * FROM AO_60DB71_SUBQUERY;
```

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

```sql
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:

```sql
SELECT * FROM AO_54307E_QUEUE;
```

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

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