Content
View differences
Updated by Christophe Bliard 11 months ago
### Steps to reproduce
1. Go to the backlogs module
1. If you have the demo projects, go to the Scrum project, then choose Backlogs in the left pane
2. From a "sprint box", click the down arrow in the top-right corner. A menu opens. Select the menu entry "Stories/Task"
1. a work package list is displayed with user stories, tasks and bugs
3. Add a filter of type "Backlog type"
4. Set the "Backlog type" to either "Task", "Impediment", or "any" ("Story" is the only one which works)
### What is the buggy behavior?
* Error is displayed
#### Screenshots
<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/700047/content">
### What is the expected behavior?
1. Filter is applied
### Logs
[https://appsignal.com/openproject-gmbh/sites/673c8d4183eb67dcd6c4e764/exceptions/incidents/937](https://appsignal.com/openproject-gmbh/sites/673c8d4183eb67dcd6c4e764/exceptions/incidents/937)
[https://appsignal.com/openproject-gmbh/sites/6813715a55b0b20ed373597c/exceptions/incidents/961](https://appsignal.com/openproject-gmbh/sites/6813715a55b0b20ed373597c/exceptions/incidents/961)
```text
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:141 OpenProject::Backlogs::WorkPackageFilter#is_child_sql
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:127 OpenProject::Backlogs::WorkPackageFilter#sql_for_task
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:100 block in OpenProject::Backlogs::WorkPackageFilter#sql_for_field
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:95 Array#map
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:95 OpenProject::Backlogs::WorkPackageFilter#sql_for_field
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:51 OpenProject::Backlogs::WorkPackageFilter#where
app/models/query.rb:376 block in Query#statement
app/models/query.rb:376 Array#map
app/models/query.rb:376 Query#statement
app/models/query/results.rb:79 Query::Results#filtered_work_packages
app/models/query/results.rb:53 Query::Results#sorted_work_packages_matching_the_filters_today
app/models/query/results.rb:45 Query::Results#work_packages
app/services/api/v3/work_package_collection_from_query_service.rb:58 API::V3::WorkPackageCollectionFromQueryService#results_to_representer
app/services/api/v3/work_package_collection_from_query_service.rb:47 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:261 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_by_project_api.rb:52 block (3 levels) in <class:QueriesByProjectAPI>
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
```
1. Go to the backlogs module
1. If you have the demo projects, go to the Scrum project, then choose Backlogs in the left pane
2. From a "sprint box", click the down arrow in the top-right corner. A menu opens. Select the menu entry "Stories/Task"
1. a work package list is displayed with user stories, tasks and bugs
3. Add a filter of type "Backlog type"
4. Set the "Backlog type" to either "Task", "Impediment", or "any" ("Story" is the only one which works)
### What is the buggy behavior?
* Error is displayed
#### Screenshots
<img class="op-uc-image op-uc-image_inline" src="/api/v3/attachments/700047/content">
### What is the expected behavior?
1. Filter is applied
### Logs
[https://appsignal.com/openproject-gmbh/sites/673c8d4183eb67dcd6c4e764/exceptions/incidents/937](https://appsignal.com/openproject-gmbh/sites/673c8d4183eb67dcd6c4e764/exceptions/incidents/937)
[https://appsignal.com/openproject-gmbh/sites/6813715a55b0b20ed373597c/exceptions/incidents/961](https://appsignal.com/openproject-gmbh/sites/6813715a55b0b20ed373597c/exceptions/incidents/961)
```text
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:141 OpenProject::Backlogs::WorkPackageFilter#is_child_sql
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:127 OpenProject::Backlogs::WorkPackageFilter#sql_for_task
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:100 block in OpenProject::Backlogs::WorkPackageFilter#sql_for_field
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:95 Array#map
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:95 OpenProject::Backlogs::WorkPackageFilter#sql_for_field
modules/backlogs/lib/open_project/backlogs/work_package_filter.rb:51 OpenProject::Backlogs::WorkPackageFilter#where
app/models/query.rb:376 block in Query#statement
app/models/query.rb:376 Array#map
app/models/query.rb:376 Query#statement
app/models/query/results.rb:79 Query::Results#filtered_work_packages
app/models/query/results.rb:53 Query::Results#sorted_work_packages_matching_the_filters_today
app/models/query/results.rb:45 Query::Results#work_packages
app/services/api/v3/work_package_collection_from_query_service.rb:58 API::V3::WorkPackageCollectionFromQueryService#results_to_representer
app/services/api/v3/work_package_collection_from_query_service.rb:47 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:261 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_by_project_api.rb:52 block (3 levels) in <class:QueriesByProjectAPI>
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
```