# Bug OP-18639 - Using "is empty" or "is not" on custom field breaks baseline query

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-18639

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module | Modules and project features / Baseline, Modules and project features / Work packages |
| Target versions | 17.0.3 |
| Observed in versions | 17.2.0 |
| Sprint | 17.0.3 |
| Backlog bucket |  |
| Bug found in version (deprecated) | 17.2.x |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers | Attila Dombi |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### Steps to reproduce

1.  Go to the work package list
    
2.  Configure a filter with:
    
    1.  User custom field with the "is empty" operator
        
    2.  Hierarchy custom field with the "is not" operator
        
    3.  (there might be more cases)
        

### What is the buggy behavior?

*   The query errors (500)
    

### What is the expected behavior?

1.  The filter should be applied successfully and the expected results should be returned
    

### **Logs**

```text
ERROR:  missing FROM-clause entry for table "custom_values"
LINE 22: ...     WHERE customizable_journals.value IS NULL OR custom_val...


lib/api/v3/work_packages/work_package_collection_representer.rb:229 API::V3::WorkPackages::WorkPackageCollectionRepresenter#paged_models

lib/api/decorators/offset_paginated_collection.rb:46 API::Decorators::OffsetPaginatedCollection#initialize

lib/api/v3/work_packages/work_package_collection_representer.rb:60 API::V3::WorkPackages::WorkPackageCollectionRepresenter#initialize

app/services/api/v3/work_package_collection_from_query_service.rb:153 Class#new

app/services/api/v3/work_package_collection_from_query_service.rb:153 API::V3::WorkPackageCollectionFromQueryService#collection_representer

app/services/api/v3/work_package_collection_from_query_service.rb:66 API::V3::WorkPackageCollectionFromQueryService#results_to_representer

app/services/api/v3/work_package_collection_from_query_service.rb:49 API::V3::WorkPackageCollectionFromQueryService#call

lib/api/v3/queries/helpers/query_representer_response.rb:38 block in API::V3::Queries::Helpers::QueryRepresenterResponse#query_representer_response

lib/api/root_api.rb:262 API::RootAPI::Helpers#raise_invalid_query_on_service_failure

lib/api/v3/queries/helpers/query_representer_response.rb:35 API::V3::Queries::Helpers::QueryRepresenterResponse#query_representer_response

lib/api/v3/queries/queries_api.rb:134 block (3 levels) in <class:QueriesAPI>

vendor/plugins/openproject-multitenancy/lib/multitenancy/elevators/mapped_domain_elevator.rb:106 block in Multitenancy::Elevators::MappedDomainElevator#call_tenant

vendor/plugins/openproject-multitenancy/lib/multitenancy/elevators/mapped_domain_elevator.rb:103 Multitenancy::Elevators::MappedDomainElevator#call_tenant

vendor/plugins/openproject-multitenancy/lib/multitenancy/elevators/mapped_domain_elevator.rb:69 Multitenancy::Elevators::MappedDomainElevator#try_tenant

vendor/plugins/openproject-multitenancy/lib/multitenancy/elevators/mapped_domain_elevator.rb:39 Multitenancy::Elevators::MappedDomainElevator#call
```

https://appsignal.com/openproject-gmbh/sites/673c529383eb67b55471dda2/exceptions/incidents/996/samples/673c529383eb67b55471dda2-1215723294708156108617682148201